Cycle ORM
Replies: 1 comment 2 replies
-
|
Looks like an |
Beta Was this translation helpful? Give feedback.
-
|
Is App\WooCommerce\Package\Package has no parent App\Logistics\Package\Package If you use follow code, is ok $parentPackage = (new \App\Logistics\Package\Package())
->setNumber($package->getNumber())
->setCreatedUser($user)
->setLogisticsChannel($channel);
$this->packageRepository->save($parentPackage); // Save it before add to $wooPackage
$wooPackage = (new WooPackage())
->setKey($package->getNumber())
->setStatus(WooPackageStatus::Unknown)
->setCreatedUser($user)
->setParent($parentPackage)
->setOrder($order)
->setUpdatedUser($user);
$order->addPackage($wooPackage);
$this->orderRepository->save($order);Why can't cascade save parentPackage, package and order? |
Beta Was this translation helpful? Give feedback.
-
|
Usually, the parent entity is saved properly. The problem might be something else. |
Beta Was this translation helpful? Give feedback.
-
[ 'woo_commerce_order' => [ Schema::ENTITY => App\WooCommerce\Order\Order::class, Schema::MAPPER => Cycle\ORM\Mapper\Mapper::class, Schema::SOURCE => Cycle\ORM\Select\Source::class, Schema::REPOSITORY => App\WooCommerce\Order\OrderRepository::class, Schema::DATABASE => 'default', Schema::TABLE => 'woo_commerce_order', Schema::PRIMARY_KEY => ['id'], Schema::FIND_BY_KEYS => ['id'], Schema::COLUMNS => [ 'id' => 'id', 'parent_id' => 'parent_id', 'woo_commerce_id' => 'woo_commerce_id', 'external_key' => 'external_key', 'number' => 'number', 'sale_datetime' => 'sale_datetime', 'paid_datetime' => 'paid_datetime', 'completed_datetime' => 'completed_datetime', 'store_id' => 'store_id', 'customer_id' => 'customer_id', 'discount_total' => 'discount_total', 'discount_tax' => 'discount_tax', 'shipping_total' => 'shipping_total', 'shipping_tax' => 'shipping_tax', 'total' => 'total', 'total_tax' => 'total_tax', 'currency' => 'currency', 'remark' => 'remark', 'status' => 'status', 'flow_status' => 'flow_status', 'created_at' => 'created_at', 'created_by' => 'created_by', 'updated_at' => 'updated_at', 'updated_by' => 'updated_by', 'is_deleted' => 'is_deleted', 'deleted_at' => 'deleted_at', 'deleted_by' => 'deleted_by', 'createdAt' => 'created_at', 'updatedAt' => 'updated_at', ], Schema::RELATIONS => [ 'packages' => [ Relation::TYPE => Relation::HAS_MANY, Relation::TARGET => 'woo_commerce_package', Relation::LOAD => Relation::LOAD_PROMISE, Relation::SCHEMA => [ Relation::CASCADE => true, Relation::NULLABLE => false, Relation::WHERE => [], Relation::ORDER_BY => [], Relation::INNER_KEY => ['id'], Relation::OUTER_KEY => ['order_id'], '4' => null, ], ], ], Schema::SCOPE => null, Schema::TYPECAST => [ 'id' => 'int', 'parent_id' => 'int', 'woo_commerce_id' => 'int', 'sale_datetime' => 'datetime', 'paid_datetime' => 'datetime', 'completed_datetime' => 'datetime', 'store_id' => 'int', 'customer_id' => 'int', 'discount_total' => 'float', 'discount_tax' => 'float', 'shipping_total' => 'float', 'shipping_tax' => 'float', 'total' => 'float', 'total_tax' => 'float', 'flow_status' => 'int', 'created_at' => 'datetime', 'created_by' => 'int', 'updated_at' => 'datetime', 'updated_by' => 'int', 'is_deleted' => 'bool', 'deleted_at' => 'datetime', 'deleted_by' => 'int', 'createdAt' => 'datetime', 'updatedAt' => 'datetime', ], Schema::SCHEMA => [], Schema::LISTENERS => [ [ Cycle\ORM\Entity\Behavior\Listener\CreatedAt::class, [ 'field' => 'createdAt', ], ], [ Cycle\ORM\Entity\Behavior\Listener\UpdatedAt::class, [ 'field' => 'updatedAt', 'nullable' => false, ], ], ], Schema::TYPECAST_HANDLER => null, ], 'woo_commerce_package' => [ Schema::ENTITY => App\WooCommerce\Package\Package::class, Schema::MAPPER => Cycle\ORM\Mapper\Mapper::class, Schema::SOURCE => Cycle\ORM\Select\Source::class, Schema::REPOSITORY => App\WooCommerce\Package\PackageRepository::class, Schema::DATABASE => 'default', Schema::TABLE => 'woo_commerce_package', Schema::PRIMARY_KEY => ['id'], Schema::FIND_BY_KEYS => ['id'], Schema::COLUMNS => [ 'id' => 'id', 'key' => 'key', 'parent_id' => 'parent_id', 'order_id' => 'order_id', 'status' => 'status', 'created_at' => 'created_at', 'created_by' => 'created_by', 'updated_at' => 'updated_at', 'updated_by' => 'updated_by', 'createdAt' => 'created_at', 'updatedAt' => 'updated_at', ], Schema::RELATIONS => [ 'parent' => [ Relation::TYPE => Relation::BELONGS_TO, Relation::TARGET => 'logistics_package', Relation::LOAD => Relation::LOAD_PROMISE, Relation::SCHEMA => [ Relation::CASCADE => true, Relation::NULLABLE => false, Relation::INNER_KEY => ['parent_id'], Relation::OUTER_KEY => ['id'], ], ], 'order' => [ Relation::TYPE => Relation::BELONGS_TO, Relation::TARGET => 'woo_commerce_order', Relation::LOAD => Relation::LOAD_PROMISE, Relation::SCHEMA => [ Relation::CASCADE => true, Relation::NULLABLE => false, Relation::INNER_KEY => ['order_id'], Relation::OUTER_KEY => ['id'], ], ], ], Schema::SCOPE => null, Schema::TYPECAST => [ 'id' => 'int', 'parent_id' => 'int', 'order_id' => 'int', 'status' => 'int', 'created_at' => 'datetime', 'created_by' => 'int', 'updated_at' => 'datetime', 'updated_by' => 'int', 'createdAt' => 'datetime', 'updatedAt' => 'datetime', ], Schema::SCHEMA => [], Schema::LISTENERS => [ [ Cycle\ORM\Entity\Behavior\Listener\CreatedAt::class, [ 'field' => 'createdAt', ], ], [ Cycle\ORM\Entity\Behavior\Listener\UpdatedAt::class, [ 'field' => 'updatedAt', 'nullable' => false, ], ], ], Schema::TYPECAST_HANDLER => null, ], 'logistics_package' => [ Schema::ENTITY => App\Logistics\Package\Package::class, Schema::MAPPER => Cycle\ORM\Mapper\Mapper::class, Schema::SOURCE => Cycle\ORM\Select\Source::class, Schema::REPOSITORY => App\Logistics\Package\PackageRepository::class, Schema::DATABASE => 'default', Schema::TABLE => 'logistics_package', Schema::PRIMARY_KEY => ['id'], Schema::FIND_BY_KEYS => ['id'], Schema::COLUMNS => [ 'id' => 'id', 'logistics_channel_id' => 'logistics_channel_id', 'number' => 'number', 'order_datetime' => 'order_datetime', 'tracking_number' => 'tracking_number', 'weight' => 'weight', 'postage' => 'postage', 'dispatch_datetime' => 'dispatch_datetime', 'tracks' => 'tracks', 'current_node_id' => 'current_node_id', 'status' => 'status', 'exceptions' => 'exceptions', 'created_at' => 'created_at', 'created_by' => 'created_by', 'updated_at' => 'updated_at', 'updated_by' => 'updated_by', 'createdAt' => 'created_at', 'updatedAt' => 'updated_at', ], Schema::RELATIONS => [ 'logisticsChannel' => [ Relation::TYPE => Relation::BELONGS_TO, Relation::TARGET => 'logistics_company_channel', Relation::LOAD => Relation::LOAD_PROMISE, Relation::SCHEMA => [ Relation::CASCADE => true, Relation::NULLABLE => true, Relation::INNER_KEY => ['logistics_channel_id'], Relation::OUTER_KEY => ['id'], ], ], 'current_node' => [ Relation::TYPE => Relation::BELONGS_TO, Relation::TARGET => 'logistics_track_detection_node', Relation::LOAD => Relation::LOAD_PROMISE, Relation::SCHEMA => [ Relation::CASCADE => true, Relation::NULLABLE => true, Relation::INNER_KEY => ['current_node_id'], Relation::OUTER_KEY => ['id'], ], ], 'createdUser' => [ Relation::TYPE => Relation::BELONGS_TO, Relation::TARGET => 'user', Relation::LOAD => Relation::LOAD_PROMISE, Relation::SCHEMA => [ Relation::CASCADE => true, Relation::NULLABLE => false, Relation::INNER_KEY => ['created_by'], Relation::OUTER_KEY => ['id'], ], ], 'updatedUser' => [ Relation::TYPE => Relation::BELONGS_TO, Relation::TARGET => 'user', Relation::LOAD => Relation::LOAD_PROMISE, Relation::SCHEMA => [ Relation::CASCADE => true, Relation::NULLABLE => false, Relation::INNER_KEY => ['updated_by'], Relation::OUTER_KEY => ['id'], ], ], ], Schema::SCOPE => null, Schema::TYPECAST => [ 'id' => 'int', 'logistics_channel_id' => 'int', 'order_datetime' => 'datetime', 'weight' => 'int', 'postage' => 'float', 'dispatch_datetime' => 'datetime', 'current_node_id' => 'int', 'status' => 'int', 'created_at' => 'datetime', 'created_by' => 'int', 'updated_at' => 'datetime', 'updated_by' => 'int', 'createdAt' => 'datetime', 'updatedAt' => 'datetime', ], Schema::SCHEMA => [], Schema::LISTENERS => [ [ Cycle\ORM\Entity\Behavior\Listener\CreatedAt::class, [ 'field' => 'createdAt', ], ], [ Cycle\ORM\Entity\Behavior\Listener\UpdatedAt::class, [ 'field' => 'updatedAt', 'nullable' => false, ], ], ], Schema::TYPECAST_HANDLER => null, ], ]Error: SQLSTATE[HY000]: General error: 1364 Field 'parent_id' doesn't have a default value
Beta Was this translation helpful? Give feedback.
All reactions