How do I convert a Django QuerySet into list of dicts?

by

Use the .values() method:

>>> Blog.objects.values()
[{'id': 1, 'name': 'Beatles Blog', 'tagline': 'All the latest Beatles news.'}],
>>> Blog.objects.values('id', 'name')
[{'id': 1, 'name': 'Beatles Blog'}]

Note: the result is a QuerySet which mostly behaves like a list, but isn’t actually an instance of list. Use list(Blog.objects.values(…)) if you really need an instance of list.

More Related Contents:

  1. Creating a JSON response using Django and Python
  2. Mac OS X – EnvironmentError: mysql_config not found
  3. How to compare dates in Django templates
  4. How to limit the maximum value of a numeric field in a Django model?
  5. Django [Errno 13] Permission denied: ‘/var/www/media/animals/user_uploads’
  6. PicklingError: Can’t pickle : it’s not the same object as decimal.Decimal
  7. multiple databases and multiple models in django
  8. Creating a list of dictionaries with same keys? [duplicate]
  9. How do I perform query filtering in django templates
  10. Django Multiple Choice Field / Checkbox Select Multiple
  11. Django gives Bad Request (400) when DEBUG = False
  12. Django Rest Framework – Authentication credentials were not provided
  13. Django: Calculate the Sum of the column values through query
  14. How to disable Django’s CSRF validation?
  15. How to update an existing Conda environment with a .yml file
  16. Django migration with uuid field generates duplicated values
  17. How to set and get session variable in django?
  18. Race conditions in django
  19. Django – TypeError – save() got an unexpected keyword argument ‘force_insert’
  20. Django 404 error-page not found
  21. Correct way to use get_or_create?
  22. How to put comments in Django templates?
  23. Identify the changed fields in django post_save signal
  24. how to add annotate data in django-rest-framework queryset responses?
  25. How to quote a string value explicitly (Python DB API/Psycopg2)
  26. Django form.as_p DateField not showing input type as date
  27. Django – Working with multiple forms
  28. Django foreign key relation in template
  29. Django: How can I check the last activity time of user if user didn’t log out?
  30. What is PyMySQL and how does it differ from MySQLdb? Can it affect Django deployment?

Leave a Comment