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 vote181 views1 answer
Tensorflow python 3.9
Python
22 votes212 views6 answers
Python average
Python
0 vote196 views1 answer
Purge python3.y from every place in my path
Python
69 votes192 views6 answers
How to activate venv python
Python
1 vote205 views1 answer
Only include top ten items django for loop
Python
0 vote205 views1 answer
Pandas check if any of the values in one column exist in another
Python
10 votes185 views2 answers
English to japanese
Python
0 vote192 views1 answer
Static files not loading 404 error django
Python
0 vote195 views1 answer
AttributeError: type object 'User' has no attribute 'query'
Python
0 vote190 views1 answer
Join all words in a list python with space between
Python