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

18 votes331 views5 answers
Python continue
Python
2 votes368 views1 answer
Pandas groupby count unique rows
Python
5 votes331 views4 answers
Python debugger
Python
3 votes345 views2 answers
How to add list numbers in python
Python
1 vote309 views1 answer
Code that works if variable has a value python
Python
0 vote306 views1 answer
Django jwt custom authentication
Python Django
0 vote337 views1 answer
Python chatbot api
Python
0 vote328 views2 answers
When excel is loaded into python, numeric datatype changes to float
Python
18 votes347 views6 answers
Install Django Windows
Python
0 vote356 views1 answer
Username python system
Python