Method test_binds_that_match_columns

test/sql/test_update.py:382–424

test bind params named after column names replace the normal SET/VALUES generation. See also test_compiler.py::CrudParamOverlapTest

(self)

        )

    def test_binds_that_match_columns(self):
        class="st">"""test bind params named after column names
        replace the normal SET/VALUES generation.

        See also test_compiler.py::CrudParamOverlapTest

        class="st">"""

        t = table(class="st">"foo", column(class="st">"x"), column(class="st">"y"))

        u = t.update().where(t.c.x == bindparam(class="st">"x"))

        assert_raises(exc.CompileError, u.compile)

        self.assert_compile(u, class="st">"UPDATE foo SET  WHERE foo.x = :x", params={})

        assert_raises(exc.CompileError, u.values(x=7).compile)

        self.assert_compile(
            u.values(y=7), class="st">"UPDATE foo SET y=:y WHERE foo.x = :x"
        )

        assert_raises(
            exc.CompileError, u.values(x=7).compile, column_keys=[class="st">"x", class="st">"y"]
        )
        assert_raises(exc.CompileError, u.compile, column_keys=[class="st">"x", class="st">"y"])

        self.assert_compile(
            u.values(x=3 + bindparam(class="st">"x")),
            class="st">"UPDATE foo SET x=(:param_1 + :x) WHERE foo.x = :x",
        )

        self.assert_compile(
            u.values(x=3 + bindparam(class="st">"x")),
            class="st">"UPDATE foo SET x=(:param_1 + :x) WHERE foo.x = :x",
            params={class="st">"x": 1},
        )

        self.assert_compile(
            u.values(x=3 + bindparam(class="st">"x")),
            class="st">"UPDATE foo SET x=(:param_1 + :x), y=:y WHERE foo.x = :x",
            params={class="st">"x": 1, class="st">"y": 2},
        )

    def test_labels_no_collision(self):
        t = table(class="st">"foo", column(class="st">"id"), column(class="st">"foo_id"))