diff options
author | Petri Lehtinen <petri@digip.org> | 2012-02-15 20:22:34 (GMT) |
---|---|---|
committer | Petri Lehtinen <petri@digip.org> | 2012-02-15 20:22:34 (GMT) |
commit | be2cf338e9baef1f2479a33a8c7b5552bf9bd86f (patch) | |
tree | ad5bfa3bbfe0db0e65b25eb5ef805fbf0e0b226b /Doc/includes/sqlite3/execute_1.py | |
parent | 482ee66cb7075b917a0a93051536ed0c10586447 (diff) | |
parent | 1ca93954e17e4f6f1230306997badbda3e5c68bc (diff) | |
download | cpython-be2cf338e9baef1f2479a33a8c7b5552bf9bd86f.zip cpython-be2cf338e9baef1f2479a33a8c7b5552bf9bd86f.tar.gz cpython-be2cf338e9baef1f2479a33a8c7b5552bf9bd86f.tar.bz2 |
Merge branch '3.2'
Issue #13491.
Diffstat (limited to 'Doc/includes/sqlite3/execute_1.py')
-rw-r--r-- | Doc/includes/sqlite3/execute_1.py | 11 |
1 files changed, 8 insertions, 3 deletions
diff --git a/Doc/includes/sqlite3/execute_1.py b/Doc/includes/sqlite3/execute_1.py index 3d08840..f864a89 100644 --- a/Doc/includes/sqlite3/execute_1.py +++ b/Doc/includes/sqlite3/execute_1.py @@ -1,11 +1,16 @@ import sqlite3 -con = sqlite3.connect("mydb") - +con = sqlite3.connect(":memory:") cur = con.cursor() +cur.execute("create table people (name_last, age)") who = "Yeltsin" age = 72 -cur.execute("select name_last, age from people where name_last=? and age=?", (who, age)) +# This is the qmark style: +cur.execute("insert into people values (?, ?)", (who, age)) + +# And this is the named style: +cur.execute("select * from people where name_last=:who and age=:age", {"who": who, "age": age}) + print(cur.fetchone()) |