git: 9front

ref: 06cd4da1c4af250f751e69a6f40946c18d8e415c
dir: /sys/src/cmd/python/Doc/lib/sqlite3/execute_3.py/

View raw version
import sqlite3

con = sqlite3.connect("mydb")

cur = con.cursor()

who = "Yeltsin"
age = 72

cur.execute("select name_last, age from people where name_last=:who and age=:age",
    locals())
print cur.fetchone()