On Feb 21, 7:32 pm, diafygi <diaf...@gmail.com> wrote:
> There's a previous thread about this[1], but it was closed back in
> 2006 without resolution. So I'd like to check back in and see if there
> is a way to get a complete query string without executing the query.
>
> At first, I thought I could just use the QuerySet.query.__str__(), but
> that does not put quotes around dates, so MySQL returns a warning when
> trying to execute it. I filed a bug report[2], but apparently
> QuerySet.query.__str__() isn't supposed to return a valid query
> string.
>
> So is there a way to get the compiled query string without executing
> the query (including when debug=False)?
>
> Thanks!
> Daniel
>
> [1] -http://groups.google.com/group/django-users/browse_thread/thread/37a6...
> [2] -https://code.djangoproject.com/ticket/17741
What I usually do is set a breakpoint with pdb at the appropriate
place ('import pdb; pdb.set_trace()') then run the devel server, and
then you hit the breakpoint do 'print queryset.query'
There's also this:
https://docs.djangoproject.com/en/dev/faq/models/#how-can-i-see-the-raw-sql-queries-django-is-running
But I've never tried it.
-larry
--
You received this message because you are subscribed to the Google Groups
"Django users" group.
To post to this group, send email to django-users@googlegroups.com.
To unsubscribe from this group, send email to
django-users+unsubscr...@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/django-users?hl=en.
