(self)
| 2933 | __dialect__ = "default" |
| 2934 | |
| 2935 | def test_replace_with_select(self): |
| 2936 | users, Address, addresses, User = ( |
| 2937 | self.tables.users, |
| 2938 | self.classes.Address, |
| 2939 | self.tables.addresses, |
| 2940 | self.classes.User, |
| 2941 | ) |
| 2942 | |
| 2943 | self.mapper_registry.map_imperatively( |
| 2944 | User, users, properties={"addresses": relationship(Address)} |
| 2945 | ) |
| 2946 | self.mapper_registry.map_imperatively(Address, addresses) |
| 2947 | |
| 2948 | sel = users.select().where(users.c.id.in_([7, 8])).alias() |
| 2949 | sess = fixture_session() |
| 2950 | |
| 2951 | ua = aliased(User, sel) |
| 2952 | eq_( |
| 2953 | sess.query(ua).all(), |
| 2954 | [User(id=7), User(id=8)], |
| 2955 | ) |
| 2956 | |
| 2957 | eq_( |
| 2958 | sess.query(ua).filter(ua.id == 8).all(), |
| 2959 | [User(id=8)], |
| 2960 | ) |
| 2961 | |
| 2962 | eq_( |
| 2963 | sess.query(ua).order_by(desc(ua.name)).all(), |
| 2964 | [User(name="jack", id=7), User(name="ed", id=8)], |
| 2965 | ) |
| 2966 | |
| 2967 | eq_( |
| 2968 | sess.query(ua).order_by(asc(ua.name)).all(), |
| 2969 | [User(name="ed", id=8), User(name="jack", id=7)], |
| 2970 | ) |
| 2971 | |
| 2972 | eq_( |
| 2973 | sess.query(ua).options(joinedload(ua.addresses)).first(), |
| 2974 | User(name="jack", addresses=[Address(id=1)]), |
| 2975 | ) |
| 2976 | |
| 2977 | def test_select_from_aliased_one(self): |
| 2978 | User, users = self.classes.User, self.tables.users |
nothing calls this directly
no test coverage detected