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 vote114 views2 answers
Python json write utf 8
Python
1 vote123 views1 answer
Fibonacci series using dynamic programmig approach
Python
5 votes142 views1 answer
Py2exe
Python
3 votes127 views1 answer
Python convert png to ico
Python
0 vote133 views1 answer
Pygame mixer channel loop
Python
0 vote119 views1 answer
Ubuntu 20.10 python 3.8
Python
1 vote123 views1 answer
Python multiaxis slicing
Python
6 votes116 views5 answers
Docstrings in python
Python
0 vote155 views1 answer
Find a string hackereank
Python
0 vote140 views1 answer
Networkx draw tripartite graph
Python