[SQL-CVS] r3980 - SQLObject/branches/0.10/sqlobject

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

Author: phd
Date: 2009-09-20 09:53:02 -0600 (Sun, 20 Sep 2009)
New Revision: 3980

Modified:
   SQLObject/branches/0.10/sqlobject/sqlbuilder.py
Log:
Use LIKE() instead of SQLOp('LIKE'); pass backslash as the escape.


Modified: SQLObject/branches/0.10/sqlobject/sqlbuilder.py
===================================================================
--- SQLObject/branches/0.10/sqlobject/sqlbuilder.py	2009-09-20 15:50:22 UTC (rev 3979)
+++ SQLObject/branches/0.10/sqlobject/sqlbuilder.py	2009-09-20 15:53:02 UTC (rev 3980)
@@ -835,13 +835,13 @@
         return NOT(_IN(item, list))
 
 def STARTSWITH(expr, pattern):
-    return SQLOp("LIKE", expr, _LikeQuoted(pattern) + '%')
+    return LIKE(expr, _LikeQuoted(pattern) + '%', escape='\\')
 
 def ENDSWITH(expr, pattern):
-    return SQLOp("LIKE", expr, '%' + _LikeQuoted(pattern))
+    return LIKE(expr, '%' + _LikeQuoted(pattern), escape='\\')
 
 def CONTAINSSTRING(expr, pattern):
-    return SQLOp("LIKE", expr, '%' + _LikeQuoted(pattern) + '%')
+    return LIKE(expr, '%' + _LikeQuoted(pattern) + '%', escape='\\')
 
 def ISNULL(expr):
     return SQLOp("IS", expr, None)