summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorMike Bayer <mike_mp@zzzcomputing.com>2014-07-14 16:31:16 -0400
committerMike Bayer <mike_mp@zzzcomputing.com>2014-07-14 16:31:16 -0400
commit5ec6ec9cbb1c29774c50bafed781e649ed481418 (patch)
tree64ac9342a6cb49f0d99b4eb33f7767af3ba3462a
parent897a567eb10761df163da182ebe1513e9c6b6558 (diff)
downloadsqlalchemy-5ec6ec9cbb1c29774c50bafed781e649ed481418.tar.gz
- add some order bys
-rw-r--r--test/orm/test_query.py18
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):