From 116aa62bf54a39697e25f21d6cf6799f7faa1349 Mon Sep 17 00:00:00 2001 From: Georg Brandl Date: Wed, 15 Aug 2007 14:28:22 +0000 Subject: Move the 3k reST doc tree in place. --- Doc/includes/sqlite3/createdb.py | 28 ++++++++++++++++++++++++++++ 1 file changed, 28 insertions(+) create mode 100644 Doc/includes/sqlite3/createdb.py (limited to 'Doc/includes/sqlite3/createdb.py') diff --git a/Doc/includes/sqlite3/createdb.py b/Doc/includes/sqlite3/createdb.py new file mode 100644 index 0000000000..ee2950bdf8 --- /dev/null +++ b/Doc/includes/sqlite3/createdb.py @@ -0,0 +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() -- cgit v1.2.1