/Python/Pyodbc cursor create list of dictionaries

Pyodbc cursor create list of dictionaries

conn = pyodbc.connect( connectionString )
cursor = conn.cursor()
cursorQuery = "SELECT * FROM .."
cursor.execute( cursorQuery )
records = cursor.fetchall()
insertObject = []
columnNames = [column[0] for column in cursor.description]

for record in records:
    insertObject.append( dict( zip( columnNames , record ) ) )

Similar codes

0 vote185 views1 answer
Calculate the R^2 for X and Y python
Python
3 votes185 views1 answer
Autoslugfield django 3
Python Django
57 votes180 views6 answers
Timedelta python
Python
0 vote179 views1 answer
Password combination python
Python
6 votes168 views1 answer
Comibataion of two list
Python
0 vote195 views2 answers
How to draw a bar graph in python
Python
2 votes172 views3 answers
Python grid
Python
0 vote184 views1 answer
Py if else if
Python
8 votes182 views3 answers
How to import flask
Python
0 vote175 views1 answer
(django)inorder to provide a human readable name for the model.
Python