diff options
Diffstat (limited to 'Doc/includes/sqlite3/executescript.py')
| -rw-r--r-- | Doc/includes/sqlite3/executescript.py | 24 | 
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 +    ); +    """) | 
