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

4 votes177 views1 answer
Re python3
Python
0 vote159 views1 answer
Python scrape data from aspx page
Python
23 votes178 views2 answers
Converting month number to month name python
Python
35 votes168 views2 answers
Download pyaudio for python 3.9
Python
2 votes179 views1 answer
Save pandas dataframe to parquet
Python
5 votes198 views1 answer
Python how long since date
Python
1 vote174 views2 answers
Python strptime milliseconds
Python
0 vote147 views6 answers
Schedule a function python inside tkinter loop
Python
0 vote192 views1 answer
Suppress pandas future warnings
Python
0 vote171 views3 answers
H2o ai python
Python