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

2 votes301 views1 answer
Python open url in incognito
Python
1 vote287 views1 answer
Implement stack using list in python
Python
0 vote286 views1 answer
Hovering over canvas item tkinter event
Python
0 vote298 views2 answers
Matplotlib increase tick frequency
Python
5 votes277 views2 answers
Columns to dictionary pandas
Python
5 votes256 views3 answers
Tuplein python
Python
0 vote286 views1 answer
Python offline translate pypi
Python
-1 vote259 views1 answer
Show all text contained in a line pandaq
Python
0 vote278 views1 answer
How to import flask restful using pip
Python
1 vote282 views3 answers
Sum method in python
Python