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

8 votes147 views2 answers
Python iterate backwards through list
Python
0 vote244 views1 answer
Django test imagefield
Python Django
0 vote146 views1 answer
Python operator overloading deal with type
Python
5 votes147 views3 answers
Convert list to dataframe
Python
0 vote152 views1 answer
Qmenu hide python
Python
0 vote143 views1 answer
Flask minimal install
Python
0 vote165 views1 answer
How to print 's in python
Python
0 vote143 views1 answer
Id
Python
0 vote172 views1 answer
Perform a left outer join of self and other.
Python
2 votes185 views2 answers
ModuleNotFoundError: No module named 'Cython'
Python