| 2601 | ) |
| 2602 | |
| 2603 | def test_reduce_selectable(self): |
| 2604 | metadata = MetaData() |
| 2605 | engineers = Table( |
| 2606 | "engineers", |
| 2607 | metadata, |
| 2608 | Column("engineer_id", Integer, primary_key=True), |
| 2609 | Column("engineer_name", String(50)), |
| 2610 | ) |
| 2611 | managers = Table( |
| 2612 | "managers", |
| 2613 | metadata, |
| 2614 | Column("manager_id", Integer, primary_key=True), |
| 2615 | Column("manager_name", String(50)), |
| 2616 | ) |
| 2617 | s = ( |
| 2618 | select(engineers, managers) |
| 2619 | .where(engineers.c.engineer_name == managers.c.manager_name) |
| 2620 | .subquery() |
| 2621 | ) |
| 2622 | eq_( |
| 2623 | util.column_set(sql_util.reduce_columns(list(s.c), s)), |
| 2624 | util.column_set( |
| 2625 | [s.c.engineer_id, s.c.engineer_name, s.c.manager_id] |
| 2626 | ), |
| 2627 | ) |
| 2628 | |
| 2629 | def test_reduce_generation(self): |
| 2630 | m = MetaData() |