(self)
| 49 | run_deletes = None |
| 50 | |
| 51 | def test_basic(self): |
| 52 | users, Address, addresses, User = ( |
| 53 | self.tables.users, |
| 54 | self.classes.Address, |
| 55 | self.tables.addresses, |
| 56 | self.classes.User, |
| 57 | ) |
| 58 | |
| 59 | self.mapper_registry.map_imperatively( |
| 60 | User, |
| 61 | users, |
| 62 | properties={ |
| 63 | "addresses": relationship( |
| 64 | self.mapper_registry.map_imperatively(Address, addresses), |
| 65 | order_by=Address.id, |
| 66 | ) |
| 67 | }, |
| 68 | ) |
| 69 | sess = fixture_session() |
| 70 | |
| 71 | q = sess.query(User).options(subqueryload(User.addresses)) |
| 72 | |
| 73 | def go(): |
| 74 | eq_( |
| 75 | [ |
| 76 | User( |
| 77 | id=7, |
| 78 | addresses=[ |
| 79 | Address(id=1, email_address="jack@bean.com") |
| 80 | ], |
| 81 | ) |
| 82 | ], |
| 83 | q.filter(User.id == 7).all(), |
| 84 | ) |
| 85 | |
| 86 | self.assert_sql_count(testing.db, go, 2) |
| 87 | |
| 88 | def go(): |
| 89 | eq_(self.static.user_address_result, q.order_by(User.id).all()) |
| 90 | |
| 91 | self.assert_sql_count(testing.db, go, 2) |
| 92 | |
| 93 | @testing.combinations(True, False) |
| 94 | def test_from_statement(self, legacy): |
nothing calls this directly
no test coverage detected