/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 votes252 views4 answers
Django login required
Python Django
0 vote200 views1 answer
Python load array
Python
4 votes173 views4 answers
Printing hello world in python
Python
0 vote176 views1 answer
Leetcode 206 python
Python
0 vote289 views1 answer
Python numpy bbox
Python
1 vote165 views2 answers
Get index of element in numpy array python
Python
0 vote176 views1 answer
Get maximum values in a column by a subgroup of a dataframe pandas
Python
0 vote194 views1 answer
Travis deployment script for django applications to heroku
Python
0 vote199 views1 answer
What Is Python Recursive Function in python
Python
0 vote244 views1 answer
Add a value to the start of a list python
Python