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 vote348 views1 answer
Curso python
Python
-1 vote295 views2 answers
Numpy split to chunks of equal size
Python
0 vote276 views1 answer
Add user agent selenium python canary
Python
8 votes287 views3 answers
How to set default python version in macos
Python
1 vote284 views1 answer
Pip install qrcode python
Python
3 votes300 views4 answers
Install tensorflow gpu
Python
0 vote273 views1 answer
Remove base from terminal anaconda
Python
0 vote274 views4 answers
Python print string
Python
1 vote271 views1 answer
Object literal python
Python
0 vote251 views9 answers
C++ to python online converter
Python