Django snippets: Pretty print SQL of query sets

Pretty print SQL of query sets

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

A custom URL shortening view, for use with rev=canonical by simon 4 years, 2 months ago
Git recent commits template tag by david 4 years, 10 months ago
Add Extra Headers to Test Client Requests by luftyluft 4 years, 11 months ago
QuerySetManager - easily add new QuerySet methods using a Model inner class by simon 5 years, 1 month ago
Fire Eagle example: views.py from wikinear.com by simon 5 years, 3 months ago

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

Author:: peterbe
Posted:: May 5, 2009
Language:: Python
Django Version:: 1.0
Tags:: sql queryset sqlparse
Score:: 0 (after 0 ratings)

Tools

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')