How to update hasMany records?

[hiscaler]

 $blocks = $form->getBlocks();
        foreach ($request->getBlocks() as $block) {
            /* @var DynamicFormBlock $block */
            if ($block->getId() === null) {
                $form->addBlock($block);
            } else {
                // update or delete
                $index = -1;
                foreach ($blocks as $k => $v) {
                    /* @var DynamicFormBlock $v */
                    if ($block->getId() === $v->getId()) {
                        $index = $k;
                        break;
                    }
                }
                if ($index !== -1) {
                    // Update
                    /* @var DynamicFormBlock $bb */
                    $form->getBlocks()->get($index)->setTitle(Random::string(12));
                } else {
                    $form->addBlock($block);
                }
            }
        }

error:
SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '19' for key 'dynamic_form_block.PRIMARY'

[roxblnfk]

Could you provide more context?
It's to dufficult to understand where are entities there.

The exception means that you are trying to store an entity with existing identifier.

[hiscaler]

<?php
declare(strict_types=1);

namespace App\DynamicForm;

use App\DynamicForm\Collection\DynamicFormCollection;
use App\Traits\CreatedAtTrait;
use App\Traits\CreatedByTrait;
use App\Traits\DeletedAtTrait;
use App\Traits\DeletedByTrait;
use App\Traits\UpdatedAtTrait;
use App\Traits\UpdatedByTrait;
use Cycle\Annotated\Annotation\{Column, Entity, Relation\HasMany};
use DateTimeImmutable;
use Doctrine\Common\Collections\ArrayCollection;

/**
 * 动态表单
 */
#[Entity(repository: DynamicFormRepository::class)]
class DynamicForm
{

    use CreatedAtTrait;
    use CreatedByTrait;
    use UpdatedAtTrait;
    use UpdatedByTrait;
    use DeletedAtTrait;
    use DeletedByTrait;

    #[Column(type: 'primary')]
    private ?int $id = null;

    #[Column(type: 'string(60)')]
    private string $title;

    #[Column(type: 'tinyText', nullable: true)]
    private ?string $description = null;

    #[Column(type: 'string(100)', nullable: true)]
    private ?string $image = null;

    #[Column(type: 'datetime', nullable: true)]
    private ?DateTimeImmutable $start_datetime = null;

    #[Column(type: 'datetime', nullable: true)]
    private ?DateTimeImmutable $end_datetime = null;

    #[Column(type: 'boolean', default: false)]
    private bool $allow_anonymous = false;

    #[Column(type: 'tinyInteger', default: 0)]
    private int $status = 0;

    #[Column(type: 'tinyText', nullable: true)]
    private ?string $remark = null;

    #[HasMany(target: DynamicFormBlock::class, outerKey: 'form_id', orderBy: ['ordering' => 'ASC'])]
    protected ArrayCollection $blocks;

    public function getBlocks(): ArrayCollection
    {
        return $this->blocks;
    }

    public function resetBlocks(): void
    {
        $this->blocks = new ArrayCollection();
    }

    public function addBlock(DynamicFormBlock $block): void
    {
        $this->blocks[] = $block;
    }

    public function removeBlock(DynamicFormBlock $block): void
    {
        $this->blocks = array_filter($this->blocks, static fn(DynamicFormBlock $d) => $d !== $block);
    }

    /**
     * @var array 表单数据收集
     */
    #[HasMany(target: DynamicFormCollection::class, outerKey: 'form_id', orderBy: ['datetime' => 'DESC'])]
    private array $collections = [];

    public function __construct()
    {
        $this->created_at = new DateTimeImmutable();
        $this->updated_at = new DateTimeImmutable();
        $this->blocks = new ArrayCollection();
    }

    /**
     * @return int|null
     */
    public function getId(): ?int
    {
        return $this->id;
    }

    /**
     * @return string
     */
    public function getTitle(): string
    {
        return $this->title;
    }

