Method test_correlated_update_five

test/sql/test_update.py:332–345

(self)

        )

    def test_correlated_update_five(self):
        table1 = self.tables.mytable
        table2 = self.tables.myothertable

        class="cm"># test one that is actually correlated...
        s = select(table2.c.othername).where(table2.c.otherid == table1.c.myid)
        u = table1.update().where(table1.c.name == s.scalar_subquery())
        self.assert_compile(
            u,
            class="st">"UPDATE mytable SET myid=:myid, name=:name, "
            class="st">"description=:description WHERE mytable.name = "
            class="st">"(SELECT myothertable.othername FROM myothertable "
            class="st">"WHERE myothertable.otherid = mytable.myid)",
        )

    def test_correlated_update_six(self):
        table1 = self.tables.mytable