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 vote107 views1 answer
Python format inverse
Python
1 vote111 views1 answer
Anagrams string python
Python
105 votes116 views6 answers
Install opencv
Python
0 vote105 views8 answers
Empaquetado y manejo dependencias en python
Python
0 vote110 views1 answer
Rc.local raspberry pi
Python
-1 vote120 views2 answers
Reading tsv file in python
Python
0 vote108 views1 answer
Check if path is a folder python
Python
3 votes120 views2 answers
Normal distribution
Python
9 votes113 views6 answers
Flask – Environment
Python
0 vote124 views1 answer
Unpad zeros from string python
Python