Method test_expand_dml_bulk

test/ext/test_hybrid.py:1805–1845

(self, crud, expand_dml, decl_base, connection)

    @testing.variation("crud", ["insert", "update"])
    def test_expand_dml_bulk(self, crud, expand_dml, decl_base, connection):
        A = expand_dml
        decl_base.metadata.create_all(connection)

        with self.sql_execution_asserter(connection) as asserter:
            with Session(connection) as session:
                session.execute(
                    insert(A),
                    [
                        {"id": 1, "xy": Point(3, 4)},
                        {"id": 2, "xy": Point(5, 6)},
                    ],
                )

                if crud.update:
                    session.execute(
                        update(A),
                        [
                            {"id": 1, "xy": Point(10, 9)},
                            {"id": 2, "xy": Point(7, 8)},
                        ],
                    )
        asserter.assert_(
            CompiledSQL(
                "INSERT INTO a (id, x, y) VALUES (:id, :x, :y)",
                [{"id": 1, "x": 3, "y": 4}, {"id": 2, "x": 5, "y": 6}],
            ),
            Conditional(
                crud.update,
                [
                    CompiledSQL(
                        "UPDATE a SET x=:x, y=:y WHERE a.id = :a_id",
                        [
                            {"x": 10, "y": 9, "a_id": 1},
                            {"x": 7, "y": 8, "a_id": 2},
                        ],
                    )
                ],
                [],
            ),
        )

    @testing.variation("keytype", ["attr", "string"])
    def test_expand_update_insert_values(self, expand_update, keytype):