summaryrefslogtreecommitdiff
path: root/test/mapper.py
diff options
context:
space:
mode:
Diffstat (limited to 'test/mapper.py')
-rw-r--r--test/mapper.py7
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(