MCPcopy
hub / github.com/sqlalchemy/sqlalchemy / test_double_w_ac

Method test_double_w_ac

test/orm/test_subquery_relations.py:1054–1125  ·  view source on GitHub ↗
(self)

Source from the content-addressed store, hash-verified

1052 self._run_double_test()
1053
1054 def test_double_w_ac(self):
1055 (
1056 users,
1057 orders,
1058 User,
1059 Address,
1060 Order,
1061 addresses,
1062 Item,
1063 items,
1064 order_items,
1065 ) = (
1066 self.tables.users,
1067 self.tables.orders,
1068 self.classes.User,
1069 self.classes.Address,
1070 self.classes.Order,
1071 self.tables.addresses,
1072 self.classes.Item,
1073 self.tables.items,
1074 self.tables.order_items,
1075 )
1076
1077 self.mapper_registry.map_imperatively(Address, addresses)
1078 self.mapper_registry.map_imperatively(
1079 Order,
1080 orders,
1081 properties={
1082 "items": relationship(
1083 Item,
1084 secondary=order_items,
1085 lazy="subquery",
1086 order_by=items.c.id,
1087 )
1088 },
1089 )
1090 self.mapper_registry.map_imperatively(Item, items)
1091
1092 open_mapper = aliased(Order, orders)
1093 closed_mapper = aliased(Order, orders)
1094
1095 self.mapper_registry.map_imperatively(
1096 User,
1097 users,
1098 properties=dict(
1099 addresses=relationship(
1100 Address, lazy="subquery", order_by=addresses.c.id
1101 ),
1102 open_orders=relationship(
1103 open_mapper,
1104 primaryjoin=sa.and_(
1105 open_mapper.isopen == 1,
1106 users.c.id == open_mapper.user_id,
1107 ),
1108 lazy="subquery",
1109 order_by=open_mapper.id,
1110 overlaps="closed_orders",
1111 ),

Callers

nothing calls this directly

Calls 5

_run_double_testMethod · 0.95
relationshipFunction · 0.90
aliasedFunction · 0.90
map_imperativelyMethod · 0.80
and_Method · 0.45

Tested by

no test coverage detected