diff Doc/includes/sqlite3/execsql_fetchonerow.py @ 42604:9e1529bf0442

Move the 3k reST doc tree in place.
author Georg Brandl <georg@python.org>
date Wed, 15 Aug 2007 14:28:22 +0000
parents
children
line wrap: on
line diff
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/Doc/includes/sqlite3/execsql_fetchonerow.py	Wed Aug 15 14:28:22 2007 +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]))