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 vote260 views1 answer
Docstrinfs pyt
Python
15 votes242 views3 answers
How to import numpy in python
Python
7 votes232 views1 answer
How to check if an application is open in python
Python
0 vote237 views1 answer
Webhook logger python
Python
1 vote229 views1 answer
How to access items in a list
Python
4 votes258 views3 answers
How to create one list from 2d list python
Python
0 vote257 views1 answer
[ WARN:0] global C:\Users\appveyor\AppData\Local\Temp\1\pip-req-build-nxx381if\opencv\modules\videoio\src\cap_msmf.cpp (435) `anonymous-namespace'
Python
0 vote262 views1 answer
Python async partial function
Python
9 votes278 views3 answers
Read only the first line python
Python
22 votes331 views6 answers
How to check django version
Python Django