From 52c0a9179c993b69e5cec157fb03100d4562c7a4 Mon Sep 17 00:00:00 2001
From: Spitcyn <a.ch.clr@gmail.com>
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 ++++-
 lib/sqlalchemy/sql/elements.py  |  2 +-
 lib/sqlalchemy/sql/functions.py | 30 ++++++++++++++++++++++++++++++
 3 files changed, 35 insertions(+), 2 deletions(-)

(limited to 'lib/sqlalchemy')

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 = {
diff --git a/lib/sqlalchemy/sql/elements.py b/lib/sqlalchemy/sql/elements.py
index 36a6a6557..9213d616c 100644
--- a/lib/sqlalchemy/sql/elements.py
+++ b/lib/sqlalchemy/sql/elements.py
@@ -3293,7 +3293,7 @@ class WithinGroup(ColumnElement):
     """Represent a WITHIN GROUP (ORDER BY) clause.
 
     This is a special operator against so-called
-    so-called "ordered set aggregate" and "hypothetical
+    "ordered set aggregate" and "hypothetical
     set aggregate" functions, including ``percentile_cont()``,
     ``rank()``, ``dense_rank()``, etc.
 
diff --git a/lib/sqlalchemy/sql/functions.py b/lib/sqlalchemy/sql/functions.py
index 08f1d32a5..ef041eac7 100644
--- a/lib/sqlalchemy/sql/functions.py
+++ b/lib/sqlalchemy/sql/functions.py
@@ -811,3 +811,33 @@ class cume_dist(GenericFunction):
 
     """
     type = sqltypes.Numeric()
+
+
+class cube(GenericFunction):
+    r"""Implement the ``CUBE`` grouping operation.
+
+    This function must be used as argument of :func:`Query.group_by`:
+
+        stmt = select([func.sum(table.c.value), table.c.col_1, table.c.col_2]).\
+               group_by(func.cube(table.c.col_1, table.c.col_2))
+    """
+
+
+class rollup(GenericFunction):
+    r"""Implement the ``ROLLUP`` grouping operation.
+
+    This function must be used as argument of :func:`Query.group_by`:
+
+        stmt = select([func.sum(table.c.value), table.c.col_1, table.c.col_2]).\
+               group_by(func.rollup(table.c.col_1, table.c.col_2))
+    """
+
+
+class grouping_sets(GenericFunction):
+    r"""Implement the ``GROUPING SETS`` grouping operation.
+
+    This function must be used as argument of :func:`Query.group_by`:
+
+        stmt = select([func.sum(table.c.value), table.c.col_1, table.c.col_2]).\
+               group_by(func.grouping_sets(table.c.col_1, table.c.col_2))
+    """
-- 
cgit v1.2.1