import sqlite3
import sys
if len(sys.argv) < 3:
print("Usage: %s [init|insert|list] db" % sys.argv[0])
else:
conn = sqlite3.connect(sys.argv[2])
with conn:
if sys.argv[1] == "init":
conn.execute("DROP TABLE IF EXISTS records")
conn.execute("CREATE TABLE records(id INTEGER PRIMARY KEY AUTOINCREMENT, description TEXT)")
conn.commit()
elif sys.argv[1] == "list":
cursor = conn.cursor()
cursor.execute("SELECT * FROM records")
rows = cursor.fetchall()
for r in rows:
print(r)
elif sys.argv[1] == "insert":
while True:
l = sys.stdin.readline()
if not l:
break
conn.execute("INSERT INTO records(description) VALUES (?)", (l.rstrip(),))
conn.commit()
else:
print("Unrecognised command: %s" % sys.argv[1])
Apache Qpid, Messaging built on AMQP; Copyright © 2015 The Apache Software Foundation; Licensed under the Apache License, Version 2.0; Apache Qpid, Qpid, Qpid Proton, Proton, Apache, the Apache feather logo, and the Apache Qpid project logo are trademarks of The Apache Software Foundation; All other marks mentioned may be trademarks or registered trademarks of their respective owners