From a0ef9edc1908adb823ec788eee1974900bca4bac Mon Sep 17 00:00:00 2001 From: Mike Bayer Date: Wed, 6 Feb 2013 19:06:09 -0500 Subject: - adding in requirements - get test_naturalpks to be more generalized --- test/orm/test_query.py | 23 +++++++++++++++-------- 1 file changed, 15 insertions(+), 8 deletions(-) (limited to 'test/orm/test_query.py') diff --git a/test/orm/test_query.py b/test/orm/test_query.py index 9aad19579..05a13c3c1 100644 --- a/test/orm/test_query.py +++ b/test/orm/test_query.py @@ -1099,20 +1099,27 @@ class FilterTest(QueryTest, AssertsCompiledSQL): def test_basic(self): User = self.classes.User - assert [User(id=7), User(id=8), User(id=9),User(id=10)] == create_session().query(User).all() + users = create_session().query(User).all() + eq_( + [User(id=7), User(id=8), User(id=9),User(id=10)], + users + ) - @testing.fails_on('maxdb', 'FIXME: unknown') - def test_limit(self): + @testing.requires.offset + def test_limit_offset(self): User = self.classes.User - assert [User(id=8), User(id=9)] == create_session().query(User).order_by(User.id).limit(2).offset(1).all() + sess = create_session() + + assert [User(id=8), User(id=9)] == sess.query(User).order_by(User.id).limit(2).offset(1).all() + + assert [User(id=8), User(id=9)] == list(sess.query(User).order_by(User.id)[1:3]) - assert [User(id=8), User(id=9)] == list(create_session().query(User).order_by(User.id)[1:3]) + assert User(id=8) == sess.query(User).order_by(User.id)[1] - assert User(id=8) == create_session().query(User).order_by(User.id)[1] + assert [] == sess.query(User).order_by(User.id)[3:3] + assert [] == sess.query(User).order_by(User.id)[0:0] - assert [] == create_session().query(User).order_by(User.id)[3:3] - assert [] == create_session().query(User).order_by(User.id)[0:0] @testing.requires.boolean_col_expressions def test_exists(self): -- cgit v1.2.1