vkgtaro · November 22, 2012 09:29
diff --git a/get_prices.py b/get_prices.py
 from apps.appname.models import Receivable
 from django.db.models import Sum

 receivable = Receivable.objects.all()
 receivable.query.group_by = ['client_id']
 receivable.annotate( total_price = Sum('price') )
diff --git a/get_prices.sql b/get_prices.sql
 SELECT client_id, sum(price_total) as total FROM appname_receivable group by client_id;
	from apps.appname.models import Receivable
	from django.db.models import Sum

	receivable = Receivable.objects.all()
	receivable.query.group_by = ['client_id']
	receivable.annotate( total_price = Sum('price') )
No results found