[SQL-CVS] r2828 - SQLObject/branches/0.9/sqlobject

[<sub...@co...>]

Author: phd
Date: 2007-07-26 14:56:21 -0600 (Thu, 26 Jul 2007)
New Revision: 2828

Modified:
   SQLObject/branches/0.9/sqlobject/converters.py
Log:
Fixed a "brown paper bag" in MySQL quoting.


Modified: SQLObject/branches/0.9/sqlobject/converters.py
===================================================================
--- SQLObject/branches/0.9/sqlobject/converters.py	2007-07-26 20:56:11 UTC (rev 2827)
+++ SQLObject/branches/0.9/sqlobject/converters.py	2007-07-26 20:56:21 UTC (rev 2828)
@@ -109,10 +109,10 @@
     elif isinstance(value, buffer_type):
         value = str(value)
 
-    if db == 'postgres':
+    if db in ('mysql', 'postgres'):
         for orig, repl in sqlStringReplace:
             value = value.replace(orig, repl)
-    elif db in ('sqlite', 'mysql', 'firebird', 'sybase', 'maxdb', 'mssql'):
+    elif db in ('sqlite', 'firebird', 'sybase', 'maxdb', 'mssql'):
         value = value.replace("'", "''")
     else:
         assert 0, "Database %s unknown" % db