From 458120dd40db6b4df55a4e96b650e16798ef06a0 Mon Sep 17 00:00:00 2001 From: cinap_lenrek Date: Tue, 3 May 2011 11:25:13 +0000 Subject: add hg and python --- .../python/Doc/lib/sqlite3/complete_statement.py | 30 ++++++++++++++++++++++ 1 file changed, 30 insertions(+) create mode 100644 sys/src/cmd/python/Doc/lib/sqlite3/complete_statement.py (limited to 'sys/src/cmd/python/Doc/lib/sqlite3/complete_statement.py') diff --git a/sys/src/cmd/python/Doc/lib/sqlite3/complete_statement.py b/sys/src/cmd/python/Doc/lib/sqlite3/complete_statement.py new file mode 100644 index 000000000..22525e310 --- /dev/null +++ b/sys/src/cmd/python/Doc/lib/sqlite3/complete_statement.py @@ -0,0 +1,30 @@ +# A minimal SQLite shell for experiments + +import sqlite3 + +con = sqlite3.connect(":memory:") +con.isolation_level = None +cur = con.cursor() + +buffer = "" + +print "Enter your SQL commands to execute in sqlite3." +print "Enter a blank line to exit." + +while True: + line = raw_input() + if line == "": + break + buffer += line + if sqlite3.complete_statement(buffer): + try: + buffer = buffer.strip() + cur.execute(buffer) + + if buffer.lstrip().upper().startswith("SELECT"): + print cur.fetchall() + except sqlite3.Error, e: + print "An error occurred:", e.args[0] + buffer = "" + +con.close() -- cgit v1.2.3