From 1c33baf352a2e4ec7de41cfdfb38ca62b5b3ee5b Mon Sep 17 00:00:00 2001
From: =?UTF-8?q?Andr=C3=A9=20Malo?= <ndparker@users.sf.net>
Date: Wed, 3 Oct 2012 13:15:38 -0400
Subject: Patch 2/4: executemany-regex improvement. It should match better and
 faster now. It also may be more readable.

https://sourceforge.net/p/mysql-python/patches/78/
---
 MySQLdb/MySQLdb/cursors.py | 31 +++++++++++++++++++++++++------
 1 file changed, 25 insertions(+), 6 deletions(-)

diff --git a/MySQLdb/MySQLdb/cursors.py b/MySQLdb/MySQLdb/cursors.py
index ffe60c0..a8cfa3e 100644
--- a/MySQLdb/MySQLdb/cursors.py
+++ b/MySQLdb/MySQLdb/cursors.py
@@ -15,13 +15,32 @@ except ImportError:
     TupleType = tuple
     UnicodeType = str
 
-restr = (r"\svalues\s*"
-        r"(\(((?<!\\)'[^\)]*?\)[^\)]*(?<!\\)?'"
-        r"|[^\(\)]|"
-        r"(?:\([^\)]*\))"
-        r")+\))")
+restr = r"""
+    \s
+    values
+    \s*
+    (
+        \(
+            [^()']*
+            (?:
+                (?:
+                        (?:\(
+                            # ( - editor hightlighting helper
+                            [^)]*
+                        \))
+                    |
+                        '
+                            [^\\']*
+                            (?:\\.[^\\']*)*
+                        '
+                )
+                [^()']*
+            )*
+        \)
+    )
+"""
 
-insert_values = re.compile(restr, re.I)
+insert_values = re.compile(restr, re.S | re.I | re.X)
 
 from _mysql_exceptions import Warning, Error, InterfaceError, DataError, \
      DatabaseError, OperationalError, IntegrityError, InternalError, \
-- 
cgit v1.2.1