diff options
Diffstat (limited to 'test/mapper.py')
-rw-r--r-- | test/mapper.py | 7 |
1 files changed, 4 insertions, 3 deletions
diff --git a/test/mapper.py b/test/mapper.py index 38c168dfe..102c20966 100644 --- a/test/mapper.py +++ b/test/mapper.py @@ -538,7 +538,7 @@ class EagerTest(MapperSuperTest): self.assert_result(l, User, *user_all_result) objectstore.clear() m = mapper(Item, orderitems, is_primary=True, properties = dict( - keywords = relation(mapper(Keyword, keywords), itemkeywords, lazy = False), + keywords = relation(mapper(Keyword, keywords), itemkeywords, lazy = False, order_by=[keywords.c.keyword_id]), )) l = m.select((Item.c.item_name=='item 2') | (Item.c.item_name=='item 5') | (Item.c.item_name=='item 3'), order_by=[Item.c.item_id], limit=2) self.assert_result(l, Item, *[item_keyword_result[1], item_keyword_result[2]]) @@ -617,6 +617,7 @@ class EagerTest(MapperSuperTest): """tests eager loading with two relations simulatneously, from the same table. """ openorders = alias(orders, 'openorders') closedorders = alias(orders, 'closedorders') + ordermapper = mapper(Order, orders) m = mapper(User, users, properties = dict( addresses = relation(mapper(Address, addresses), lazy = False), open_orders = relation(mapper(Order, openorders), primaryjoin = and_(openorders.c.isopen == 1, users.c.user_id==openorders.c.user_id), lazy = False), @@ -659,7 +660,7 @@ class EagerTest(MapperSuperTest): items = orderitems m = mapper(Item, items, properties = dict( - keywords = relation(mapper(Keyword, keywords), itemkeywords, lazy=False), + keywords = relation(mapper(Keyword, keywords), itemkeywords, lazy=False, order_by=[keywords.c.keyword_id]), )) l = m.select() self.assert_result(l, Item, *item_keyword_result) @@ -678,7 +679,7 @@ class EagerTest(MapperSuperTest): m = mapper(Item, items, properties = dict( - keywords = relation(mapper(Keyword, keywords), itemkeywords, lazy = False), + keywords = relation(mapper(Keyword, keywords), itemkeywords, lazy = False, order_by=[keywords.c.keyword_id]), )) m = mapper(Order, orders, properties = dict( |