| Gerhard Häring | 82560eb | 2006-05-01 15:14:48 +0000 | [diff] [blame^] | 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()
|