blob: 4277bafebbc22617f62004b10ec6230960a735d3 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
|
#!/bin/bash
set -e
html=0
output=""
prefix=""
time=""
local=0
verbose=0
filter="cat"
pager="${QDB_PAGER:-${PAGER:-cat}}"
# Table output mode by default
sep="〠"
output="-list -separator $sep"
filter="column -t -s $sep"
while getopts "lcheqtv" opt; do
case "$opt" in
l)
local=1
;;
h)
html=1
output="-html"
filter="cat"
pager="${HTML_VIEWER:-$pager}"
;;
e)
prefix="EXPLAIN "
;;
q)
prefix="EXPLAIN QUERY PLAN "
;;
t) # Run with the time command.
time="time"
;;
v)
verbose=1
;;
*)
exit 1
esac
done
shift $(($OPTIND - 1))
db="$1"
shift
if ! [[ -t 1 ]] ; then
pager="cat"
fi
if (( $verbose )) ; then
echo "DB: $db" 1>&2
fi
query="$*"
run_query() {
if (( $local )) ; then
test -f "$db" && $time sqlite3 $output -nullvalue "[NULL]" -header "$db" "$prefix$query"
else
query=$(sed -e "s!'!\'\\\'\'!g" <<<"$query") # Escape for shell
adb shell -T "(" test -f "$db" "&&" $time sqlite3 $output -nullvalue "[NULL]" -header "$db" \'"$prefix$query"\' ")" "2>&1"
fi
}
{
if (( $html )) ; then
cat <<EOF
<head>
<style>
body {
font:8pt monospace;
}
table {
border: 1px solid black;
border-collapse: collapse;
}
</style>
</head>
<body>
<table border="1">
EOF
run_query
cat <<EOF
</table>
<body>
EOF
else
run_query
fi
} | $filter | $pager
|
