Raw SQL queries in Django views

by 
>>> from django.db import connection
>>> cursor = connection.cursor()
>>> cursor.execute('''SELECT count(*) FROM people_person''')
1L
>>> row = cursor.fetchone()
>>> print row
(12L,)
>>> Person.objects.all().count()
12

use WHERE clause to filter vote for yes:

>>> cursor.execute('''SELECT count(*) FROM people_person WHERE vote = "yes"''')
1L

More Related Contents:

  1. How to filter empty or NULL names in a QuerySet?
  2. Custom QuerySet and Manager without breaking DRY?
  3. Why does django’s prefetch_related() only work with all() and not filter()?
  4. Select DISTINCT individual columns in django?
  5. django – get() returned more than one topic
  6. How to limit queryset/the records to view in Django admin site?
  7. Django: implementing JOIN using Django ORM?
  8. Django – filtering on foreign key properties
  9. QuerySet, Object has no attribute id – Django
  10. Django query datetime for objects older than 5 hours
  11. Django: Does prefetch_related() follow reverse relationship lookup?
  12. django most efficient way to count same field values in a query
  13. Django Order By Date, but have “None” at end?
  14. how to write a query to get find value in a json field in django
  15. Hi I am new to Django Framework.getting error :No Module Named
  16. When saving, how can you check if a field has changed?
  17. How do I do an OR filter in a Django query?
  18. Django: How can I protect against concurrent modification of database entries
  19. How to express a One-To-Many relationship in Django?
  20. Setting the selected value on a Django forms.ChoiceField
  21. Django: Set foreign key using integer?
  22. django: Purpose of django.utils.functional.SimpleLazyObject?
  23. Provide extra context to all views
  24. Django model: delete() not triggered
  25. How to change the file name of an uploaded file in Django?
  26. matching query does not exist Error in Django
  27. django @login_required decorator for a superuser
  28. Django lazy QuerySet and pagination
  29. Django, query filtering from model method
  30. Forbidden (403) CSRF verification failed. Request aborted

Leave a Comment