From 8be54fe1de23e983de97dcfaf43c173704bb6fa4 Mon Sep 17 00:00:00 2001 From: Mike Bayer Date: Mon, 14 Jul 2014 16:31:16 -0400 Subject: [PATCH] - add some order bys --- test/orm/test_query.py | 18 +++++++++++++++--- 1 file changed, 15 insertions(+), 3 deletions(-) diff --git a/test/orm/test_query.py b/test/orm/test_query.py index e49dd22e0a..c58a3ffabf 100644 --- a/test/orm/test_query.py +++ b/test/orm/test_query.py @@ -1376,12 +1376,24 @@ class FilterTest(QueryTest, AssertsCompiledSQL): sess = create_session() item = sess.query(Item).get(3) - assert [Order(id=1), Order(id=2), Order(id=3)] == sess.query(Order).filter(Order.items.contains(item)).all() - assert [Order(id=4), Order(id=5)] == sess.query(Order).filter(~Order.items.contains(item)).all() + eq_( + sess.query(Order).filter(Order.items.contains(item)). + order_by(Order.id).all(), + [Order(id=1), Order(id=2), Order(id=3)] + ) + eq_( + sess.query(Order).filter(~Order.items.contains(item)). + order_by(Order.id).all(), + [Order(id=4), Order(id=5)] + ) item2 = sess.query(Item).get(5) - assert [Order(id=3)] == sess.query(Order).filter(Order.items.contains(item)).filter(Order.items.contains(item2)).all() + eq_( + sess.query(Order).filter(Order.items.contains(item)). + filter(Order.items.contains(item2)).all(), + [Order(id=3)] + ) def test_comparison(self): -- 2.47.3