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

3 votes169 views1 answer
Find all index of element in list python
Python
0 vote210 views1 answer
Discord.py cog classes
Python
1 vote215 views1 answer
Pandas change dtype to string
Python
15 votes220 views3 answers
Python random text generator
Python
0 vote205 views1 answer
Convert birth date to age pandas
Python
2 votes223 views1 answer
YAMLLoadWarning: calling yaml.load() without Loader=... is deprecated, as the default Loader is unsafe. Please read https://msg.pyyaml.org/load for full details.
Python
7 votes225 views4 answers
Fizzbuzz in python
Python
0 vote212 views1 answer
Python one line key increment or add
Python
9 votes198 views3 answers
Print for loop in same line python
Python
1 vote234 views1 answer
Jinja2 template import html with as
Python