diff options
| author | Mike Bayer <mike_mp@zzzcomputing.com> | 2005-12-31 07:49:33 +0000 |
|---|---|---|
| committer | Mike Bayer <mike_mp@zzzcomputing.com> | 2005-12-31 07:49:33 +0000 |
| commit | da8595e84d6666c13bf1494598dcb4d6af12b882 (patch) | |
| tree | da88ce2a8c81751412f39c344a3eaf8bf0d93021 /lib/sqlalchemy/databases/sqlite.py | |
| parent | 3b6f23145f1efb0a152f3a25fbaf4c5890b7dc76 (diff) | |
| download | sqlalchemy-da8595e84d6666c13bf1494598dcb4d6af12b882.tar.gz | |
added a hook in for 'binary operator', so sqlite can exchange
'+' for '||' for a binary clause on a string
Diffstat (limited to 'lib/sqlalchemy/databases/sqlite.py')
| -rw-r--r-- | lib/sqlalchemy/databases/sqlite.py | 6 |
1 files changed, 5 insertions, 1 deletions
diff --git a/lib/sqlalchemy/databases/sqlite.py b/lib/sqlalchemy/databases/sqlite.py index 26cc3cf05..0288beae8 100644 --- a/lib/sqlalchemy/databases/sqlite.py +++ b/lib/sqlalchemy/databases/sqlite.py @@ -185,7 +185,11 @@ class SQLiteCompiler(ansisql.ANSICompiler): text += " \n LIMIT -1" text += " OFFSET " + str(select.offset) return text - + def binary_operator_string(self, binary): + if isinstance(binary.type, sqltypes.String) and binary.operator == '+': + return '||' + else: + return ansisql.ANSICompiler.binary_operator_string(self, binary) class SQLiteSchemaGenerator(ansisql.ANSISchemaGenerator): def get_column_specification(self, column, override_pk=False, **kwargs): |