# Not referenced from the documentation, but builds the database file the other

# code snippets expect.

import sqlite3

import os

DB_FILE = "mydb"

if os.path.exists(DB_FILE):

    os.remove(DB_FILE)

con = sqlite3.connect(DB_FILE)

cur = con.cursor()

cur.execute("""

        create table people

        (

          name_last      varchar(20),

          age            integer

        )

        """)

cur.execute("insert into people (name_last, age) values ('Yeltsin',   72)")

cur.execute("insert into people (name_last, age) values ('Putin',     51)")

con.commit()

cur.close()

con.close()