/Doc/includes/sqlite3/createdb.py

 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()