Django 1.2 Equivalent of QuerySet.query.as_sql()

2019-01-20 08:15发布

问题:

In Django 1.1 I was able to produce the SQL used by a QuerySet with this notation:

QuerySet.query.as_sql()

In Django 1.2, this raises as AttributeError.

Anyone know the Django 1.2 equivalent of that method?

Thanks

回答1:

In Django 1.1, QuerySet.query returned a BaseQuery object, now it returns a Query objects. The query object has a __str__ method defined that returns the SQL.



回答2:

as answered in In django 1.2.1 how can I get something like the old .as_sql?

it's just:

print QuerySet.query