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 vote231 views1 answer
Name exit not defined python
Python
0 vote250 views1 answer
Learn basic facts about dataframe | dataframe info
Python
0 vote272 views1 answer
Print map object python
Python
1 vote237 views2 answers
Python alphabetical order
Python
0 vote250 views1 answer
Pronic number program in python
Python
10 votes224 views2 answers
Python re.search()
Python
-1 vote234 views1 answer
Matrix python math
Python
0 vote239 views1 answer
Sorting-a-python-list-by-two-fields
Python
2 votes243 views1 answer
Adding new column to existing DataFrame in Pandas using assign method
Python
0 vote216 views1 answer
Python edit global variable in function
Python