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

86 votes243 views3 answers
How to read json from python
Python
0 vote232 views1 answer
Function continuity python
Python
0 vote210 views1 answer
How to check local endianness with Python ?
Python
0 vote237 views1 answer
Swap case hackerrank solution
Python
4 votes226 views2 answers
Freq count in python
Python
13 votes214 views1 answer
What is a slug
Python
0 vote228 views1 answer
Pandas read tab separated file
Python
3 votes247 views2 answers
Extract column numpy array python
Python
1 vote221 views1 answer
Tuple with one element python
Python
9 votes264 views3 answers
Find python path windows
Python