Sum multiple annotates in django orm

Question

Here's my model:

class Product:
  name = models.CharField(max_length=80)
  price = models.FloatField()
  category = models.CharField(max_length=40)

class ProductInventory:
  inventory = models.IntegerField()
  product = models.OneToOneField(Product, on_delete=models.RESTRICT)

and here's raw sql of what I want to achieve but how do I write this in django ORM?

SELECT product.category, SUM(price) * SUM(product_inventory.inventory) 
FROM product LEFT JOIN product_inventory 
ON product.id=product_inventory.product_id group by product.category;

Thank you.

user15195370 · Accepted Answer · 2021-09-06 06:25:21Z

2

You can try by using Sum in annotate and make a dummy field of name sum_product and pass it in values like this. Hope this will work for you.

from django.db.models import Sum

Product.objects.annotate(sum_product=Sum('price') * Sum('productinventory__inventory')).values('category', 'sum_product')

answered Sep 6, 2021 at 6:25

user15195370

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

Collectives™ on Stack Overflow

Sum multiple annotates in django orm

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related