summaryrefslogtreecommitdiffstats
path: root/Doc/includes/sqlite3/executescript.py
diff options
context:
space:
mode:
Diffstat (limited to 'Doc/includes/sqlite3/executescript.py')
-rw-r--r--Doc/includes/sqlite3/executescript.py24
1 files changed, 24 insertions, 0 deletions
diff --git a/Doc/includes/sqlite3/executescript.py b/Doc/includes/sqlite3/executescript.py
new file mode 100644
index 0000000..7e53581
--- /dev/null
+++ b/Doc/includes/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
+ );
+ """)