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 vote208 views1 answer
Find all element in list python
Python
3 votes216 views1 answer
No module named 'django.core.urlresolvers'
Python Django
86 votes197 views6 answers
Select random value from list python
Python
15 votes184 views5 answers
Join on column pandas
Python
7 votes187 views4 answers
Qr code in python
Python
0 vote177 views1 answer
Assert with message python
Python
6 votes172 views1 answer
Cors error in flask
Python
0 vote164 views1 answer
Pyqt5 image center
Python
1 vote169 views5 answers
Transpose a matrix in python
Python
3 votes173 views2 answers
Python obfuscator
Python