Method test_from_sql_onupdate

test/sql/test_update.py:1075–1137

test combinations with a column that has a SQL onupdate

(self)

        )

    def test_from_sql_onupdate(self):
        """test combinations with a column that has a SQL onupdate"""

        mytable = self.tables.mytable_with_onupdate
        stmt = mytable.update().values(
            description=from_dml_column(mytable.c.updated_at)
        )

        self.assert_compile(
            stmt,
            "UPDATE mytable_with_onupdate SET description=now(), "
            "updated_at=now()",
        )

        stmt = mytable.update().values(
            description=cast(from_dml_column(mytable.c.updated_at), String)
            + " o clock"
        )

        self.assert_compile(
            stmt,
            "UPDATE mytable_with_onupdate SET "
            "description=(CAST(now() AS VARCHAR) || :param_1), "
            "updated_at=now()",
        )

        stmt = mytable.update().values(
            description=cast(from_dml_column(mytable.c.updated_at), String)
            + " "
            + from_dml_column(mytable.c.name)
        )

        self.assert_compile(
            stmt,
            "UPDATE mytable_with_onupdate SET "
            "description=(CAST(now() AS VARCHAR) || :param_1 || "
            "mytable_with_onupdate.name), updated_at=now()",
        )

        stmt = mytable.update().values(
            name="some name",
            description=cast(from_dml_column(mytable.c.updated_at), String)
            + " "
            + from_dml_column(mytable.c.name),
        )

        self.assert_compile(
            stmt,
            "UPDATE mytable_with_onupdate SET "
            "name=:name, "
            "description=(CAST(now() AS VARCHAR) || :param_1 || "
            ":name), updated_at=now()",
            checkparams={"name": "some name", "param_1": " "},
        )
        self.assert_compile(
            stmt,
            "UPDATE mytable_with_onupdate SET "
            "name=?, "