Method test_named_with_column_objects

test/sql/test_insert.py:1624–1674

(self, column_style)

    @testing.combinations(("strings",), ("columns",), ("inspectables",))
    def test_named_with_column_objects(self, column_style):
        table1 = self.tables.mytable

        if column_style == "strings":
            myid, name, description = "myid", "name", "description"

        elif column_style == "columns":
            myid, name, description = (
                table1.c.myid,
                table1.c.name,
                table1.c.description,
            )
        elif column_style == "inspectables":
            myid, name, description = (
                ORMExpr(table1.c.myid),
                ORMExpr(table1.c.name),
                ORMExpr(table1.c.description),
            )
        else:
            assert False

        values = [
            {myid: 1, name: "a", description: "b"},
            {myid: 2, name: "c", description: "d"},
            {myid: 3, name: "e", description: "f"},
        ]

        checkparams = {
            "myid_m0": 1,
            "myid_m1": 2,
            "myid_m2": 3,
            "name_m0": "a",
            "name_m1": "c",
            "name_m2": "e",
            "description_m0": "b",
            "description_m1": "d",
            "description_m2": "f",
        }

        dialect = default.DefaultDialect()
        dialect.supports_multivalues_insert = True

        self.assert_compile(
            table1.insert().values(values),
            "INSERT INTO mytable (myid, name, description) VALUES "
            "(:myid_m0, :name_m0, :description_m0), "
            "(:myid_m1, :name_m1, :description_m1), "
            "(:myid_m2, :name_m2, :description_m2)",
            checkparams=checkparams,
            dialect=dialect,
        )

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