Mercurial > cpython-lru_cache-weakref
diff Doc/includes/sqlite3/execsql_fetchonerow.py @ 42603:c62f6669ae22 legacy-trunk
Move the 2.6 reST doc tree in place.
| author | Georg Brandl <georg@python.org> |
|---|---|
| date | Wed, 15 Aug 2007 14:28:01 +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:01 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])
