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

26 votes256 views4 answers
Python global variables
Python
9 votes224 views3 answers
Python 2.7 datetime to timestamp
Python
-1 vote200 views1 answer
Create close python program in puthon
Python
1 vote187 views1 answer
Minimum from list of tuples
Python
13 votes198 views3 answers
Np.hstack
Python
9 votes210 views2 answers
Flask flash
Python
0 vote194 views4 answers
Python print string
Python
0 vote210 views1 answer
Equivalent of setInterval python
Python
0 vote208 views1 answer
Smtp django
Python
0 vote212 views2 answers
Get decimal value of char python
Python