/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 votes314 views1 answer
No connection could be made because the target machine actively refused it python
Python
0 vote301 views1 answer
Pandas bins pd.cut()
Python
3 votes358 views1 answer
Remove keys from dict python
Python
0 vote332 views1 answer
Qtablewidget clear python
Python
0 vote335 views1 answer
Created by and updated by in django
Python
3 votes331 views3 answers
Pandas map
Python
0 vote320 views2 answers
ArgumentParser(parent)
Python
14 votes292 views1 answer
2 list difference python
Python
3 votes300 views1 answer
Python procedured
Python
1 vote302 views1 answer
Plot roc curve for neural network keras
Python