l4/pkg/python/contrib/Doc/includes/sqlite3/complete_statement.py

   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()