| 2044 | ) |
| 2045 | |
| 2046 | def test_column_queries_nine(self): |
| 2047 | Address, User = ( |
| 2048 | self.classes.Address, |
| 2049 | self.classes.User, |
| 2050 | ) |
| 2051 | |
| 2052 | sess = fixture_session() |
| 2053 | |
| 2054 | adalias = aliased(Address) |
| 2055 | |
| 2056 | subq = ( |
| 2057 | sess.query(User, adalias.email_address, adalias.id) |
| 2058 | .outerjoin(adalias, User.addresses) |
| 2059 | .subquery() |
| 2060 | ) |
| 2061 | ua = aliased(User, subq) |
| 2062 | aa = aliased(adalias, subq) |
| 2063 | |
| 2064 | q = sess.query(ua, aa.email_address).order_by(ua.id, aa.id) |
| 2065 | # select from aliasing + explicit aliasing |
| 2066 | eq_( |
| 2067 | q.all(), |
| 2068 | [ |
| 2069 | (User(name="jack", id=7), "jack@bean.com"), |
| 2070 | (User(name="ed", id=8), "ed@wood.com"), |
| 2071 | (User(name="ed", id=8), "ed@bettyboop.com"), |
| 2072 | (User(name="ed", id=8), "ed@lala.com"), |
| 2073 | (User(name="fred", id=9), "fred@fred.com"), |
| 2074 | (User(name="chuck", id=10), None), |
| 2075 | ], |
| 2076 | ) |
| 2077 | |
| 2078 | def test_column_queries_ten(self): |
| 2079 | Address, User = ( |