| 1768 | eq_(stmt.compile().isdelete, True) |
| 1769 | |
| 1770 | def test_select_uses_independent_cte(self): |
| 1771 | products = table("products", column("id"), column("price")) |
| 1772 | |
| 1773 | upd_cte = ( |
| 1774 | products.update().values(price=10).where(products.c.price > 50) |
| 1775 | ).cte() |
| 1776 | |
| 1777 | stmt = products.select().where(products.c.price < 45).add_cte(upd_cte) |
| 1778 | |
| 1779 | self.assert_compile( |
| 1780 | stmt, |
| 1781 | "WITH anon_1 AS (UPDATE products SET price=:param_1 " |
| 1782 | "WHERE products.price > :price_1) " |
| 1783 | "SELECT products.id, products.price " |
| 1784 | "FROM products WHERE products.price < :price_2", |
| 1785 | checkparams={"param_1": 10, "price_1": 50, "price_2": 45}, |
| 1786 | ) |
| 1787 | |
| 1788 | def test_compound_select_uses_independent_cte(self): |
| 1789 | products = table("products", column("id"), column("price")) |