/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 vote171 views1 answer
Pandas select data conditional
Python
30 votes169 views3 answers
Django create superuser from script
Python
0 vote185 views1 answer
Rom pathlib import Path # Build paths inside the project like this: BASE_DIR / 'subdir'. BASE_DIR = Path(__file__).resolve().parent.parent
Python
1 vote158 views1 answer
Catch error data with except python
Python
0 vote135 views1 answer
Os.exists
Python
2 votes161 views2 answers
Fibonacci using function in python
Python
9 votes172 views2 answers
How to loop through lines python
Python
0 vote162 views1 answer
Python shortest distance between two points
Python
0 vote167 views1 answer
Django active link
Python
0 vote166 views1 answer
Python open file from explorer
Python