| 1979 | ) |
| 1980 | |
| 1981 | def test_column_queries_six(self): |
| 1982 | Address, User = ( |
| 1983 | self.classes.Address, |
| 1984 | self.classes.User, |
| 1985 | ) |
| 1986 | |
| 1987 | sess = fixture_session() |
| 1988 | eq_( |
| 1989 | sess.query(func.count(Address.email_address), User) |
| 1990 | .outerjoin(User.addresses) |
| 1991 | .group_by(User) |
| 1992 | .order_by(User.id) |
| 1993 | .all(), |
| 1994 | [ |
| 1995 | (1, User(name="jack", id=7)), |
| 1996 | (3, User(name="ed", id=8)), |
| 1997 | (1, User(name="fred", id=9)), |
| 1998 | (0, User(name="chuck", id=10)), |
| 1999 | ], |
| 2000 | ) |
| 2001 | |
| 2002 | def test_column_queries_seven(self): |
| 2003 | Address, User = ( |