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 vote310 views1 answer
Qiskit setup
Python
0 vote310 views1 answer
Python create a dictionary of integers
Python
0 vote316 views1 answer
How to stop gambling
Python
23 votes323 views6 answers
Python even or odd
Python
0 vote326 views1 answer
When training= false still dropout
Python
0 vote294 views1 answer
Division of 2 numbers in python
Python
0 vote310 views1 answer
Python durchschnitt liste
Python
0 vote320 views1 answer
Insert a new row to numpy array in especific position
Python
9 votes307 views3 answers
How to convert lower case to upper case in python
Python
1 vote311 views1 answer
How to install spotipy python
Python