Pretty print SQL of query sets

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. BabelMiddleware by skam 6 years, 9 months ago
  2. sharedance sessions backend by d2 6 years ago
  3. custom sql without table names by robharvey 6 years, 11 months ago
  4. Yet another SQL debugging facility by miracle2k 6 years, 8 months ago
  5. Simple solution for model schema evolution / database changelog by kahless 6 years, 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')

#

(Forgotten your password?)