Batch execution of insert SQL using the aiomysql.execemany method

[Zhao-Panpan]

When I use the aiomysql.execemany method to batch execute insert SQL, I find that the internal mechanism is for loop to execute all statements, comparison Pymysql.cursors File, found that the regular expression is different.
The comparison is as follows：
aiomysql.cursors File:

        RE_INSERT_VALUES = re.compile(
            r"\s*((?:INSERT|REPLACE)\s.+\sVALUES?\s+)" +
            r"(\(\s*(?:%s|%\(.+\)s)\s*(?:,\s*(?:%s|%\(.+\)s)\s*)*\))" +
            r"(\s*(?:ON DUPLICATE.*)?);?\s*\Z",
            re.IGNORECASE | re.DOTALL)

pymysql.cursors File:

        RE_INSERT_VALUES = re.compile(
            r"\s*((?:INSERT|REPLACE)\b.+\bVALUES?\s*)" +
            r"(\(\s*(?:%s|%\(.+\)s)\s*(?:,\s*(?:%s|%\(.+\)s)\s*)*\))" +
            r"(\s*(?:ON DUPLICATE.*)?);?\s*\Z",
            re.IGNORECASE | re.DOTALL)

my_data_sql = "insert abc(name) values(%s)"

I find insert abc(name) values (%s) no such problem，but when there is no space between values and (，have this problem.

I hope it can help me solve my doubts.

[Nothing4You]

thanks for the report, I believe you're referring to the missing port of PyMySQL/PyMySQL#597