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

0 vote315 views1 answer
Km/h to mph python
Python
6 votes281 views2 answers
Django queryset get all distinct
Python
26 votes300 views3 answers
Python string generator
Python
0 vote314 views1 answer
./bootstrap command not found in dockerfile
Python
0 vote305 views1 answer
Python calculator file size to megabytes
Python
1 vote327 views1 answer
For loop pandas range
Python
0 vote339 views1 answer
How to convert data into numerical dataset
Python
5 votes352 views2 answers
How to set icon in tkinter
Python
0 vote290 views1 answer
What is tf.repeat()
Python
50 votes291 views6 answers
Print random string from list python
Python