1import sqlite3
2
3persons = [
4    ("Hugo", "Boss"),
5    ("Calvin", "Klein")
6    ]
7
8con = sqlite3.connect(":memory:")
9
10# Create the table
11con.execute("create table person(firstname, lastname)")
12
13# Fill the table
14con.executemany("insert into person(firstname, lastname) values (?, ?)", persons)
15
16# Print the table contents
17for row in con.execute("select firstname, lastname from person"):
18    print(row)
19
20print("I just deleted", con.execute("delete from person").rowcount, "rows")
21
22# close is not a shortcut method and it's not called automatically,
23# so the connection object should be closed manually
24con.close()
25