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 vote427 views1 answer
Get most repeated instance in a queryset django
Python Django
0 vote350 views1 answer
List all subdirectories up to a level
Python
0 vote366 views1 answer
How to maximize the screen in selenium
Python
-2 votes354 views4 answers
Tf version
Python
10 votes333 views4 answers
Write text in list to text file python
Python
0 vote398 views1 answer
Autopy in python install
Python
6 votes374 views2 answers
Python check if any elements in a list are different
Python
0 vote341 views2 answers
Loading bar
Python
0 vote350 views1 answer
Assert integer python
Python
4 votes350 views2 answers
Doc strings python
Python