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

11 votes185 views6 answers
How to capitalize first letter in python
Python
1 vote228 views3 answers
Jsonresponse django
Python Django
1 vote178 views1 answer
Read google sheet from web to pandas python
Python
1 vote231 views1 answer
Upload image to s3 python
Python
9 votes183 views1 answer
How to convert a set to a list in python
Python
1 vote199 views1 answer
Time.sleep() faster
Python
2 votes182 views1 answer
Remove a file or dir in linux or mac or ubuntu
Python
1 vote196 views1 answer
Python fiscal year prior
Python
1 vote238 views1 answer
Django query multiple conditions
Python Django
0 vote185 views2 answers
Convert iterator to list python
Python