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 vote158 views1 answer
Dirs' base_dir / 'templates' error
Python
9 votes161 views1 answer
Json formatter terminal
Python
0 vote162 views1 answer
Padnas get list of rows
Python
0 vote160 views1 answer
Python keyborad back space
Python
0 vote165 views1 answer
Python recognize every white color
Python
3 votes212 views2 answers
For loop python start at 1
Python
0 vote167 views1 answer
How to change defaul tpython version\
Python
6 votes159 views6 answers
Python create list
Python
1 vote169 views1 answer
Pygame how to change a pictures hue
Python
0 vote105 views1 answer
Python script to download files from website
Python