1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
| # 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()
|
|
