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 """) 25
