/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 vote223 views1 answer
Best way to access nested key in python
Python
12 votes277 views3 answers
Python delete all files in directory
Python
2 votes252 views2 answers
Split datetime to date and time pandas
Python
0 vote234 views1 answer
Como usar o Self no python
Python
0 vote254 views1 answer
Graph bokeh
Python
0 vote230 views1 answer
Ascii value of pi symbol in python
Python
0 vote230 views1 answer
Pandas and operator
Python
2 votes228 views1 answer
How to make rich presence discord,py
Python
13 votes227 views2 answers
Python last letter of string
Python
2 votes246 views2 answers
Fibonacci series using for loop in python
Python