Allow semicolon at the end of bulk insert query (PyMySQL#545)

Guangyang Li · methane · commit 103a00d4ee59 · 2017-02-28T18:54:17.000+09:00
diff --git a/pymysql/cursors.py b/pymysql/cursors.py
@@ -14,7 +14,7 @@
 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.*)?)\Z",
+    r"(\s*(?:ON DUPLICATE.*)?);?\s*\Z",
     re.IGNORECASE | re.DOTALL)
 
 
