Function clean_sql

bmtools/tools/database/utils/db_utils.py:13–18

(sql)

    return re.sub(r'(table|TABLE).+?\(.+?\)\s*;','',sql, flags=re.DOTALL)

def clean_sql(sql):
    tmp = []
    for token in sql.flatten():
        if not token.is_whitespace and not token.ttype is sqlparse.tokens.Comment.Single:
            tmp.append(token)
    return strip_par(' '.join(str(t) for t in tmp))

def strip_par(s):
    for op in ['(',')',',','>','=','<','>=','<=','!=','<>','.',';']: