| Gerhard Häring | 82560eb | 2006-05-01 15:14:48 +0000 | [diff] [blame] | 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"] | ||||