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

38 votes320 views3 answers
Pil python install
Python
4 votes396 views8 answers
Play solitaire
Python
39 votes317 views6 answers
Pandas print all columns
Python
0 vote381 views1 answer
Creating base models django
Python Django
0 vote310 views2 answers
Pandas series filter by index
Python
0 vote321 views1 answer
Matruzen rechner python
Python
18 votes349 views4 answers
Reset index python
Python
0 vote341 views1 answer
Python get value from list
Python
33 votes323 views6 answers
Python create requirements.txt
Python
4 votes324 views1 answer
Sort dict by value
Python