From 4960e4947ca7080d062e86b301c714718f5da88a Mon Sep 17 00:00:00 2001 From: Mike Bayer Date: Wed, 28 Mar 2007 23:38:28 +0000 Subject: [PATCH] ordering adjustments --- test/orm/mapper.py | 6 +++--- 1 file changed, 3 insertions(+), 3 deletions(-) diff --git a/test/orm/mapper.py b/test/orm/mapper.py index 942fdfdd9e..6f80df38f5 100644 --- a/test/orm/mapper.py +++ b/test/orm/mapper.py @@ -1458,17 +1458,17 @@ class InstancesTest(MapperSuperTest): sess = create_session() (user7, user8, user9) = sess.query(User).select() q = sess.query(User) - q = q.group_by([c for c in users.c]).outerjoin('addresses').add_column(func.count(addresses.c.address_id).label('count')) + q = q.group_by([c for c in users.c]).order_by(User.c.user_id).outerjoin('addresses').add_column(func.count(addresses.c.address_id).label('count')) l = q.list() assert l == [ (user7, 1), (user8, 3), (user9, 0) - ] + ], repr(l) def testmapperspluscolumn(self): mapper(User, users) - s = select([users, func.count(addresses.c.address_id).label('count')], from_obj=[users.outerjoin(addresses)], group_by=[c for c in users.c]) + s = select([users, func.count(addresses.c.address_id).label('count')], from_obj=[users.outerjoin(addresses)], group_by=[c for c in users.c], order_by=[users.c.user_id]) sess = create_session() (user7, user8, user9) = sess.query(User).select() q = sess.query(User) -- 2.47.2