advanced code snippet search

Posted By

shadevampire on 07/11/11


Tagged

python sandbox SQLite Minimal


Versions (?)

Python minimal SQLite sandbox

 / Published in: Python
 

URL: http://docs.python.org/py3k/library/sqlite3.html?highlight=sqlite#sqlite3

It's from the original python doc.

Expand | Embed | Plain Text 
  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()

Report this snippet  

You need to login to post a comment.