    /**
     * @param string $title
     * @return DynamicForm
     */
    public function setTitle(string $title): DynamicForm
    {
        $this->title = trim($title);

        return $this;
    }

    /**
     * @return string|null
     */
    public function getDescription(): ?string
    {
        return $this->description;
    }

    /**
     * @param string|null $description
     * @return DynamicForm
     */
    public function setDescription(?string $description): DynamicForm
    {
        if ($description !== null) {
            $description = trim($description);
        }
        $this->description = $description ?? null;

        return $this;
    }

    /**
     * @return string|null
     */
    public function getImage(): ?string
    {
        return $this->image;
    }

    /**
     * @param string|null $image
     * @return DynamicForm
     */
    public function setImage(?string $image): DynamicForm
    {
        if ($image !== null) {
            $image = trim($image);
        }
        $this->image = $image ?: null;

        return $this;
    }

    /**
     * @return DateTimeImmutable|null
     */
    public function getStartDatetime(): ?DateTimeImmutable
    {
        return $this->start_datetime;
    }

    /**
     * @param DateTimeImmutable|null $startDatetime
     * @return DynamicForm
     */
    public function setStartDatetime(?DateTimeImmutable $startDatetime): DynamicForm
    {
        $this->start_datetime = $startDatetime;

        return $this;
    }

    /**
     * @return DateTimeImmutable|null
     */
    public function getEndDatetime(): ?DateTimeImmutable
    {
        return $this->end_datetime;
    }

    /**
     * @param DateTimeImmutable|null $endDatetime
     * @return DynamicForm
     */
    public function setEndDatetime(?DateTimeImmutable $endDatetime): DynamicForm
    {
        $this->end_datetime = $endDatetime;

        return $this;
    }

    /**
     * @return bool
     */
    public function isAllowAnonymous(): bool
    {
        return $this->allow_anonymous;
    }

    /**
     * @param bool $allowAnonymous
     * @return DynamicForm
     */
    public function setAllowAnonymous(bool $allowAnonymous): DynamicForm
    {
        $this->allow_anonymous = $allowAnonymous;

        return $this;
    }

    /**
     * @return int
     */
    public function getStatus(): int
    {
        return $this->status;
    }

    /**
     * @param int $status
     * @return DynamicForm
     */
    public function setStatus(int $status): DynamicForm
    {
        $this->status = $status;

        return $this;
    }

    /**
     * @return string|null
     */
    public function getRemark(): ?string
    {
        return $this->remark;
    }

    /**
     * @param string|null $remark
     * @return DynamicForm
     */
    public function setRemark(?string $remark): DynamicForm
    {
        $this->remark = $remark;

        return $this;
    }

}

<?php
declare(strict_types=1);

namespace App\DynamicForm;

use App\Helper\Nullx;
use Cycle\Annotated\Annotation\{Column, Entity, Relation\HasMany};
use Doctrine\Common\Collections\ArrayCollection;

/**
 * 动态表单区块
 */
#[Entity]
class DynamicFormBlock
{

    #[Column(type: 'primary')]
    private ?int $id = null;

    #[Column(type: 'integer')]
    private int $form_id;

    #[Column(type: 'tinyInteger', default: 1)]
    private int $ordering;

    #[Column(type: 'string(60)')]
    private string $title;

    #[Column(type: 'tinyText', nullable: true)]
    private ?string $description = null;

    #[HasMany(target: DynamicFormBlockField::class, outerKey: 'block_id', orderBy: ['ordering' => 'ASC'])]
    private ArrayCollection $fields;

    public function getFields(): ArrayCollection
    {
        return $this->fields;
    }

    public function addField(DynamicFormBlockField $field): void
    {
        $this->fields[] = $field;
    }

    public function removeField(DynamicFormBlockField $field): void
    {
        $this->fields = $this->fields->filter(static fn(DynamicFormBlockField $d) => $d !== $field);
    }

