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

3 votes218 views1 answer
The authorization mechanism you have provided is not supported. Please use AWS4-HMAC-SHA256
Python
0 vote158 views3 answers
Python bill
Python
3 votes174 views1 answer
Np append row
Python
7 votes160 views3 answers
Python print exception type and message
Python
0 vote136 views1 answer
Python tri alphabetique
Python
0 vote186 views1 answer
How to cerate a bar chart seaborn
Python
1 vote175 views1 answer
Require http method django view
Python
3 votes169 views1 answer
Dataframe to list
Python
1 vote175 views1 answer
Db_index django
Python
0 vote213 views1 answer
How to add the sum of multiple columns into another column in a dataframe
Python