diff options
| author | Mike Bayer <mike_mp@zzzcomputing.com> | 2011-02-10 21:57:44 -0500 |
|---|---|---|
| committer | Mike Bayer <mike_mp@zzzcomputing.com> | 2011-02-10 21:57:44 -0500 |
| commit | 020d6ef8f017d4411b403c18d93f913d6b01fd62 (patch) | |
| tree | 15cb1d36599dcadc5cac2c7d857d44d006c346c5 /test/sql/test_query.py | |
| parent | ad8700a556d3ec9368dd80238dfddf456eeccd5f (diff) | |
| download | sqlalchemy-020d6ef8f017d4411b403c18d93f913d6b01fd62.tar.gz | |
- Added over() function, method to FunctionElement
classes, produces the _Over() construct which
in turn generates "window functions", i.e.
"<window function> OVER (PARTITION BY <partition by>,
ORDER BY <order by>)".
[ticket:1844]
Diffstat (limited to 'test/sql/test_query.py')
| -rw-r--r-- | test/sql/test_query.py | 9 |
1 files changed, 9 insertions, 0 deletions
diff --git a/test/sql/test_query.py b/test/sql/test_query.py index 359084cd8..1adb00aea 100644 --- a/test/sql/test_query.py +++ b/test/sql/test_query.py @@ -1764,5 +1764,14 @@ class OperatorTest(TestBase): [(2,),(1,)] ) + @testing.requires.window_functions + def test_over(self): + eq_( + select([ + flds.c.intcol, func.row_number().over(order_by=flds.c.strcol) + ]).execute().fetchall(), + [(13, 1L), (5, 2L)] + ) + |