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 vote210 views1 answer
What if discord.py python add-in does not work
Python
7 votes180 views4 answers
Random word generator python
Python
17 votes205 views10 answers
Time
Python
0 vote182 views1 answer
Windows error message python
Python
0 vote173 views1 answer
Generate random list and find max in list python
Python
0 vote191 views1 answer
Python How To Remove Commas From String
Python
2 votes130 views1 answer
Check for missing dates pandas with hours
Python
1 vote187 views1 answer
Serving static audio files with flask in react
Python Flask
0 vote148 views1 answer
Jinja flask
Python Flask
0 vote183 views1 answer
Python tkinter dynamic toggle button
Python