diff options
Diffstat (limited to 'test/sql')
| -rw-r--r-- | test/sql/query.py | 14 |
1 files changed, 14 insertions, 0 deletions
diff --git a/test/sql/query.py b/test/sql/query.py index 470d11a29..904303db7 100644 --- a/test/sql/query.py +++ b/test/sql/query.py @@ -273,6 +273,11 @@ class QueryTest(PersistTest): datetable.drop() def test_order_by(self): + """Exercises ORDER BY clause generation. + + Tests simple, compound, aliased and DESC clauses. + """ + users.insert().execute(user_id=1, user_name='c') users.insert().execute(user_id=2, user_name='b') users.insert().execute(user_id=3, user_name='a') @@ -308,6 +313,15 @@ class QueryTest(PersistTest): order_by=[users.c.user_id]), [(1, 1, 'c'), (2, 2, 'b'), (3, 3, 'a')]) + a_eq(users.select(distinct=True, order_by=[desc(users.c.user_id)]), + [(3, 'a'), (2, 'b'), (1, 'c')]) + + a_eq(select([users.c.user_id.label('foo')], + distinct=True, + order_by=[users.c.user_id.desc()]), + [(3,), (2,), (1,)]) + + def test_column_accessor(self): users.insert().execute(user_id=1, user_name='john') users.insert().execute(user_id=2, user_name='jack') |