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.

  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.