1# A minimal SQLite shell for experiments 2 3import sqlite3 4 5con = sqlite3.connect(":memory:") 6con.isolation_level = None 7cur = con.cursor() 8 9buffer = "" 10 11print "Enter your SQL commands to execute in sqlite3." 12print "Enter a blank line to exit." 13 14while True: 15 line = raw_input() 16 if line == "": 17 break 18 buffer += line 19 if sqlite3.complete_statement(buffer): 20 try: 21 buffer = buffer.strip() 22 cur.execute(buffer) 23 24 if buffer.lstrip().upper().startswith("SELECT"): 25 print cur.fetchall() 26 except sqlite3.Error as e: 27 print "An error occurred:", e.args[0] 28 buffer = "" 29 30con.close() 31