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 vote200 views1 answer
How to refresh windows 10 with python
Python
0 vote235 views1 answer
Python os.walk recursive
Python
1 vote221 views1 answer
Hex to binary python3
Python
8 votes206 views2 answers
How to create a random number between 1 and 10 in python
Python
7 votes256 views4 answers
Numpy normalize
Python
16 votes194 views1 answer
Python reload module without restarting
Python
2 votes237 views2 answers
Python do nothing
Python
0 vote204 views1 answer
Python argsort a list
Python
5 votes216 views2 answers
Array of 1 to 100 python
Python
0 vote219 views1 answer
Open word from python
Python