diff options
| author | Spitcyn <a.ch.clr@gmail.com> | 2017-09-12 10:21:57 -0400 |
|---|---|---|
| committer | Mike Bayer <mike_mp@zzzcomputing.com> | 2017-09-12 10:21:57 -0400 |
| commit | 52c0a9179c993b69e5cec157fb03100d4562c7a4 (patch) | |
| tree | 41d341b27b5a99a382370b0d6b41d7464150d99c /test/sql | |
| parent | 31f80b9eaeb3c3435b7f6679b41e434478b1d11c (diff) | |
| download | sqlalchemy-pr_github_383.tar.gz | |
Support for GROUP BY CUBE, SET, ROLLUPpr_github_383
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
Diffstat (limited to 'test/sql')
| -rw-r--r-- | test/sql/test_functions.py | 10 |
1 files changed, 10 insertions, 0 deletions
diff --git a/test/sql/test_functions.py b/test/sql/test_functions.py index 272bd876e..4d43385f6 100644 --- a/test/sql/test_functions.py +++ b/test/sql/test_functions.py @@ -86,6 +86,16 @@ class CompileTest(fixtures.TestBase, AssertsCompiledSQL): ]: self.assert_compile(func.random(), ret, dialect=dialect) + def test_grouping_set(self): + for clause, compiled, checkparams in [ + (func.grouping_sets('col_1'), 'GROUPING SETS(:grouping_sets_1)', {'grouping_sets_1': 'col_1'}), + (func.grouping_sets('col_1', 'col_2'), 'GROUPING SETS(:grouping_sets_1, :grouping_sets_2)', {'grouping_sets_1': 'col_1', 'grouping_sets_2': 'col_2'}), + (func.grouping_sets('col_1', ()), 'GROUPING SETS(:grouping_sets_1, :grouping_sets_2)', {'grouping_sets_1': 'col_1', 'grouping_sets_2': ()}), + (func.grouping_sets('col_1', ('col_2', 'col_3')), 'GROUPING SETS(:grouping_sets_1, :grouping_sets_2)', {'grouping_sets_1': 'col_1', 'grouping_sets_2': ('col_2', 'col_3')}), + (func.grouping_sets('col_1', ('col_2', 'col_3'), ()), 'GROUPING SETS(:grouping_sets_1, :grouping_sets_2, :grouping_sets_3)', {'grouping_sets_1': 'col_1', 'grouping_sets_2': ('col_2', 'col_3'), 'grouping_sets_3': ()}), + ]: + self.assert_compile(clause, compiled, checkparams=checkparams) + def test_generic_annotation(self): fn = func.coalesce('x', 'y')._annotate({"foo": "bar"}) self.assert_compile( |