| Georg Brandl | 8ec7f65 | 2007-08-15 14:28:01 +0000 | [diff] [blame] | 1 | import sqlite3 |
| 2 | |
| Petri Lehtinen | a15a8d2 | 2012-03-01 21:28:00 +0200 | [diff] [blame] | 3 | con = sqlite3.connect(":memory:") |
| Georg Brandl | 8ec7f65 | 2007-08-15 14:28:01 +0000 | [diff] [blame] | 4 | con.row_factory = sqlite3.Row |
| 5 | |
| 6 | cur = con.cursor() |
| Petri Lehtinen | a15a8d2 | 2012-03-01 21:28:00 +0200 | [diff] [blame] | 7 | cur.execute("select 'John' as name, 42 as age") |
| Georg Brandl | 8ec7f65 | 2007-08-15 14:28:01 +0000 | [diff] [blame] | 8 | for row in cur: |
| Petri Lehtinen | a15a8d2 | 2012-03-01 21:28:00 +0200 | [diff] [blame] | 9 | assert row[0] == row["name"] |
| 10 | assert row["name"] == row["nAmE"] |
| Georg Brandl | 8ec7f65 | 2007-08-15 14:28:01 +0000 | [diff] [blame] | 11 | assert row[1] == row["age"] |
| 12 | assert row[1] == row["AgE"] |