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

37 votes160 views5 answers
Get requests python
Python
0 vote137 views1 answer
From a list of lists - find all length of list
Python
-1 vote168 views1 answer
Binascii.Error: Incorrect padding in python django
Python Django
0 vote182 views1 answer
Django change foreign key
Python Django
0 vote130 views1 answer
Python function pointer with multiple args
Python
-1 vote156 views2 answers
Sum of all nan values pandas
Python
0 vote143 views1 answer
Plt.imread python
Python
3 votes141 views1 answer
Read .dat python
Python
3 votes145 views1 answer
Maping value to data in pandas dataframe
Python
12 votes137 views2 answers
Write number of lines in file python
Python