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 vote343 views1 answer
How to find the mode using pandas groupby
Python
2 votes389 views1 answer
Switching keys and values in a dictionary in python [duplicate]
Python
22 votes348 views2 answers
Python get date tomorrow
Python
2 votes320 views1 answer
Download youtube videos using api python
Python
0 vote352 views1 answer
Python spearman correlation
Python
0 vote487 views1 answer
Relation api profile does not exist django
Python Django
0 vote331 views3 answers
2 decimal places
Python
0 vote323 views1 answer
Gwt height with tkinker
Python
3 votes335 views2 answers
Dict_values to list python
Python
2 votes324 views2 answers
Python printing date
Python