Mercurial > cpython-lru_cache-weakref

diff 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
line wrap: on
line diff
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/Doc/lib/sqlite3/execsql_fetchonerow.py	Mon May 01 15:14:48 2006 +0000
@@ -0,0 +1,17 @@
+import sqlite3
+
+con = sqlite3.connect("mydb")
+
+cur = con.cursor()
+SELECT = "select name_last, age from people order by age, name_last"
+
+# 1. Iterate over the rows available from the cursor, unpacking the
+# resulting sequences to yield their elements (name_last, age):
+cur.execute(SELECT)
+for (name_last, age) in cur:
+    print '%s is %d years old.' % (name_last, age)
+
+# 2. Equivalently:
+cur.execute(SELECT)
+for row in cur:
+    print '%s is %d years old.' % (row[0], row[1])