Getting the SQL for a Django `update` query | Django | Page 1

rose sequoia Nov 24, 2022, 8:44 AM

#

Is it possible to have Django provide me the generated SQL for an update query without actually executing it?
I tried the following, but I can't actually do .query at the end, because the update query is evaluated. Therefore an int is returned, representing the number of updated rows.

str(Foobar.objects.all().update(example=F("created")).query)

untold minnow Nov 24, 2022, 4:00 PM

#

You can access recently run queries from the connection object. Let me see if I can find the docs

#

I think it's connection.queries

untold minnow Nov 24, 2022, 4:26 PM

#

Found it: https://docs.djangoproject.com/en/4.1/faq/models/#how-can-i-see-the-raw-sql-queries-django-is-running

Django Project

Django

The web framework for perfectionists with deadlines.

#Getting the SQL for a Django `update` query