/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 votes288 views1 answer
Keras tuner
Python
5 votes274 views1 answer
Find all files in a directory with extension python
Python
0 vote270 views1 answer
Git ignore everything but python files
Python
2 votes280 views1 answer
Get local ip
Python
0 vote267 views1 answer
How to add previous and next in tkinter in python
Python
0 vote241 views1 answer
How to make a username system using python
Python
0 vote309 views1 answer
Sum of all substrings of a number
Python
0 vote252 views1 answer
No python 3.10 installation was detected
Python
0 vote269 views2 answers
How to make a bill in python
Python
0 vote272 views1 answer
Python is inf
Python