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 vote120 views1 answer
Rotate existing labels python
Python
1 vote90 views1 answer
Where my python modules in linux
Python
5 votes129 views3 answers
How to use label encoding in python
Python
0 vote94 views1 answer
Pyserial example code
Python
-1 vote112 views4 answers
Flask docs
Python
0 vote114 views1 answer
Find number of unique keys in the dictionary
Python
0 vote143 views1 answer
Dev.to flask heroku
Python Flask
0 vote103 views1 answer
Context manager requests python
Python
1 vote120 views4 answers
How to do a print statement in python
Python
0 vote93 views1 answer
Activate inherit function django
Python