/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 vote177 views1 answer
Long press selenium python
Python
5 votes214 views2 answers
Zipfile python unzip with path
Python
1 vote215 views1 answer
Calcutalte average python
Python
7 votes175 views1 answer
How to check if file exists pyuthon
Python
0 vote171 views1 answer
Changing default fonts in matploitlibrc file
Python
30 votes154 views2 answers
Mysql.connector methods python
Python
5 votes176 views2 answers
Python train test val split
Python
18 votes130 views2 answers
Python string append character
Python
1 vote170 views1 answer
Lisy in python
Python
-1 vote156 views1 answer
Python Sort Lists
Python