From dbd566b6c1de1f084d336a958d58146df32c1916 Mon Sep 17 00:00:00 2001 From: Mike Bayer Date: Wed, 18 Jul 2007 19:37:10 +0000 Subject: [PATCH] added some aggregate tests --- test/orm/query.py | 10 ++++++++++ 1 file changed, 10 insertions(+) diff --git a/test/orm/query.py b/test/orm/query.py index 373150ef51..6956685c1f 100644 --- a/test/orm/query.py +++ b/test/orm/query.py @@ -226,7 +226,17 @@ class FilterTest(QueryTest): assert [Address(id=1), Address(id=5)] == sess.query(Address).filter(Address.user!=user).all() +class AggregateTest(QueryTest): + def test_sum(self): + sess = create_session() + orders = sess.query(Order).filter(Order.id.in_(2, 3, 4)) + assert orders.sum(Order.user_id * Order.address_id) == 79 + + def test_apply(self): + sess = create_session() + assert sess.query(Order).apply_sum(Order.user_id * Order.address_id).filter(Order.id.in_(2, 3, 4)).one() == 79 + class CountTest(QueryTest): def test_basic(self): assert 4 == create_session().query(User).count() -- 2.47.3