| 752 | sess.close() |
| 753 | |
| 754 | def test_to_query_query(self): |
| 755 | User = self.classes.User |
| 756 | Address = self.classes.Address |
| 757 | |
| 758 | sub_bq = self.bakery(lambda s: s.query(User.name)) |
| 759 | sub_bq += ( |
| 760 | lambda q: q.filter(User.id == Address.user_id) |
| 761 | .filter(User.name == "ed") |
| 762 | .correlate(Address) |
| 763 | ) |
| 764 | |
| 765 | main_bq = self.bakery(lambda s: s.query(Address.id)) |
| 766 | main_bq += lambda q: q.filter(sub_bq.to_query(q).exists()) |
| 767 | main_bq += lambda q: q.order_by(Address.id) |
| 768 | |
| 769 | sess = fixture_session() |
| 770 | result = main_bq(sess).all() |
| 771 | eq_(result, [(2,), (3,), (4,)]) |
| 772 | |
| 773 | def test_to_query_session(self): |
| 774 | User = self.classes.User |