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)
|
