| 2619 | ) |
| 2620 | |
| 2621 | def test_reduce_selectable(self): |
| 2622 | metadata = MetaData() |
| 2623 | engineers = Table( |
| 2624 | "engineers", |
| 2625 | metadata, |
| 2626 | Column("engineer_id", Integer, primary_key=True), |
| 2627 | Column("engineer_name", String(50)), |
| 2628 | ) |
| 2629 | managers = Table( |
| 2630 | "managers", |
| 2631 | metadata, |
| 2632 | Column("manager_id", Integer, primary_key=True), |
| 2633 | Column("manager_name", String(50)), |
| 2634 | ) |
| 2635 | s = ( |
| 2636 | select(engineers, managers) |
| 2637 | .where(engineers.c.engineer_name == managers.c.manager_name) |
| 2638 | .subquery() |
| 2639 | ) |
| 2640 | eq_( |
| 2641 | util.column_set(sql_util.reduce_columns(list(s.c), s)), |
| 2642 | util.column_set( |
| 2643 | [s.c.engineer_id, s.c.engineer_name, s.c.manager_id] |
| 2644 | ), |
| 2645 | ) |
| 2646 | |
| 2647 | def test_reduce_generation(self): |
| 2648 | m = MetaData() |