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