diff options
author | Mike Bayer <mike_mp@zzzcomputing.com> | 2014-07-14 16:31:16 -0400 |
---|---|---|
committer | Mike Bayer <mike_mp@zzzcomputing.com> | 2014-07-14 16:31:16 -0400 |
commit | 5ec6ec9cbb1c29774c50bafed781e649ed481418 (patch) | |
tree | 64ac9342a6cb49f0d99b4eb33f7767af3ba3462a | |
parent | 897a567eb10761df163da182ebe1513e9c6b6558 (diff) | |
download | sqlalchemy-5ec6ec9cbb1c29774c50bafed781e649ed481418.tar.gz |
- add some order bys
-rw-r--r-- | test/orm/test_query.py | 18 |
1 files changed, 15 insertions, 3 deletions
diff --git a/test/orm/test_query.py b/test/orm/test_query.py index b76d1023f..bac39b46b 100644 --- a/test/orm/test_query.py +++ b/test/orm/test_query.py @@ -1420,12 +1420,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): |