import sqlite3
conn = sqlite3.connect('example.db')
c = conn.cursor()
# Create table
c.execute('''CREATE TABLE stocks
(date text, trans text, symbol text, qty real, price real)''')
# Insert a row of data
c.execute("INSERT INTO stocks VALUES ('2006-01-05','BUY','RHAT',100,35.14)")
# Save (commit) the changes
conn.commit()
# We can also close the connection if we are done with it.
# Just be sure any changes have been committed or they will be lost.
conn.close()
aW1wb3J0IHNxbGl0ZTMKY29ubiA9IHNxbGl0ZTMuY29ubmVjdCgnZXhhbXBsZS5kYicpCmMgPSBjb25uLmN1cnNvcigpCgojIENyZWF0ZSB0YWJsZQpjLmV4ZWN1dGUoJycnQ1JFQVRFIFRBQkxFIHN0b2NrcwogICAgICAgICAgICAgKGRhdGUgdGV4dCwgdHJhbnMgdGV4dCwgc3ltYm9sIHRleHQsIHF0eSByZWFsLCBwcmljZSByZWFsKScnJykKCiMgSW5zZXJ0IGEgcm93IG9mIGRhdGEKYy5leGVjdXRlKCJJTlNFUlQgSU5UTyBzdG9ja3MgVkFMVUVTICgnMjAwNi0wMS0wNScsJ0JVWScsJ1JIQVQnLDEwMCwzNS4xNCkiKQoKIyBTYXZlIChjb21taXQpIHRoZSBjaGFuZ2VzCmNvbm4uY29tbWl0KCkKCiMgV2UgY2FuIGFsc28gY2xvc2UgdGhlIGNvbm5lY3Rpb24gaWYgd2UgYXJlIGRvbmUgd2l0aCBpdC4KIyBKdXN0IGJlIHN1cmUgYW55IGNoYW5nZXMgaGF2ZSBiZWVuIGNvbW1pdHRlZCBvciB0aGV5IHdpbGwgYmUgbG9zdC4KY29ubi5jbG9zZSgp