/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

-1 vote206 views1 answer
How to make a bitcoin miner in pythonn
Python
35 votes187 views6 answers
How to create an array in python
Python
0 vote215 views1 answer
Python remove .0
Python
0 vote188 views1 answer
Pandas assign value to row based on condition
Python
4 votes216 views2 answers
How to make never ending program in python
Python
1 vote207 views1 answer
User matching query does not exist. django
Python
0 vote259 views1 answer
Plotly facet_grid python
Python
0 vote191 views1 answer
R sample() funciton in python
Python
0 vote207 views2 answers
Python min value index from an array
Python
0 vote208 views1 answer
Saving a copy of rcParams settings.
Python