/Doc/includes/sqlite3/createdb.py
http://unladen-swallow.googlecode.com/ · Python · 28 lines · 19 code · 7 blank · 2 comment · 1 complexity · a4eaba3c33793461f77f0ea536c791ed MD5 · raw file
- # 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()