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
    if queries:
        for q in queries:
            total_duration += q.duration
            statement = str(q.statement).replace('?', '%s')
            stmt = f"{statement}  {q.parameters}".replace('\n', '\n       ')
            query_str += 'Query: {0}\nDuration: {1}ms\n\n'.format(stmt, round(q.duration * 1000, 2))

        print('\n' + '=' * 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\n')

    return response

output.md