| Thomas Wouters | 477c8d5 | 2006-05-27 19:21:47 +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 ( |
| Thomas Wouters | 89f507f | 2006-12-13 04:49:30 +0000 | [diff] [blame^] | 20 | 'Dirk Gently''s Holistic Detective Agency', |
| Thomas Wouters | 477c8d5 | 2006-05-27 19:21:47 +0000 | [diff] [blame] | 21 | 'Douglas Adams', |
| 22 | 1987 |
| 23 | ); |
| 24 | """) |