/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

2 votes101 views2 answers
Character in function python 3
Python
5 votes116 views1 answer
Python how move file to directory
Python
3 votes107 views1 answer
Autoslugfield django 3
Python
0 vote128 views1 answer
Get full detail inside of id in django rest framework many to many
Python
35 votes119 views4 answers
Python loop through directory
Python
0 vote71 views1 answer
How to print cow on python
Python
42 votes115 views6 answers
Train test split pandas
Python
0 vote112 views1 answer
Update profile rasterio pyton
Python
1 vote116 views1 answer
Import scipy python
Python
0 vote122 views1 answer
Odoo order by xml rpc
Python