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 vote136 views1 answer
Error 401 unauthorized "Authentication credentials were not provided."
Python
1 vote117 views1 answer
How do i check if a django queryset is empty
Python
1 vote113 views1 answer
Rename coordinate netcdf python xarray
Python
0 vote115 views3 answers
Python with quick sort
Python
10 votes132 views3 answers
Text recognition python library
Python
14 votes114 views2 answers
Python check if dictionary empty
Python
0 vote156 views1 answer
Django serve media folder
Python Django
0 vote110 views1 answer
Python open multiple .py windows
Python
66 votes107 views6 answers
Wait function python
Python
8 votes135 views2 answers
Determinant of matrix in python
Python