Method test_correlated_update_seven

test/sql/test_update.py:363–380

(self)

        )

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

        u = (
            table1.update()
            .values(name=class="st">"foo")
            .where(table2.c.otherid == table1.c.myid)
        )

        class="cm"># this is the class="st">"default_enhanced" compiler.  there's no UPDATE FROM
        class="cm"># in the base compiler.
        class="cm"># See also test/dialect/mssql/test_compiler->test_update_from().
        self.assert_compile(
            u,
            class="st">"UPDATE mytable SET name=:name "
            class="st">"FROM myothertable WHERE myothertable.otherid = mytable.myid",
        )

    def test_binds_that_match_columns(self):
        class="st">"""test bind params named after column names