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

1 vote151 views1 answer
ImportError: cannot import name 'TFAutoModel' from 'transformers'
Python
1 vote135 views1 answer
Python MongoEngine doc
Python
1 vote205 views1 answer
Opposite of .isin pandas
Python
0 vote154 views1 answer
Boto3 cross region
Python
1 vote167 views1 answer
Tkinter center frame
Python
107 votes145 views6 answers
Python split
Python
0 vote145 views1 answer
Replace word in column pandas lambda
Python
65 votes154 views4 answers
How to sum all the numbers in a list in python
Python
0 vote172 views1 answer
Flask google analytics
Python Flask
0 vote134 views1 answer
Foreign key django createview
Python