Django: Calculate the Sum of the column values through query

by

You’re probably looking for aggregate

from django.db.models import Sum

ItemPrice.objects.aggregate(Sum('price'))
# returns {'price__sum': 1000} for example

More Related Contents:

  1. Django CSRF check failing with an Ajax POST request
  2. Having Django serve downloadable files
  3. How can I enable CORS on Django REST Framework
  4. Django URLs TypeError: view must be a callable or a list/tuple in the case of include()
  5. Error on “pip install -U channels” command using for otree (Running setup.py bdist_wheel for twisted … error)
  6. Django Rest Framework File Upload
  7. Split views.py in several files
  8. How to execute a GROUP BY … COUNT or SUM in Django ORM?
  9. Any way to make {% extends ‘…’ %} conditional? – Django
  10. How do I add a placeholder on a CharField in Django?
  11. is there a way to loop over two lists simultaneously in django?
  12. Is it better to use path() or url() in urls.py for django 2.0?
  13. Django DateField default options
  14. MySQL Improperly Configured Reason: unsafe use of relative path
  15. How to get value from form field in django framework?
  16. No Module named django.core
  17. How do I prevent fixtures from conflicting with django post_save signal code?
  18. Do properties work on Django model fields?
  19. What’s the best solution for OpenID with Django? [closed]
  20. How can I get the current language in Django?
  21. QuerySet, Object has no attribute id – Django
  22. How to update manytomany field in Django?
  23. Django ‘AnonymousUser’ object has no attribute ‘_meta’
  24. Install mysqlclient for Django Python on Mac OS X Sierra
  25. Add “django-admin.py” path to command line on Windows 7
  26. Django Multiple Databases – relation does not exist; LINE 1: SELECT COUNT(*) AS “__count” FROM
  27. How to get more diagnostic output on a “no module named xyz” error?
  28. How do I change the range of the x-axis with datetime?
  29. Django admin: How to display the field marked as “editable=False” in the model?
  30. How to solve “Page not found (404)” error in Django?

Leave a Comment