diff options
Diffstat (limited to 'Doc/includes/sqlite3/insert_more_langs.py')
-rw-r--r-- | Doc/includes/sqlite3/insert_more_langs.py | 18 |
1 files changed, 18 insertions, 0 deletions
diff --git a/Doc/includes/sqlite3/insert_more_langs.py b/Doc/includes/sqlite3/insert_more_langs.py new file mode 100644 index 0000000..ceef949 --- /dev/null +++ b/Doc/includes/sqlite3/insert_more_langs.py @@ -0,0 +1,18 @@ +import sqlite3 + +con = sqlite3.connect("mydb") + +cur = con.cursor() + +languages = ( + ("Smalltalk", 1972), + ("Swift", 2014), +) + +for lang in languages: + cur.execute("insert into lang (name, first_appeared) values (?, ?)", lang) + +# The changes will not be saved unless the transaction is committed explicitly: +con.commit() + +con.close() |