Sample Database Test
Tasted on v0.2.0
Note: Error handling will not work on v0.1.0
Date: 22 Oct, 2015
"""
began = datetime.now()
print("Program starts at:", began)
print("Connecting to Database...", end=' ')
sqlite = SQLite(":memory:")
print("...")
if sqlite.connect_error: raise sqlite.connect_errno(sqlite.connect_error)
else: print("Connected to Database.")
print("Creating a table...", end=' ')
stmt = sqlite.prepare("""CREATE TABLE sample (
ID integer PRIMARY KEY AUTOINCREMENT NOT NULL,
Name text
)""")
stmt.execute()
print("...")
if stmt.error: raise stmt.errno(stmt.error)
else: print("Table created.")
stmt.close()
print("Inserting some values...", end=' ')
name = "Ian McKellen"
