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 vote104 views1 answer
Tuple parameter function python is None
Python
0 vote111 views1 answer
Randomforestregressor in sklearn
Python
0 vote125 views1 answer
Yamaha palhetas
Python
1 vote130 views1 answer
Module "django.contrib.auth.hashers" does not define a "BcryptPasswordHasher" attribute/class
Python Django
0 vote115 views1 answer
Python min date from dictionary
Python
0 vote143 views1 answer
From future import division
Python
0 vote102 views2 answers
Form.as_p in django
Python
0 vote108 views1 answer
How to repeat a python file
Python
0 vote105 views1 answer
How can i make a list of leftovers that are str to make them int in python
Python
0 vote111 views1 answer
Last executed query in flask api
Python