import sqlite3 | |
con = sqlite3.connect("mydb") | |
con.row_factory = sqlite3.Row | |
cur = con.cursor() | |
cur.execute("select name_last, age from people") | |
for row in cur: | |
assert row[0] == row["name_last"] | |
assert row["name_last"] == row["nAmE_lAsT"] | |
assert row[1] == row["age"] | |
assert row[1] == row["AgE"] |