SQL Log Middleware

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
from django.db import connection
from django.template import Template, Context

class SQLLogMiddleware:

    def process_response ( self, request, response ): 
   
        t = Template('''
            <ul class="sqllog">
                {% for sql in sqllog %}
                    <li>{{ sql.sql }}</li>
                {% endfor %}
            </ul>
        ''')

        response.content = "%s%s" % ( response.content, t.render(Context({'sqllog':connection.queries})))

More like this

  1. SQL Log Middleware w/query count & exec time by tobias 6 years, 1 month ago
  2. Whore links by nathan 6 years, 2 months ago
  3. DebugFooter middleware by simon 5 years ago
  4. Google Contacts import by henriklied 5 years, 2 months ago
  5. SQL Log Middleware - with multiple databases by guglielmocelata 2 years, 3 months ago

Comments

rlawson (on March 30, 2007):

this worked great but I had to add the following line to return a response

...

response.content = "%s%s" % ( response.content, t.render(Context({'sqllog':connection.queries})))

return response

#

tobias (on April 7, 2007):

I posted an updated version of this with the above fix, a SQL query count, and execution time to:

www.djangosnippets.org/snippets/161/

#

guettli (on July 27, 2007):

I improved Snippet 161 in Snippet 344.

It counts duplicated SQL queries.

#

(Forgotten your password?)