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 = 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, e:

    27             print "An error occurred:", e.args[0]

    28         buffer = ""

    29 

    30 con.close()