A handy SQL debug function for Flask-SQLAlchemy

debug_stuff.py

from . import app
from flask.ext.sqlalchemy import get_debug_queries

if app.debug:
    app.after_request(sql_debug)


def sql_debug(response):
    queries = list(get_debug_queries())
    query_str = ''
    total_duration = 0.0
    for q in queries:
        total_duration += q.duration
        stmt = str(q.statement % q.parameters).replace('\n', '\n       ')
        query_str += 'Query: {0}\nDuration: {1}ms\n\n'.format(stmt, round(q.duration * 1000, 2))

    print '=' * 80
    print ' SQL Queries - {0} Queries Executed in {1}ms'.format(len(queries), round(total_duration * 1000, 2))
    print '=' * 80
    print query_str.rstrip('\n')
    print '=' * 80 + '\n'

    return response

output.md

awesome stuff

Thanks a lot :)

Update:
flask.ext.sqlalchemy - is deprecated. So using:

from flask_sqlalchemy import get_debug_queries

Please revise for python 3 and above

its updated for python 3 here : https://gist.github.com/debashisdeb/7d6640d8cd6d3b9fb2c51695d6cda882

thanks

This is really awesome! THANKS!!!

Awesome! Thank a lot!

Thank you for that useful function

I just added an if statement for myself to prevent useless prints