| Georg Brandl | 116aa62 | 2007-08-15 14:28:22 +0000 | [diff] [blame] | 1 | import sqlite3 |
| 2 | |||||
| 3 | con = sqlite3.connect(":memory:") | ||||
| 4 | cur = con.cursor() | ||||
| 5 | cur.executescript(""" | ||||
| 6 | create table person( | ||||
| 7 | firstname, | ||||
| 8 | lastname, | ||||
| 9 | age | ||||
| 10 | ); | ||||
| 11 | |||||
| 12 | create table book( | ||||
| 13 | title, | ||||
| 14 | author, | ||||
| 15 | published | ||||
| 16 | ); | ||||
| 17 | |||||
| 18 | insert into book(title, author, published) | ||||
| 19 | values ( | ||||
| 20 | 'Dirk Gently''s Holistic Detective Agency', | ||||
| 21 | 'Douglas Adams', | ||||
| 22 | 1987 | ||||
| 23 | ); | ||||
| 24 | """) | ||||