Function preprocess_execute_sql

bmtools/tools/database/utils/db_utils.py:25–36

(sql)

    return s

def preprocess_execute_sql(sql):
    sql = remove_create_table(sql)
    sql = remove_create_index(sql)
    parsed = sqlparse.parse(sql)
    if len(parsed) == 0:
        return [0, '']
    sql = clean_sql(parsed[0])
    if not sql:
        return [0, '']
    if sql[-1] != ';':
        sql += ';'
    return [1, sql]