Can Django's ORM return a nested object queryset?

Question

If I have two models in a many to many relationship like below:

class Topping(models.Model):
    name = models.CharField(max_length=50)

class Pizza(models.Model):
    name = models.CharField(max_length=50)
    toppings = models.ManyToManyField(Topping)

Can I create a queryset that will give me something like this?:

[
  {
    "name": "Hawaiian",
    "toppings": [
      {"name": "Pineapple"},
      {"name": "Canadian Bacon"},
      {"name": "Cheese"}
    ]
  },
  {
    "name": "Pepperoni Pizza",
    "toppings": [
      {"name": "Pepperoni"},
      {"name": "Cheese"}
    ]
  }
]

Can I create the nested object queryset in one line?

Moses Koledoye · Accepted Answer · 2016-05-30 21:16:07Z

4

Django currently supports no query method for returning such objects directly from a query, however, you can use a prefetch_related to get the toppings for the pizza objects, and then build your nested object in python:

pizzas = Pizza.objects.prefetch_related('toppings')

nested_obj = [{"name": pizza.name, "toppings": [{"name": topping.name} for topping in pizza.toppings.all()]} for pizza in pizzas]

You still get to use one query.

answered May 30, 2016 at 21:16

Moses Koledoye

78.8k8 gold badges139 silver badges141 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

aero Over a year ago

Thanks Moses, that is what I was looking for!

Henrietta Martingale Over a year ago

It's 2019, is this still true?

Collectives™ on Stack Overflow

Can Django's ORM return a nested object queryset?

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related