| 1654 | assert [User(id=7, name="jack")] == result |
| 1655 | |
| 1656 | def test_aliased_order_by(self): |
| 1657 | User = self.classes.User |
| 1658 | |
| 1659 | sess = fixture_session() |
| 1660 | |
| 1661 | ualias = aliased(User) |
| 1662 | eq_( |
| 1663 | sess.query(User, ualias) |
| 1664 | .filter(User.id > ualias.id) |
| 1665 | .order_by(desc(ualias.id), User.name) |
| 1666 | .all(), |
| 1667 | [ |
| 1668 | (User(id=10, name="chuck"), User(id=9, name="fred")), |
| 1669 | (User(id=10, name="chuck"), User(id=8, name="ed")), |
| 1670 | (User(id=9, name="fred"), User(id=8, name="ed")), |
| 1671 | (User(id=10, name="chuck"), User(id=7, name="jack")), |
| 1672 | (User(id=8, name="ed"), User(id=7, name="jack")), |
| 1673 | (User(id=9, name="fred"), User(id=7, name="jack")), |
| 1674 | ], |
| 1675 | ) |
| 1676 | |
| 1677 | def test_plain_table(self): |
| 1678 | addresses, User = self.tables.addresses, self.classes.User |