Method test_from_sql_expr

test/sql/test_insert.py:1292–1312

(self)

        )

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

        self.assert_compile(
            stmt,
            "INSERT INTO mytable (name, description) VALUES "
            "((mytable.name || :name_1), (mytable.name || :name_1))",
            checkparams={"name_1": "lala"},
        )

        self.assert_compile(
            stmt,
            "INSERT INTO mytable (name, description) VALUES "
            "((mytable.name || ?), (mytable.name || ?))",
            checkpositional=("lala", "lala"),
            dialect="sqlite",
        )

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