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 vote263 views1 answer
Pandas heading
Python
2 votes345 views2 answers
Useful python snippets
Python
0 vote307 views1 answer
Importing cosine from scipy
Python
3 votes309 views2 answers
Install python with git bash
Python
0 vote301 views1 answer
Pandas select only earliest event for duplicates
Python
11 votes285 views3 answers
How to convert a list into string with \n
Python
0 vote315 views1 answer
Writerows to existing csv python
Python
0 vote341 views1 answer
How to get pytroch model layer name
Python
0 vote301 views1 answer
Pandas df count values less than 0
Python
17 votes303 views4 answers
WARNING: You are using pip version 21.2.3; however, version 21.2.4 is available
Python