Python sqlite dict

def dict_factory(cursor, row):
    d = {}
    for idx, col in enumerate(cursor.description):
        d[col[0]] = row[idx]
    return d

conn = sqlite3.connect("data.db")
conn.row_factory = dict_factory
db = conn.cursor()
print(db.execute("SELECT * FROM table"))
>>> [{'col1': 'val1', 'col2': 'val2'}, {'col1': 'val3', 'col2': 'val4'}]

Similar codes

1 vote297 views1 answer
Changing instance through dict changes all instances
Python
16 votes260 views3 answers
Python split range equally
Python
2 votes286 views2 answers
Ticks font size matplotlib
Python
3 votes287 views1 answer
How to find the number of times a number appears in python
Python
0 vote271 views1 answer
Pandas join tables based on column of different length
Python
8 votes259 views6 answers
Python get numbers from string
Python
0 vote253 views1 answer
How to make levels in scratch
Python
1 vote278 views1 answer
How to check whole number in python
Python
0 vote303 views1 answer
Def dict(d)
Python
268 votes379 views0 answer
Last element of list python
Python