Python

Search

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 ) ) )

Comment

PREVIOUS	NEXT

Code Example
Python :: hash table in python
Python :: pandas round floats
Python :: np.reshape()
Python :: how to get number after decimal point
Python :: how to empty a dictionary in python
Python :: iterating through a list in python
Python :: django login page
Python :: transpose list
Python :: Iterate through string backwards in python
Python :: discordpy owner only command
Python :: how to check for empty dataframe
Python :: python circular import
Python :: Matplotlib inside Jupyter \| Jupyter generate graphs.
Python :: set environment variable flask app
Python :: sklearn ridge regression
Python :: how to make a python terminal
Python :: add title to relplot seaborn
Python :: how to use the super
Python :: tiff to jpg in python
Python :: select default option django form
Python :: aws django migrate
Python :: pandas currency to numbe
Python :: render() in django
Python :: install simple audio in python
Python :: pandas series filter by index
Python :: formula of factorial
Python :: virtualenv
Python :: python run code at the same time
Python :: find word position in string python
Python :: get channle from id discord.py

Search

PYTHON

pyodbc cursor create list of dictionaries

ADD CONTENT