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 vote129 views1 answer
How to not create a new line in python
Python
1 vote165 views2 answers
Django make new application folder
Python Django
0 vote125 views1 answer
Python datetime now only hour and minute
Python
4 votes115 views2 answers
Endswith python
Python
2 votes148 views1 answer
How to save query data into dataframe pscopg2
Python
6 votes192 views1 answer
Cors error in flask
Python Flask
9 votes126 views3 answers
Print current time hours and minutes in python
Python
0 vote84 views1 answer
Pandas corr p value
Python
1 vote142 views1 answer
Start index from 1 in python
Python
0 vote125 views1 answer
Db connection string timeout
Python