From 8d0c5672f06952382b4eedf78158a043b3529878 Mon Sep 17 00:00:00 2001 From: Mike Bayer Date: Wed, 19 Mar 2008 20:25:51 +0000 Subject: added escape kw arg to contains(), startswith(), endswith(), [ticket:791] --- lib/sqlalchemy/sql/expression.py | 24 ++++++++++++------------ lib/sqlalchemy/sql/operators.py | 12 ++++++------ 2 files changed, 18 insertions(+), 18 deletions(-) (limited to 'lib/sqlalchemy/sql') diff --git a/lib/sqlalchemy/sql/expression.py b/lib/sqlalchemy/sql/expression.py index 701987e20..0d10c844a 100644 --- a/lib/sqlalchemy/sql/expression.py +++ b/lib/sqlalchemy/sql/expression.py @@ -1146,14 +1146,14 @@ class ColumnOperators(Operators): def in_(self, *other): return self.operate(operators.in_op, other) - def startswith(self, other): - return self.operate(operators.startswith_op, other) + def startswith(self, other, **kwargs): + return self.operate(operators.startswith_op, other, **kwargs) - def endswith(self, other): - return self.operate(operators.endswith_op, other) + def endswith(self, other, **kwargs): + return self.operate(operators.endswith_op, other, **kwargs) - def contains(self, other): - return self.operate(operators.contains_op, other) + def contains(self, other, **kwargs): + return self.operate(operators.contains_op, other, **kwargs) def desc(self): return self.operate(operators.desc_op) @@ -1283,21 +1283,21 @@ class _CompareMixin(ColumnOperators): return self.__compare(op, ClauseList(*args).self_group(against=op), negate=negate_op) - def startswith(self, other): + def startswith(self, other, escape=None): """Produce the clause ``LIKE '%'``""" # use __radd__ to force string concat behavior - return self.__compare(operators.like_op, literal_column("'%'", type_=sqltypes.String).__radd__(self._check_literal(other))) + return self.__compare(operators.like_op, literal_column("'%'", type_=sqltypes.String).__radd__(self._check_literal(other)), escape=escape) - def endswith(self, other): + def endswith(self, other, escape=None): """Produce the clause ``LIKE '%'``""" - return self.__compare(operators.like_op, literal_column("'%'", type_=sqltypes.String) + self._check_literal(other)) + return self.__compare(operators.like_op, literal_column("'%'", type_=sqltypes.String) + self._check_literal(other), escape=escape) - def contains(self, other): + def contains(self, other, escape=None): """Produce the clause ``LIKE '%%'``""" - return self.__compare(operators.like_op, literal_column("'%'", type_=sqltypes.String) + self._check_literal(other) + literal_column("'%'", type_=sqltypes.String)) + return self.__compare(operators.like_op, literal_column("'%'", type_=sqltypes.String) + self._check_literal(other) + literal_column("'%'", type_=sqltypes.String), escape=escape) def label(self, name): """Produce a column label, i.e. `` AS ``. diff --git a/lib/sqlalchemy/sql/operators.py b/lib/sqlalchemy/sql/operators.py index 13f5e6131..0047d1c73 100644 --- a/lib/sqlalchemy/sql/operators.py +++ b/lib/sqlalchemy/sql/operators.py @@ -49,14 +49,14 @@ def notin_op(a, b): def distinct_op(a): return a.distinct() -def startswith_op(a, b): - return a.startswith(b) +def startswith_op(a, b, escape=None): + return a.startswith(b, escape=escape) -def endswith_op(a, b): - return a.endswith(b) +def endswith_op(a, b, escape=None): + return a.endswith(b, escape=escape) -def contains_op(a, b): - return a.contains(b) +def contains_op(a, b, escape=None): + return a.contains(b, escape=escape) def comma_op(a, b): raise NotImplementedError() -- cgit v1.2.1