1 # Not referenced from the documentation, but builds the database file the other 2 # code snippets expect. 3 4 import sqlite3 5 import os 6 7 DB_FILE = "mydb" 8 9 if os.path.exists(DB_FILE): 10 os.remove(DB_FILE) 11 12 con = sqlite3.connect(DB_FILE) 13 cur = con.cursor() 14 cur.execute(""" 15 create table people 16 ( 17 name_last varchar(20), 18 age integer 19 ) 20 """) 21 22 cur.execute("insert into people (name_last, age) values ('Yeltsin', 72)") 23 cur.execute("insert into people (name_last, age) values ('Putin', 51)") 24 25 con.commit() 26 27 cur.close() 28 con.close() 29
