2c909f7d32128c29ff03da7713c3c7edfd91d785,debug_toolbar/panels/sql.py,,reformat_sql,#,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")

After Change


    return (td.seconds * 1000) + (td.microseconds / 1000.0)

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

Italian Trulli
In pattern: SUPERPATTERN

Frequency: 3

Non-data size: 3

Instances


Project Name: jazzband/django-debug-toolbar
Commit Name: 2c909f7d32128c29ff03da7713c3c7edfd91d785
Time: 2009-08-28
Author: rob@cogit8.org
File Name: debug_toolbar/panels/sql.py
Class Name:
Method Name: reformat_sql


Project Name: explosion/thinc
Commit Name: 7ee43f4346812c46b8df43c8cdf7a3016958949c
Time: 2020-01-15
Author: ines@ines.io
File Name: setup.py
Class Name:
Method Name: clean


Project Name: statsmodels/statsmodels
Commit Name: db637720f06b99c3f21721843a942cd90bda3be6
Time: 2020-09-19
Author: josef.pktd@gmail.com
File Name: statsmodels/miscmodels/ordinal_model.py
Class Name: OrderedModel
Method Name: from_formula