Output pyodbc cursor results as python dictionary

by

If you don’t know columns ahead of time, use Cursor.description to build a list of column names and zip with each row to produce a list of dictionaries. Example assumes connection and query are built:

>>> cursor = connection.cursor().execute(sql)
>>> columns = [column[0] for column in cursor.description]
>>> print(columns)
['name', 'create_date']
>>> results = []
>>> for row in cursor.fetchall():
...     results.append(dict(zip(columns, row)))
...
>>> print(results)
[{'create_date': datetime.datetime(2003, 4, 8, 9, 13, 36, 390000), 'name': u'master'},   
 {'create_date': datetime.datetime(2013, 1, 30, 12, 31, 40, 340000), 'name': u'tempdb'},
 {'create_date': datetime.datetime(2003, 4, 8, 9, 13, 36, 390000), 'name': u'model'},     
 {'create_date': datetime.datetime(2010, 4, 2, 17, 35, 8, 970000), 'name': u'msdb'}]

More Related Contents:

  1. Using lambda function in python
  2. I don’t know how to display step 3 for this assignment
  3. Make a dictionary with duplicate keys in Python
  4. Access a particular field in arbitrarily nested JSON data [duplicate]
  5. How to implement an ordered, default dict?
  6. Why do my Tkinter widgets get stored as None? [duplicate]
  7. How can you print a variable name in python? [duplicate]
  8. Python dictionary from an object’s fields
  9. Why can a Python dict have multiple keys with the same hash?
  10. TypeError: ‘dict’ object is not callable
  11. List of tuples to dictionary [duplicate]
  12. [] and {} vs list() and dict(), which is better?
  13. python tuple to dict
  14. Python Dictionary to CSV
  15. How to use dot notation for dict in python?
  16. How to sort IP addresses stored in dictionary in Python?
  17. top values from dictionary
  18. Change values in dict of nested dicts using items in a list?
  19. Updating a dictionary in python
  20. Dictionary best data structure for train routes?
  21. can you write a str.replace() using dictionary values in Python?
  22. Using python map and other functional tools
  23. A python class that acts like dict
  24. Find dictionary keys with duplicate values
  25. How can I get dictionary key as variable directly in Python (not by searching from value)?
  26. What are dict_keys, dict_items and dict_values?
  27. type=dict in argparse.add_argument()
  28. In Python, Using pyodbc, How Do You Perform Transactions?
  29. How do I merge dictionaries together in Python?
  30. Python: Writing Nested Dictionary to CSV

Leave a Comment