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
|
"""
usage: sql_repl <dbname>
"""
# alias sql_repl="rlwrap -m python ~/gcode/sqlplain/doc/sql_repl.py"
import os, sys, subprocess
from sqlplain import connect
def less(text):
"Send a text to less via a pipe"
# -c clear the screen before starting less
po = subprocess.Popen(['less', '-c'], stdin=subprocess.PIPE)
try:
po.stdin.write(text)
po.stdin.flush()
except IOError:
pass
po.stdin.close()
po.wait()
class Console(object):
"A textual console to interact with a database"
def __init__(self, dbname, input_src=sys.stdin):
self.db = connect(dbname)
self.input_src = input_src
self.prompt = '%s> ' % self.db.name
def sql_eval(self, code):
rows = self.db.execute(code)
if isinstance(rows, int):
if rows != -1:
return '%s rows were affected' % rows
else:
return ''
out = ['%d rows were returned' % len(rows), '\t'.join(rows.header)]
for row in rows:
out.append('\t'.join(map(str, row)))
return out
def readcode(self):
sys.stdout.write(self.prompt)
sys.stdout.flush()
lines = []
while True:
line = self.input_src.readline()
if not line:
raise EOFError
lines.append(line)
if line.endswith(';\n'):
return '\n'.join(lines)
def repl(self):
while True:
try:
code = self.readcode()
result = self.sql_eval(code)
if isinstance(result, list):
less('\n'.join(result))
else:
print result
except EOFError:
break
except Exception, e:
print e.__class__.__name__, str(e)
if __name__ == '__main__':
try:
alias = sys.argv[1]
except IndexError:
sys.exit(__doc__)
Console(alias).repl()
|