text: from pysqlite2 import dbapi2 as 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
      );
      """)
  