Mercurial > cpython-lru_cache-weakref
diff Doc/lib/sqlite3/execsql_fetchonerow.py @ 38197:204ec383b445 legacy-trunk
Text files missing the SVN eol-style property.
| author | Tim Peters <tim.peters@gmail.com> |
|---|---|
| date | Tue, 16 May 2006 23:24:08 +0000 |
| parents | cf19a123a5d9 |
| children |
line wrap: on
line diff
--- a/Doc/lib/sqlite3/execsql_fetchonerow.py Tue May 16 23:22:20 2006 +0000 +++ b/Doc/lib/sqlite3/execsql_fetchonerow.py Tue May 16 23:24:08 2006 +0000 @@ -1,17 +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]) +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])