1import sqlite3
2
3con = sqlite3.connect(":memory:")
4cur = con.cursor()
5cur.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