/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 vote150 views1 answer
Python permission denied on mac
Python
0 vote139 views1 answer
Waitkey in python
Python
0 vote146 views1 answer
Zlib decompress python
Python
0 vote174 views1 answer
Django from
Python Django
0 vote203 views1 answer
Pip install pandas invalid syntax
Python
1 vote152 views1 answer
Append method linked list python
Python
13 votes147 views1 answer
Python read text file into string
Python
0 vote141 views2 answers
Arg parse array argument
Python
20 votes148 views4 answers
Check django version windows
Python
9 votes135 views1 answer
How to make it so a discord bot messages in a certain channel python
Python