Method test_generative_cases

test/sql/test_insert_exec.py:3085–3192

(
        self,
        connection,
        metadata,
        sort_by_parameter_order,
        kind,
        operation,
        has_processor,
        freeze,
        driver_column_names,
    )

    @testing.variation("freeze", [True, False])
    @testing.variation("driver_column_names", [True, False])
    def test_generative_cases(
        self,
        connection,
        metadata,
        sort_by_parameter_order,
        kind,
        operation,
        has_processor,
        freeze,
        driver_column_names,
    ):
        class MyInt(TypeDecorator):
            cache_ok = True
            impl = Integer

            def result_processor(self, dialect, coltype):
                return str

        class MyStr(TypeDecorator):
            cache_ok = True
            impl = String(42)

            def result_processor(self, dialect, coltype):
                return str.upper

        t1 = Table(
            "t1",
            metadata,
            Column(
                "id",
                MyInt() if has_processor else Integer(),
                primary_key=True,
                test_needs_autoincrement=True,
            ),
            Column("data", MyStr() if has_processor else String(42)),
            Column("w_d", String(42), server_default="foo"),
        )

        stmt = t1.insert()
        data = [{"data": "a"}, {"data": "b"}, {"data": "c"}]
        if kind.returning:
            stmt = stmt.returning(
                t1.c.data,
                sort_by_parameter_order=bool(sort_by_parameter_order),
            )
            if has_processor:
                expected = [("A",), ("B",), ("C",)]
            else:
                expected = [("a",), ("b",), ("c",)]
        elif kind.returning_default:
            stmt = stmt.return_defaults(
                supplemental_cols=[t1.c.data],
                sort_by_parameter_order=bool(sort_by_parameter_order),
            )
            if has_processor:
                expected = [
                    ("1", "A", "foo"),
                    ("2", "B", "foo"),