Mercurial > cpython-lru_cache-weakref

annotate Doc/lib/sqlite3/execsql_fetchonerow.py @ 38069:cf19a123a5d9 legacy-trunk

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Further integration of the documentation for the sqlite3 module. There's still quite some content to move over from the pysqlite manual, but it's a start now.
author Gerhard Häring <gh@ghaering.de>
date Mon, 01 May 2006 15:14:48 +0000
parents
children 204ec383b445
Ignore whitespace changes - Everywhere: Within whitespace: At end of lines:
rev   line source
38069
cf19a123a5d9 Further integration of the documentation for the sqlite3 module. There's still
Gerhard Häring <gh@ghaering.de>
parents:
diff changeset
1 import sqlite3
cf19a123a5d9 Further integration of the documentation for the sqlite3 module. There's still
Gerhard Häring <gh@ghaering.de>
parents:
diff changeset
2
cf19a123a5d9 Further integration of the documentation for the sqlite3 module. There's still
Gerhard Häring <gh@ghaering.de>
parents:
diff changeset
3 con = sqlite3.connect("mydb")
cf19a123a5d9 Further integration of the documentation for the sqlite3 module. There's still
Gerhard Häring <gh@ghaering.de>
parents:
diff changeset
4
cf19a123a5d9 Further integration of the documentation for the sqlite3 module. There's still
Gerhard Häring <gh@ghaering.de>
parents:
diff changeset
5 cur = con.cursor()
cf19a123a5d9 Further integration of the documentation for the sqlite3 module. There's still
Gerhard Häring <gh@ghaering.de>
parents:
diff changeset
6 SELECT = "select name_last, age from people order by age, name_last"
cf19a123a5d9 Further integration of the documentation for the sqlite3 module. There's still
Gerhard Häring <gh@ghaering.de>
parents:
diff changeset
7
cf19a123a5d9 Further integration of the documentation for the sqlite3 module. There's still
Gerhard Häring <gh@ghaering.de>
parents:
diff changeset
8 # 1. Iterate over the rows available from the cursor, unpacking the
cf19a123a5d9 Further integration of the documentation for the sqlite3 module. There's still
Gerhard Häring <gh@ghaering.de>
parents:
diff changeset
9 # resulting sequences to yield their elements (name_last, age):
cf19a123a5d9 Further integration of the documentation for the sqlite3 module. There's still
Gerhard Häring <gh@ghaering.de>
parents:
diff changeset
10 cur.execute(SELECT)
cf19a123a5d9 Further integration of the documentation for the sqlite3 module. There's still
Gerhard Häring <gh@ghaering.de>
parents:
diff changeset
11 for (name_last, age) in cur:
cf19a123a5d9 Further integration of the documentation for the sqlite3 module. There's still
Gerhard Häring <gh@ghaering.de>
parents:
diff changeset
12 print '%s is %d years old.' % (name_last, age)
cf19a123a5d9 Further integration of the documentation for the sqlite3 module. There's still
Gerhard Häring <gh@ghaering.de>
parents:
diff changeset
13
cf19a123a5d9 Further integration of the documentation for the sqlite3 module. There's still
Gerhard Häring <gh@ghaering.de>
parents:
diff changeset
14 # 2. Equivalently:
cf19a123a5d9 Further integration of the documentation for the sqlite3 module. There's still
Gerhard Häring <gh@ghaering.de>
parents:
diff changeset
15 cur.execute(SELECT)
cf19a123a5d9 Further integration of the documentation for the sqlite3 module. There's still
Gerhard Häring <gh@ghaering.de>
parents:
diff changeset
16 for row in cur:
cf19a123a5d9 Further integration of the documentation for the sqlite3 module. There's still
Gerhard Häring <gh@ghaering.de>
parents:
diff changeset
17 print '%s is %d years old.' % (row[0], row[1])