2c909f7d32128c29ff03da7713c3c7edfd91d785,debug_toolbar/panels/sql.py,,reformat_sql,#Any#,127

Before Change

    sql = sql.replace(",", ", ")
    sql = sql.replace("SELECT ", "SELECT\n\t")
    sql = sql.replace(" FROM ", "\nFROM\n\t")
    sql = sql.replace(" WHERE ", "\nWHERE\n\t")
    sql = sql.replace(" INNER JOIN", "\n\tINNER JOIN")
    sql = sql.replace(" LEFT OUTER JOIN" , "\n\tLEFT OUTER JOIN")
    sql = sql.replace(" ORDER BY ", "\nORDER BY\n\t")
    sql = sql.replace(" HAVING ", "\nHAVING\n\t")
    sql = sql.replace(" GROUP BY ", "\nGROUP BY\n\t")
    // Use Pygments to highlight SQL if it"s available
    try:
        from pygments import highlight
        from pygments.lexers import SqlLexer

After Change

def reformat_sql(sql):
    for kwd in SQL_KEYWORDS:
        sql = sql.replace(kwd, "<strong>%s</strong>" % (kwd,))
    return sql

Instances