1116aa62bf54a39697e25f21d6cf6799f7faa1349Georg Brandlimport sqlite3 2116aa62bf54a39697e25f21d6cf6799f7faa1349Georg Brandl 3116aa62bf54a39697e25f21d6cf6799f7faa1349Georg Brandlcon = sqlite3.connect(":memory:") 4116aa62bf54a39697e25f21d6cf6799f7faa1349Georg Brandlcur = con.cursor() 5116aa62bf54a39697e25f21d6cf6799f7faa1349Georg Brandlcur.executescript(""" 6116aa62bf54a39697e25f21d6cf6799f7faa1349Georg Brandl create table person( 7116aa62bf54a39697e25f21d6cf6799f7faa1349Georg Brandl firstname, 8116aa62bf54a39697e25f21d6cf6799f7faa1349Georg Brandl lastname, 9116aa62bf54a39697e25f21d6cf6799f7faa1349Georg Brandl age 10116aa62bf54a39697e25f21d6cf6799f7faa1349Georg Brandl ); 11116aa62bf54a39697e25f21d6cf6799f7faa1349Georg Brandl 12116aa62bf54a39697e25f21d6cf6799f7faa1349Georg Brandl create table book( 13116aa62bf54a39697e25f21d6cf6799f7faa1349Georg Brandl title, 14116aa62bf54a39697e25f21d6cf6799f7faa1349Georg Brandl author, 15116aa62bf54a39697e25f21d6cf6799f7faa1349Georg Brandl published 16116aa62bf54a39697e25f21d6cf6799f7faa1349Georg Brandl ); 17116aa62bf54a39697e25f21d6cf6799f7faa1349Georg Brandl 18116aa62bf54a39697e25f21d6cf6799f7faa1349Georg Brandl insert into book(title, author, published) 19116aa62bf54a39697e25f21d6cf6799f7faa1349Georg Brandl values ( 20116aa62bf54a39697e25f21d6cf6799f7faa1349Georg Brandl 'Dirk Gently''s Holistic Detective Agency', 21116aa62bf54a39697e25f21d6cf6799f7faa1349Georg Brandl 'Douglas Adams', 22116aa62bf54a39697e25f21d6cf6799f7faa1349Georg Brandl 1987 23116aa62bf54a39697e25f21d6cf6799f7faa1349Georg Brandl ); 24116aa62bf54a39697e25f21d6cf6799f7faa1349Georg Brandl """) 25