/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 vote204 views2 answers
Python function overloading
Python
134 votes154 views15 answers
Ternary operator python
Python
1 vote178 views1 answer
Python roll a die
Python
0 vote185 views1 answer
Function continuity python
Python
12 votes182 views2 answers
Presskeys in python
Python
0 vote240 views1 answer
Splitting on basis of regex python
Python
5 votes191 views3 answers
How to convert array value to integer in python
Python
1 vote176 views2 answers
Copy string python
Python
31 votes141 views1 answer
Sort_values pandas series
Python
0 vote192 views1 answer
Custom permission class django rest framework
Python