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"] |