diff options
| author | Ilja Everilä <saarni@gmail.com> | 2014-09-10 11:34:33 +0300 |
|---|---|---|
| committer | Ilja Everilä <saarni@gmail.com> | 2014-09-10 11:34:33 +0300 |
| commit | ad82849bbe4ef329129204d02781f737c0c79fcb (patch) | |
| tree | 58bb07abaada3c96277933520fefd973c365a103 /lib/sqlalchemy/sql/compiler.py | |
| parent | a23264e1dc43b1250b9b5de541ff27bd49a2b2c1 (diff) | |
| download | sqlalchemy-ad82849bbe4ef329129204d02781f737c0c79fcb.tar.gz | |
implementation for <aggregate_fun> FILTER (WHERE ...)
Diffstat (limited to 'lib/sqlalchemy/sql/compiler.py')
| -rw-r--r-- | lib/sqlalchemy/sql/compiler.py | 6 |
1 files changed, 6 insertions, 0 deletions
diff --git a/lib/sqlalchemy/sql/compiler.py b/lib/sqlalchemy/sql/compiler.py index 5149fa4fe..6ebd61e9c 100644 --- a/lib/sqlalchemy/sql/compiler.py +++ b/lib/sqlalchemy/sql/compiler.py @@ -760,6 +760,12 @@ class SQLCompiler(Compiled): ) ) + def visit_aggregatefilter(self, aggregatefilter, **kwargs): + return "%s FILTER (WHERE %s)" % ( + aggregatefilter.func._compiler_dispatch(self, **kwargs), + aggregatefilter.criterion._compiler_dispatch(self, **kwargs) + ) + def visit_extract(self, extract, **kwargs): field = self.extract_map.get(extract.field, extract.field) return "EXTRACT(%s FROM %s)" % ( |