1 # A minimal SQLite shell for experiments 2 3 import sqlite3 4 5 con = sqlite3.connect(":memory:") 6 con.isolation_level = None 7 cur = con.cursor() 8 9 buffer = "" 10 11 print("Enter your SQL commands to execute in sqlite3.") 12 print("Enter a blank line to exit.") 13 14 while True: 15 line = 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 30 con.close() 31
