Login

Pretty print SQL of query sets

Author:
peterbe
Posted:
May 5, 2009
Language:
Python
Version:
1.0
Score:
0 (after 0 ratings)

Install sqlparse with easy_install sqlparse and then you can easily debug the SQL like this:

def view(request):
    data = MyModel.objects.filter(something__very=complex)
    print_sql(data)
    ...

Inspired by Simon Willison

1
2
3
4
5
6
import sqlparse

def print_sql(qs):
    q = qs.query.as_sql()
    statement = q[0] % q[1]
    print sqlparse.format(statement, reindent=True, keyword_case='upper')

More like this

  1. New Snippet! by Antoliny0919 4 days, 15 hours ago
  2. Add Toggle Switch Widget to Django Forms by OgliariNatan 2 months, 3 weeks ago
  3. get_object_or_none by azwdevops 6 months, 2 weeks ago
  4. Mask sensitive data from logger by agusmakmun 8 months, 1 week ago
  5. Template tag - list punctuation for a list of items by shapiromatron 1 year, 10 months ago

Comments

peterbe (on May 5, 2009):

You might want to wrap this with something so that this doesn't get used in non-development mode. For example:

if not settings.DEBUG:
    def print_sql(*__):
        pass

#

canassa (on August 6, 2010):

This should work in Django 1.2:

def print_sql(qs):
    q = qs.query.__str__()
    print sqlparse.format(q, reindent=True, keyword_case='upper')

#

Please login first before commenting.