Method test_update_no_params

test/sql/test_update.py:129–178

test issue identified while doing #9721 UPDATE with empty VALUES but multiple tables would raise a NoneType error; fixed this to emit an empty "SET" the way a single table UPDATE currently does. both cases should probably raise CompileError, however this could

(self, values, twotable)

    @testing.variation(class="st">"twotable", [True, False])
    @testing.variation(class="st">"values", [class="st">"none", class="st">"blank"])
    def test_update_no_params(self, values, twotable):
        class="st">"""test issue identified while doing class="cm">#9721

        UPDATE with empty VALUES but multiple tables would raise a
        NoneType error; fixed this to emit an empty class="st">"SET" the way a single
        table UPDATE currently does.

        both cases should probably raise CompileError, however this could
        be backwards incompatible with current use cases (such as other test
        suites)

        class="st">"""

        table1 = self.tables.mytable
        table2 = self.tables.myothertable

        stmt = table1.update().where(table1.c.name == class="st">"jill")
        if twotable:
            stmt = stmt.where(table2.c.otherid == table1.c.myid)

        if values.blank:
            stmt = stmt.values()

        if twotable:
            if values.blank:
                self.assert_compile(
                    stmt,
                    class="st">"UPDATE mytable SET  FROM myothertable "
                    class="st">"WHERE mytable.name = :name_1 "
                    class="st">"AND myothertable.otherid = mytable.myid",
                )
            elif values.none:
                self.assert_compile(
                    stmt,
                    class="st">"UPDATE mytable SET myid=:myid, name=:name, "
                    class="st">"description=:description FROM myothertable "
                    class="st">"WHERE mytable.name = :name_1 "
                    class="st">"AND myothertable.otherid = mytable.myid",
                )
        elif values.blank:
            self.assert_compile(
                stmt,
                class="st">"UPDATE mytable SET  WHERE mytable.name = :name_1",
            )
        elif values.none:
            self.assert_compile(
                stmt,
                class="st">"UPDATE mytable SET myid=:myid, name=:name, "
                class="st">"description=:description WHERE mytable.name = :name_1",
            )

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