Mercurial > cpython-lru_cache-weakref
diff Doc/lib/sqlite3/createdb.py @ 38197:204ec383b445 legacy-trunk
Text files missing the SVN eol-style property.
| author | Tim Peters <tim.peters@gmail.com> |
|---|---|
| date | Tue, 16 May 2006 23:24:08 +0000 |
| parents | cf19a123a5d9 |
| children |
line wrap: on
line diff
--- a/Doc/lib/sqlite3/createdb.py Tue May 16 23:22:20 2006 +0000 +++ b/Doc/lib/sqlite3/createdb.py Tue May 16 23:24:08 2006 +0000 @@ -1,28 +1,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() +# 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()
