[Erp5-report] r15152 - /erp5/trunk/products/ZMySQLDDA/db.py

[nobody at svn.erp5.org]

Author: vincent
Date: Thu Jul  5 11:34:41 2007
New Revision: 15152

URL: http://svn.erp5.org?rev=15152&view=rev
Log:
Use symbolic constant. Thanks to Kazuhiko for the hint.

Modified:
    erp5/trunk/products/ZMySQLDDA/db.py

Modified: erp5/trunk/products/ZMySQLDDA/db.py
URL: http://svn.erp5.org/erp5/trunk/products/ZMySQLDDA/db.py?rev=15152&r1=15151&r2=15152&view=diff
==============================================================================
--- erp5/trunk/products/ZMySQLDDA/db.py (original)
+++ erp5/trunk/products/ZMySQLDDA/db.py Thu Jul  5 11:34:41 2007
@@ -96,7 +96,7 @@
        (MySQLdb_version_required, _v)
 
 from MySQLdb.converters import conversions
-from MySQLdb.constants import FIELD_TYPE, CR, CLIENT
+from MySQLdb.constants import FIELD_TYPE, CR, ER, CLIENT
 from Shared.DC.ZRDB.TM import TM
 from DateTime import DateTime
 from zLOG import LOG, ERROR, INFO
@@ -109,6 +109,10 @@
 hosed_connection = (
     CR.SERVER_GONE_ERROR,
     CR.SERVER_LOST
+    )
+
+query_syntax_error = (
+    ER.BAD_FIELD_ERROR,
     )
 
 key_types = {
@@ -383,7 +387,7 @@
       try:
         self.db.query(query)
       except OperationalError, m:
-        if m[0] == 1054: # Query syntax error: display query.
+        if m[0] in query_syntax_error:
           raise OperationalError(m[0], '%s: %s' % (m[1], query))
         if ((not force_reconnect) and \
             (self._mysql_lock or self._transactions)) or \