From 52c0a9179c993b69e5cec157fb03100d4562c7a4 Mon Sep 17 00:00:00 2001 From: Spitcyn Date: Tue, 12 Sep 2017 10:21:57 -0400 Subject: Support for GROUP BY CUBE, SET, ROLLUP https://bitbucket.org/zzzeek/sqlalchemy/issues/3429/support-for-group-by-cube-set-rollup - new funcs added - fix type into sql.elements Change-Id: I870ee7dc801d553c5309c291402ec468b671e9a9 Pull-request: https://github.com/zzzeek/sqlalchemy/pull/383 --- lib/sqlalchemy/sql/compiler.py | 5 ++++- 1 file changed, 4 insertions(+), 1 deletion(-) (limited to 'lib/sqlalchemy/sql/compiler.py') diff --git a/lib/sqlalchemy/sql/compiler.py b/lib/sqlalchemy/sql/compiler.py index 2dec3a5c3..b0f0807d6 100644 --- a/lib/sqlalchemy/sql/compiler.py +++ b/lib/sqlalchemy/sql/compiler.py @@ -121,7 +121,10 @@ FUNCTIONS = { functions.random: 'random%(expr)s', functions.sysdate: 'sysdate', functions.session_user: 'SESSION_USER', - functions.user: 'USER' + functions.user: 'USER', + functions.cube: 'CUBE%(expr)s', + functions.rollup: 'ROLLUP%(expr)s', + functions.grouping_sets: 'GROUPING SETS%(expr)s', } EXTRACT_MAP = { -- cgit v1.2.1