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