| import sqlite3 | |
| con = sqlite3.connect(":memory:") | |
| con.row_factory = sqlite3.Row | |
| cur = con.cursor() | |
| cur.execute("select 'John' as name, 42 as age") | |
| for row in cur: | |
| assert row[0] == row["name"] | |
| assert row["name"] == row["nAmE"] | |
| assert row[1] == row["age"] | |
| assert row[1] == row["AgE"] |