From df929d364d60f239b45ec1b934e7941f0f1c8ef8 Mon Sep 17 00:00:00 2001 From: Jason Kirtland Date: Fri, 12 Oct 2007 17:46:42 +0000 Subject: [PATCH] - Added small DESC exercise to test_order_by. --- test/sql/query.py | 14 ++++++++++++++ 1 file changed, 14 insertions(+) diff --git a/test/sql/query.py b/test/sql/query.py index 470d11a299..904303db78 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') -- 2.47.3