summaryrefslogtreecommitdiff
path: root/doc/includes/sqlite3/complete_statement.py
diff options
context:
space:
mode:
Diffstat (limited to 'doc/includes/sqlite3/complete_statement.py')
-rw-r--r--doc/includes/sqlite3/complete_statement.py30
1 files changed, 0 insertions, 30 deletions
diff --git a/doc/includes/sqlite3/complete_statement.py b/doc/includes/sqlite3/complete_statement.py
deleted file mode 100644
index 2bb49d4..0000000
--- a/doc/includes/sqlite3/complete_statement.py
+++ /dev/null
@@ -1,30 +0,0 @@
-# A minimal SQLite shell for experiments
-
-from pysqlite2 import dbapi2 as sqlite3
-
-con = sqlite3.connect(":memory:")
-con.isolation_level = None
-cur = con.cursor()
-
-buffer = ""
-
-print "Enter your SQL commands to execute in SQLite."
-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()