"""
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"
stmt = sqlite.prepare("INSERT INTO sample (Name) VALUES (?), (?), (?), (?);")
stmt.bind_param('ssss', name, "Viggo Mortensen", "David Tennant", "Will Smith")
stmt.execute()
print("...")
if stmt.affected_rows > 0:
print(stmt.affected_rows, "rows added.")
