import sqlite3

con = sqlite3.connect(":memory:")
cur = con.cursor()
cur.executescript("""
 create table person(
 firstname,
 lastname,
 age
 );

 create table book(
 title,
 author,
 published
 );

 insert into book(title, author, published)
 values (
 'Dirk Gently''s Holistic Detective Agency',
 'Douglas Adams',
 1987
 );
 """)
con.close()