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

6 votes154 views1 answer
Load images pygame
Python
5 votes373 views1 answer
Rectangle in tkinter
Python
0 vote161 views2 answers
Pip install covid
Python
-1 vote126 views1 answer
Check runtime python
Python
7 votes136 views1 answer
How to get user input of list in python
Python
0 vote130 views1 answer
Print chr character in python f string
Python
1 vote127 views1 answer
Find min and max from dataframe column
Python
2 votes127 views1 answer
Python convert any number in positive
Python
17 votes149 views6 answers
How to append to a list in python
Python
7 votes121 views2 answers
Selenium on windows
Python