Why .query() function not working on Django ORM query?

Question

As I already know that using .query.__str__() , we can get sql equivalent query from Django ORM query.

e.g : Employees.objects.filter(id = int(id)).query.__str__()

Above code working well & I am able to get sql equivalent query but when I am using same on below query I am getting error like below.

Employees.objects.filter(id = int(id)).first().query.__str__()
AttributeError: 'Employees' object has no attribute 'query'

Why now I am getting error, any suggestions ?

willeM_ Van Onsem · Accepted Answer · 2019-10-30 08:01:08Z

4

.first() [Django-doc] does not return a QuerySet, it returns a model object. The query is evaluated eagerly.

You can inspect the last query that Django made with:

from django.db import connection
print(connection.queries[-1:])

That being said, in essence a some_queryset.first() is often the same query as some_queryset, except that it will limit the queryset.

Note: Please do not use .__str__, you can use str(my_queryset.query), or just print(my_queryset.query).

answered Oct 30, 2019 at 8:01

willeM_ Van Onsem

482k33 gold badges483 silver badges624 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Thanks ! Above explanation clear my doubts & solved my problem !