diff options
Diffstat (limited to 'lib/sqlalchemy/databases/sybase.py')
| -rw-r--r-- | lib/sqlalchemy/databases/sybase.py | 12 |
1 files changed, 12 insertions, 0 deletions
diff --git a/lib/sqlalchemy/databases/sybase.py b/lib/sqlalchemy/databases/sybase.py index 6007315f2..f5b48e147 100644 --- a/lib/sqlalchemy/databases/sybase.py +++ b/lib/sqlalchemy/databases/sybase.py @@ -733,6 +733,14 @@ class SybaseSQLCompiler(compiler.DefaultCompiler): sql_operators.mod: lambda x, y: "MOD(%s, %s)" % (x, y), }) + extract_map = compiler.DefaultCompiler.extract_map.copy() + extract_map.update ({ + 'doy': 'dayofyear', + 'dow': 'weekday', + 'milliseconds': 'millisecond' + }) + + def bindparam_string(self, name): res = super(SybaseSQLCompiler, self).bindparam_string(name) if name.lower().startswith('literal'): @@ -786,6 +794,10 @@ class SybaseSQLCompiler(compiler.DefaultCompiler): res = "CAST(%s AS %s)" % (res, self.process(cast.typeclause)) return res + def visit_extract(self, extract): + field = self.extract_map.get(extract.field, extract.field) + return 'DATEPART("%s", %s)' % (field, self.process(extract.expr)) + def for_update_clause(self, select): # "FOR UPDATE" is only allowed on "DECLARE CURSOR" which SQLAlchemy doesn't use return '' |