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 = 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