cinap_lenrekadd hg and python4bb9e2215 years agoHistory
30 lines · 670 B · Python
RawDownload
# A minimal SQLite shell for experiments import sqlite3 con = sqlite3.connect(":memory:")con.isolation_level = Nonecur = 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()