diff options
Diffstat (limited to 'Doc/lib/sqlite3/executescript.py')
-rw-r--r-- | Doc/lib/sqlite3/executescript.py | 24 |
1 files changed, 24 insertions, 0 deletions
diff --git a/Doc/lib/sqlite3/executescript.py b/Doc/lib/sqlite3/executescript.py new file mode 100644 index 0000000..2c04066 --- /dev/null +++ b/Doc/lib/sqlite3/executescript.py @@ -0,0 +1,24 @@ +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
+ );
+ """)
|