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 vote264 views1 answer
Distinct rows in this DataFrame
Python
2 votes181 views1 answer
Python only numbers in string
Python
0 vote183 views1 answer
How to convert a matrix string back to a matrix python
Python
0 vote194 views2 answers
Xpath beautifulsoup
Python
186 votes289 views6 answers
How to read file in python
Python
0 vote273 views1 answer
"Token" is not defined Pylance
Python
0 vote181 views1 answer
Python one line key increment or add
Python
4 votes173 views3 answers
How to change port in flask app
Python
0 vote251 views9 answers
How to form a list from a file in python
Python
0 vote187 views1 answer
Python plot draw the goal line
Python