| 2076 | ) |
| 2077 | |
| 2078 | def test_column_queries_ten(self): |
| 2079 | Address, User = ( |
| 2080 | self.classes.Address, |
| 2081 | self.classes.User, |
| 2082 | ) |
| 2083 | |
| 2084 | sess = fixture_session() |
| 2085 | |
| 2086 | # anon + select from aliasing |
| 2087 | aa = aliased(Address) |
| 2088 | |
| 2089 | subq = ( |
| 2090 | sess.query(User) |
| 2091 | .join(aa, User.addresses) |
| 2092 | .filter(aa.email_address.like("%ed%")) |
| 2093 | .subquery() |
| 2094 | ) |
| 2095 | ua = aliased(User, subq) |
| 2096 | |
| 2097 | eq_( |
| 2098 | sess.query(ua).all(), |
| 2099 | [User(name="ed", id=8), User(name="fred", id=9)], |
| 2100 | ) |
| 2101 | |
| 2102 | def test_column_queries_eleven(self): |
| 2103 | Address, User = ( |