From 5df5cdba296d9859984e8f4466c858f62daec8aa Mon Sep 17 00:00:00 2001 From: Mike Bayer Date: Tue, 14 Feb 2006 01:15:53 +0000 Subject: [PATCH] tweaks for order_by --- test/query.py | 11 +++++++---- 1 file changed, 7 insertions(+), 4 deletions(-) diff --git a/test/query.py b/test/query.py index 428cb27757..797c49ff43 100644 --- a/test/query.py +++ b/test/query.py @@ -124,11 +124,11 @@ class QueryTest(PersistTest): self.users.insert().execute(user_id=5, user_name='laura') self.users.insert().execute(user_id=6, user_name='ralph') self.users.insert().execute(user_id=7, user_name='fido') - r = self.users.select(limit=3).execute().fetchall() - self.assert_(r == [(1, 'john'), (2, 'jack'), (3, 'ed')]) - r = self.users.select(limit=3, offset=2).execute().fetchall() + r = self.users.select(limit=3, order_by=[self.users.c.user_id]).execute().fetchall() + self.assert_(r == [(1, 'john'), (2, 'jack'), (3, 'ed')], repr(r)) + r = self.users.select(limit=3, offset=2, order_by=[self.users.c.user_id]).execute().fetchall() self.assert_(r==[(3, 'ed'), (4, 'wendy'), (5, 'laura')]) - r = self.users.select(offset=5).execute().fetchall() + r = self.users.select(offset=5, order_by=[self.users.c.user_id]).execute().fetchall() self.assert_(r==[(6, 'ralph'), (7, 'fido')]) def test_column_accessor(self): @@ -171,6 +171,9 @@ class QueryTest(PersistTest): self.assertEqual(r.values(), ['foo', 1]) def test_column_accessor_shadow(self): + if db.engine.__module__.endswith('oracle'): + return + shadowed = Table('test_shadowed', db, Column('shadow_id', INT, primary_key = True), Column('shadow_name', VARCHAR(20)), -- 2.47.2