Method test_from_sql_expr

test/sql/test_update.py:1139–1159

(self)

        )

    def test_from_sql_expr(self):
        mytable = self.tables.mytable
        stmt = mytable.update().values(
            name=mytable.c.name + "lala",
            description=from_dml_column(mytable.c.name),
        )

        self.assert_compile(
            stmt,
            "UPDATE mytable SET name=(mytable.name || :name_1), "
            "description=(mytable.name || :name_1)",
            checkparams={"name_1": "lala"},
        )

        self.assert_compile(
            stmt,
            "UPDATE mytable SET name=(mytable.name || ?), "
            "description=(mytable.name || ?)",
            checkpositional=("lala", "lala"),
            dialect="sqlite",
        )

    def test_from_sql_expr_multiple_dmlcol(self):
        mytable = self.tables.mytable