diff options
| author | Michael Trier <mtrier@gmail.com> | 2008-07-13 04:45:37 +0000 |
|---|---|---|
| committer | Michael Trier <mtrier@gmail.com> | 2008-07-13 04:45:37 +0000 |
| commit | f899157ca9f6f5104a358420eba8f1b9019ece6f (patch) | |
| tree | 37baa09bec04f9c1f93fa4ea4a798158cc3c75e1 /lib/sqlalchemy/sql/compiler.py | |
| parent | bad78d9767fb9b076c7a6388286a0c37a81d8bc5 (diff) | |
| download | sqlalchemy-f899157ca9f6f5104a358420eba8f1b9019ece6f.tar.gz | |
Added new basic match() operator that performs a full-text search. Supported on PostgreSQL, SQLite, MySQL, MS-SQL, and Oracle backends.
Diffstat (limited to 'lib/sqlalchemy/sql/compiler.py')
| -rw-r--r-- | lib/sqlalchemy/sql/compiler.py | 1 |
1 files changed, 1 insertions, 0 deletions
diff --git a/lib/sqlalchemy/sql/compiler.py b/lib/sqlalchemy/sql/compiler.py index b6da29736..05b3f550d 100644 --- a/lib/sqlalchemy/sql/compiler.py +++ b/lib/sqlalchemy/sql/compiler.py @@ -81,6 +81,7 @@ OPERATORS = { operators.ilike_op : lambda x, y, escape=None: "lower(%s) LIKE lower(%s)" % (x, y) + (escape and ' ESCAPE \'%s\'' % escape or ''), operators.notilike_op : lambda x, y, escape=None: "lower(%s) NOT LIKE lower(%s)" % (x, y) + (escape and ' ESCAPE \'%s\'' % escape or ''), operators.between_op : 'BETWEEN', + operators.match_op : 'MATCH', operators.in_op : 'IN', operators.notin_op : 'NOT IN', operators.comma_op : ', ', |