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

9 votes140 views3 answers
How to get image in jupyter notebook
Python
91 votes139 views6 answers
Sort df by column
Python
0 vote134 views1 answer
Migrations.rename_field django
Python
1 vote147 views1 answer
Sleep 5 seconds py
Python
2 votes90 views1 answer
EnvironmentError command line
Python
11 votes159 views3 answers
Python pip install pandas
Python
26 votes133 views1 answer
Dict from two lists
Python
1 vote219 views2 answers
.save() in django
Python Django
0 vote150 views2 answers
Quotation marks n string
Python
2 votes90 views3 answers
Sort list of lists python
Python