source:
trunk/essentials/dev-lang/python/Doc/lib/sqlite3/rowclass.py
| Last change on this file was 3225, checked in by , 19 years ago | |
|---|---|
| File size: 311 bytes | |
| Line | |
|---|---|
| 1 | import sqlite3 |
| 2 | |
| 3 | con = sqlite3.connect("mydb") |
| 4 | con.row_factory = sqlite3.Row |
| 5 | |
| 6 | cur = con.cursor() |
| 7 | cur.execute("select name_last, age from people") |
| 8 | for row in cur: |
| 9 | assert row[0] == row["name_last"] |
| 10 | assert row["name_last"] == row["nAmE_lAsT"] |
| 11 | assert row[1] == row["age"] |
| 12 | assert row[1] == row["AgE"] |
Note:
See TracBrowser
for help on using the repository browser.
