/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

6 votes212 views2 answers
How to limit a command to a permission in discord.py
Python
0 vote233 views1 answer
Python range of array
Python
5 votes236 views2 answers
Django password field
Python Django
1 vote243 views1 answer
Calculate integral python
Python
1 vote228 views1 answer
Clamp number in python
Python
0 vote256 views1 answer
Write a python program to find fibonacci series upto a certain limit using while loop
Python
0 vote283 views1 answer
Precedence in python
Python
0 vote221 views1 answer
Np array blurring
Python
1 vote200 views2 answers
How to download more languages for pyttsx3
Python
113 votes177 views10 answers
Python choose random element from list
Python