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