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 votes338 views2 answers
Lda scikit learn
Python
37 votes325 views3 answers
Python print to terminal with color
Python
29 votes381 views6 answers
Create empty pandas dataframe
Python
0 vote335 views1 answer
Django-filter field name greater than
Python
-2 votes351 views1 answer
Start django project in windows
Python
7 votes398 views1 answer
Np array n same values
Python
0 vote346 views2 answers
Arma-garch python
Python
0 vote369 views1 answer
ImportError: No module named colored
Python
2 votes318 views1 answer
Hardest python questions
Python
0 vote337 views1 answer
Python scramble up elements in list
Python