| 1958 | ) |
| 1959 | |
| 1960 | def test_column_queries_five(self): |
| 1961 | Address, User = ( |
| 1962 | self.classes.Address, |
| 1963 | self.classes.User, |
| 1964 | ) |
| 1965 | |
| 1966 | sess = fixture_session() |
| 1967 | eq_( |
| 1968 | sess.query(User, func.count(Address.email_address)) |
| 1969 | .outerjoin(User.addresses) |
| 1970 | .group_by(User) |
| 1971 | .order_by(User.id) |
| 1972 | .all(), |
| 1973 | [ |
| 1974 | (User(name="jack", id=7), 1), |
| 1975 | (User(name="ed", id=8), 3), |
| 1976 | (User(name="fred", id=9), 1), |
| 1977 | (User(name="chuck", id=10), 0), |
| 1978 | ], |
| 1979 | ) |
| 1980 | |
| 1981 | def test_column_queries_six(self): |
| 1982 | Address, User = ( |