Getting the SQL from a Django QuerySet [duplicate]

by

You print the queryset’s query attribute.

>>> queryset = MyModel.objects.all()
>>> print(queryset.query)
SELECT "myapp_mymodel"."id", ... FROM "myapp_mymodel"

More Related Contents:

  1. How to perform OR condition in django queryset?
  2. How to delete a record in Django models?
  3. How do I filter query objects by date range in Django?
  4. Django filter queryset __in for *every* item in list
  5. Django Aggregation: Summation of Multiplication of two fields
  6. How can I filter a date of a DateTimeField in Django?
  7. How can I filter a Django query with a list of values?
  8. How do I do a not equal in Django queryset filtering?
  9. Django Query That Get Most Recent Objects From Different Categories
  10. How do I get the object if it exists, or None if it does not exist in Django?
  11. Django orm get latest for each group
  12. LEFT JOIN Django ORM
  13. Django values_list vs values
  14. How to log all sql queries in Django?
  15. How to combine multiple querysets in Django?
  16. “_set” in a queryset object in Django
  17. Count number of records by date in Django
  18. What is an efficient way of inserting thousands of records into an SQLite table using Django?
  19. Simple Subquery with OuterRef
  20. What is the best way to access stored procedures in Django’s ORM
  21. QuerySet, Object has no attribute id – Django
  22. Django custom annotation function
  23. Using .aggregate() on a value introduced using .extra(select={…}) in a Django Query?
  24. How to do many-to-many Django query to find book with 2 given authors?
  25. Get the latest record with filter in Django
  26. django filter on the basis of text length
  27. How to quote a string value explicitly (Python DB API/Psycopg2)
  28. Django filter JSONField list of dicts
  29. How to annotate Count with a condition in a Django queryset
  30. Can a dictionary be passed to django models on create?

Leave a Comment