How do I convert a Django QuerySet into list of dicts

Question

How can I convert a Django QuerySet into a list of dicts  I haven t found an answer to this so I m wondering if I m missing some sort of common helper function that everyone uses

User · Answer

Simply put list yourQuerySet

User · Answer

The  values   method will return you a result of type ValuesQuerySet which is typically what you need in most cases   But if you wish  you could turn ValuesQuerySet into a native Python list using Python list comprehension as illustrated in the example below   result   Blog objects values                 return ValuesQuerySet object list result    entry for entry in result     converts ValuesQuerySet into Python list return list result   I find the above helps if you are writing unit tests and need to assert that the expected return value of a function matches the actual return value  in which case both expected result and actual result must be of the same type  e g  dictionary    actual result   some function   expected result           dictionary content here       assert expected result    actual result

User · Answer

Use the  values   method     gt  gt  gt  Blog objects values      id   1   name    Beatles Blog    tagline    All the latest Beatles news       gt  gt  gt  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

User · Answer

You could define a function using model to dict as follows  def queryset to list qs fields None  exclude None       my list        for x in qs          my list append model to dict x fields fields exclude exclude       return my list  Suppose your Model has following fields id name email  Run following commands in django shell  gt  gt  gt qs  lt yourmodel gt  objects all    gt  gt  gt list queryset to dict qs   gt  gt  gt list    id  1   name   abc    email   abc ab co     id  2   name   xyz    email   xy xy co     Say you want only id and name in the list of queryset dictionary  gt  gt  gt qs  lt yourmodel gt  objects all    gt  gt  gt list queryset to dict qs fields   id   name     gt  gt  gt list    id  1   name   abc     id  2   name   xyz     Similarly you can exclude fields in your output

User · Answer

You can use the values   method on the dict you got from the Django model field you make the queries on and then you can easily access each field by a index value   Call it like this -   myList   dictOfSomeData values   itemNumberThree   myList 2   If there s a value in that index off course

User · Answer

If you need native data types for some reason  e g  JSON serialization  this is my quick  n  dirty way to do it   data      id   blog pk   name   blog name  for blog in blogs    As you can see building the dict inside the list is not really DRY so if somebody knows a better way

User · Answer

Type Cast to List     job reports   JobReport objects filter job id job id  status 1  values  id    name        json dumps list job reports

User · Answer

You need DjangoJSONEncoder and list to make your Queryset to json  ref  Python JSON serialize a Decimal object   import json from django core serializers json import DjangoJSONEncoder   blog   Blog objects all   values   json dumps list blog   cls DjangoJSONEncoder

User · Answer

You do not exactly define what the dictionaries should look like  but most likely you are referring to QuerySet values    From the official django documentation      Returns a ValuesQuerySet     a QuerySet subclass that returns   dictionaries when used as an iterable  rather than model-instance   objects       Each of those dictionaries represents an object  with the keys   corresponding to the attribute names of model objects

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

Examples related to python

Examples related to django