    public function __construct()
    {
        $this->fields = new ArrayCollection();
    }

    /**
     * @return int|null
     */
    public function getId(): ?int
    {
        return $this->id;
    }

    /**
     * @param int|null $id
     * @return DynamicFormBlock
     */
    public function setId(?int $id): DynamicFormBlock
    {
        $this->id = $id;

        return $this;
    }

    /**
     * @return int
     */
    public function getFormId(): int
    {
        return $this->form_id;
    }

    /**
     * @param int $formId
     * @return DynamicFormBlock
     */
    public function setFormId(int $formId): DynamicFormBlock
    {
        $this->form_id = $formId;

        return $this;
    }

    /**
     * @return int
     */
    public function getOrdering(): int
    {
        return $this->ordering;
    }

    /**
     * @param int $ordering
     * @return DynamicFormBlock
     */
    public function setOrdering(int $ordering): DynamicFormBlock
    {
        $this->ordering = $ordering > 0 ? $ordering : 1;

        return $this;
    }

    /**
     * @return string
     */
    public function getTitle(): string
    {
        return $this->title;
    }

    /**
     * @param string $title
     * @return DynamicFormBlock
     */
    public function setTitle(string $title): DynamicFormBlock
    {
        $this->title = trim($title);

        return $this;
    }

    /**
     * @return string|null
     */
    public function getDescription(): ?string
    {
        return $this->description;
    }

    /**
     * @param string|null $description
     * @return DynamicFormBlock
     */
    public function setDescription(?string $description): DynamicFormBlock
    {
        $this->description = Nullx::string($description);

        return $this;
    }

}

Controller

 public function update(EditDynamicFormRequest $editDynamicFormRequest, UserRequest $userRequest, #[Route('id')] int $id): Response
    {
        $form = $this->dynamicFormBuilder->build(
            $this->dynamicFormService->getForm($id),
            $editDynamicFormRequest
        );
        $form->setUpdatedUser($userRequest->getUser());
        $this->dynamicFormRepository->save($form);

        return $this->responseFactory->createResponse([
            'form' => $this->dynamicFormFormatter->format($form)
        ]);
    }

<?php

declare(strict_types=1);

namespace App\DynamicForm;

use App\Helper\Uploader\Uploader;
use Exception;
use Yiisoft\Security\Random;

final class DynamicFormBuilder
{

    public function __construct(
        private Uploader $uploader,
    )
    {
    }

    public function build(DynamicForm $form, EditDynamicFormRequest $request): DynamicForm
    {
        $form->setTitle($request->getTitle());
        $form->setDescription($request->getDescription());
        $image = $request->getImage();
        if ($image) {
            try {
                if ($this->uploader->setFile($image)->save()) {
                    $form->setImage($this->uploader->getFileInformation()->getPath());
                }
            } catch (Exception) {
            }
        }
        $form->setStartDatetime($request->getStartDatetime());
        $form->setEndDatetime($request->getEndDatetime());
        $form->setAllowAnonymous($request->getAllowAnonymous());
        $form->setStatus($request->getStatus());
        $blocks = $form->getBlocks();
        foreach ($request->getBlocks() as $block) {
            /* @var DynamicFormBlock $block */
            if ($block->getId() === null) {
                $form->addBlock($block);
            } else {
                // update or delete
                $index = -1;
                foreach ($blocks as $k => $v) {
                    /* @var DynamicFormBlock $v */
                    if ($block->getId() === $v->getId()) {
                        $index = $k;
                        break;
                    }
                }
                if ($index !== -1) {
                    // Update
                    /* @var DynamicFormBlock $bb */
//                    $block->setTitle("2111");
                     $form->getBlocks()->get($index)->setTitle(Random::string(12));
                } else {
                    $form->addBlock($block);
                }
            }
        }
        $form->setRemark($request->getRemark());
        foreach ($request->getBlocks() as $block) {
            $form->addBlock($block);
        }

        return $form;
    }

}