ansaurus

Question

Django getting executable raw sql for a QuerySet

Answer 1

+2 A:

Django never creates the raw sql, so no. To prevent SQL injection, django passes the parameters separately to the database drivers at the last step. The best way to get the actual SQL is to look at your query log, which you cannot do before you execute the query.

Mike Axiak 2010-09-22 12:24:26

So the answer is no. Thanks.

epoch 2010-09-22 12:31:54

@Mike: +1. @epoch: Correct, the answer is no. If you are curious to see the query as it passed to the backend, you can use the following snippet. `from django.db import DEFAULT_DB_ALIAS; queryset.query.get_compiler(DEFAULT_DB_ALIAS).as_sql()`

Manoj Govindan 2010-09-22 12:32:04

And if you really want to live life on the dangerous side, you could do this: `sql, params = queryset.query.get_compiler(DEFAULT_DB_ALIAS).as_sql();``sql = sql % tuple(["'%s'" % (param) for param in params])`

epoch 2010-09-22 12:33:02

I don't really see the problem with `__str__` when querying a PostgreSQL database when doing `Something.objects.all().query`?

Deniz Dogan 2010-09-22 12:35:03

But there is a problem when querying a development database (sqlite).

epoch 2010-09-22 12:35:51

ansaurus

tags:

views:

answers:

Django getting executable raw sql for a QuerySet

related questions