About transaction

[hiscaler]

class PurchaseOrder {
    private ?int $id = null;
    ....
}

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

    #[Column(type: 'integer')]
    private int $purchase_order_id;
    #[BelongsTo(target: PurchaseOrder::class, innerKey: 'purchase_order_id', outerKey: 'id')]
    private PurchaseOrder $purchaseOrder;

    #[Column(type: 'integer', nullable: true, default: null)]
    private ?int $order_item_id = null;
    #[BelongsTo(target: OrderItem::class, innerKey: 'order_item_id', outerKey: 'id', nullable: true)]
    private ?OrderItem $orderItem = null;
}


class OrderItem {
...

    #[BelongsTo(target: PurchaseOrder::class, innerKey: 'purchase_order_id', outerKey: 'id', nullable: true)]
    private ?PurchaseOrder $purchaseOrder = null;
}

When create an purchase order, if purchase order item from OrderItem, must be set current PurchaseOrder to OrderItem.PurchaseOrder and change OrderItem.status to 1, all actions must in transaction, so i write a method in repo

public function generate(PurchaseOrder $purchaseOrder, array $orderItems): void
    {
        if (empty($orderItems)) {
            throw new \InvalidArgumentException('Invalid data');
        }
        foreach ($orderItems as $orderItem) {
            if (!($orderItem instanceof OrderItem)) {
                throw new \InvalidArgumentException('Invalid data。');
            }
        }

        $entityManager = new EntityManager($this->orm);
        $entityManager->persist($purchaseOrder);
        foreach ($orderItems as $orderItem) {
            $orderItem
                ->setPurchaseOrder($purchaseOrder)
                ->setStatus(OrderItemStatus::FactoryWaitingTake);
            $entityManager->persist($orderItem);
        }

        $entityManager->run();
    }


 $this->purchaseOrderRepository->generate($purchaseOrder, $items);

Error
"message": "Undefined array key "id"",
"code": 2,
"file": "/api/vendor/cycle/orm/src/Relation/BelongsTo.php",
"line": 130,

[roxblnfk]

Looks like there is no #[Column(type: 'primary')] on the PurchaseOrder::$id property

[hiscaler]

Sorry, actual has it, i forget write it.

[roxblnfk]

Ah. Ok.
What ORM version do you use? Could you create a PR with test case into ORM repository?

[hiscaler]

    "cycle/database": "^2.0"`,
    "cycle/entity-behavior": "^1.0",
    "cycle/orm": "^2.0",

is latest version.

i write a test, is ok, but my project still throw error, i don't know why.

hiscaler@8527d67

[roxblnfk]

Have you tried 2.11.0-RC1?

[roxblnfk]

The test may be passed because the relations has been updated in 2.11.0-RC1

[hiscaler]

name : cycle/orm
descrip. : PHP DataMapper ORM and Data Modelling Engine
keywords : data-mapper, mssql, mysql, orm, postgresql, query-builder, sql, sqlite
versions : * 2.11.0-RC1
released : 2025-05-04, 2 weeks ago
type : library
license : MIT License (MIT) (OSI approved) https://spdx.org/licenses/MIT.html#licenseText
homepage : https://cycle-orm.dev
source : [git] https://github.com/cycle/orm.git 78009d9
dist : [zip] https://api.github.com/repos/cycle/orm/zipball/78009d98f32609a841bdeaf9d4d6e08bce5bd23f 78009d9
path : /Users/hiscaler/wwwroot/echok/echok-api/vendor/cycle/orm
names : cycle/orm

Still has error.

[roxblnfk]

Could you create a PR with the mentioned test case and link this discussion?
I'll try to complete your test case and fix the issue

[hiscaler]

I create a PR #525

Thank you very much.