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 vote298 views1 answer
Ram clear in python
Python
0 vote262 views1 answer
Python regex inside quotes
Python
1 vote292 views2 answers
Flask console log
Python Flask
1 vote263 views1 answer
How todelete a line in python
Python
40 votes290 views5 answers
Round decimal to 2 places python
Python
0 vote260 views1 answer
Legend of colorbar python
Python
1 vote274 views2 answers
What is a cube plus b cube
Python
0 vote207 views1 answer
List.fold_left
Python
3 votes289 views1 answer
Python Program to check for balanced parentheses in an expression using stack class.
Python
6 votes318 views2 answers
Flask get ip address of request
Python Flask