/Doc/includes/sqlite3/complete_statement.py
http://unladen-swallow.googlecode.com/ · Python · 30 lines · 22 code · 7 blank · 1 comment · 6 complexity · 87174aa8953ab6ea610c25466c415d48 MD5 · raw file
- # 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()