3c8bfbcdc608b0a868e655d647da3c8a33aa7449,mindsdb/api/mysql/mysql_proxy/classes/sql_query.py,SQLQuery,parse_insert,#Any#,52

Before Change

        search = re.search(r"(\(.*\)).*(\(.*\))", sql)
        columns = search.groups()[0].split(",")
        columns = [x.strip("(` )") for x in columns]
        p = re.compile("\s*,\s*".join(["(".*")"] * len(columns)))
        values = re.search(p, search.groups()[1])
        values = [x.strip("( ")") for x in values.groups()]

        return dict(zip(columns, values))

    def __init__(self, sql, integration=None, database=None):

After Change

        p = parse(f"select ({columns})")["select"]["value"]
        columns = p["literal"] if isinstance(p, dict) else p

        p = parse(f"select ({values})")["select"]["value"]
        values = p["literal"] if isinstance(p, dict) else p

        return dict(zip(columns, values))

Instances