Getting the SQL from a Django QuerySet

Question

How do I get the SQL that Django will use on the database from a QuerySet object  I m trying to debug some strange behavior  but I m not sure what queries are going to the database  Thanks for your help

User · Answer

The accepted answer did not work for me when using Django 1.4.4. Instead of the raw query, a reference to the Query object was returned: <django.db.models.sql.query.Query object at 0x10a4acd90>.

The following returned the query:

>>> queryset = MyModel.objects.all()
>>> queryset.query.__str__()

User · Answer

Easy   print my queryset query   For example   from django contrib auth models import User print User objects filter last name  icontains    ax   query   It should also be mentioned that if you have DEBUG   True  then all of your queries are logged  and you can get them by accessing connection queries   from django db import connections connections  default   queries   The django debug toolbar project uses this to present the queries on a page in a neat manner

User · Answer

As an alternative to the other answers  django-devserver outputs SQL to the console

User · Answer

You print the queryset s query attribute    gt  gt  gt  queryset   MyModel objects all    gt  gt  gt  print queryset query  SELECT  myapp mymodel   id       FROM  myapp mymodel

User · Answer

This middleware will output every SQL query to your console  with color highlighting and execution time  it s been invaluable for me in optimizing some tricky requests  http   djangosnippets org snippets 290

[python] Getting the SQL from a Django QuerySet

Examples related to python

Examples related to sql

Examples related to django

Examples related to django-queryset