FilesExpand file tree

 master

/

rowclass.py

Copy path

Blame

More file actions

Blame

More file actions

Latest commit

 

History

History

History

12 lines (10 loc) · 311 Bytes

 master

/

rowclass.py

Copy path

Top

File metadata and controls

• Code
• Blame

12 lines (10 loc) · 311 Bytes

Raw

Copy raw file

Download raw file

Open symbols panel

Edit and raw actions

1

2

3

4

5

6

7

8

9

10

11

12

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