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

Before Change

    @staticmethod
    def parse_insert(sql):
        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()]

After Change

        columns = columns[columns.find("(") + 1:columns.rfind(")")]
        values = values[values.find("(") + 1:values.rfind(")")]

        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

Instances