/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 vote101 views1 answer
Get method to create a set of counters in python
Python
0 vote188 views1 answer
Django.db.backends.mysql install
Python Django
0 vote156 views1 answer
Functional conflict definition
Python
3 votes148 views2 answers
Variance calculation python manually
Python
5 votes146 views1 answer
How to delete everything on a file python
Python
11 votes157 views3 answers
Ocr python library
Python
0 vote126 views1 answer
Calculate Euclidean Distance in Python using norm()
Python
1 vote148 views1 answer
How to write words on any other apps in python
Python
0 vote123 views2 answers
How to create an empty 2d list in python
Python
2 votes120 views2 answers
'flask' is not recognized as an internal or external command, operable program or batch file.
Python