1 import sqlite3 2 3 persons = [ 4 ("Hugo", "Boss"), 5 ("Calvin", "Klein") 6 ] 7 8 con = sqlite3.connect(":memory:") 9 10 # Create the table 11 con.execute("create table person(firstname, lastname)") 12 13 # Fill the table 14 con.executemany("insert into person(firstname, lastname) values (?, ?)", persons) 15 16 # Print the table contents 17 for row in con.execute("select firstname, lastname from person"): 18 print row 19 20 print "I just deleted", con.execute("delete from person").rowcount, "rows" 21
