OneToMany和OneToOne中的教义级联删除失败 [英] Doctrine cascade removing fails with OneToMany and OneToOne

问题描述

过去几天，我一直在努力解决使用Doctrine的一个简单的级联去除案例。
学说和Symfony是最新的。
我有两个实体意图和资产通过两个关系OneToOne和OneToMany相互链接。

I've been struggling for the past few days on a simple case of cascade removing using Doctrine. Doctrine and Symfony are up to date. I have two entities Serie and Asset that are linked to each other by two relationships OneToOne and OneToMany.

模式完全是这样的：

意甲有很多资产。 （内容）。

A Serie has many Assets. (content).

意甲可以拥有资产。 （一个预览，此字段为空）

A Serie can have an Asset. (a preview, this field is nullable).

但是，无论我如何尝试写入和重写注释，我一直都会遇到这个错误：

However, no matter how I try to write and rewrite the annotations, I ALWAYS end up with this error:

使用params [1]执行DELETE FROM serie WHERE id =？时出现异常：

An exception occurred while executing 'DELETE FROM serie WHERE id = ?' with params [1]:

SQLSTATE [23000]：完整性约束违反：1451无法删除或
更新父行：外键约束失败
（ galanthis 。资产，CONSTRAINT FK_2AF5A5CAA3A9334 FOREIGN KEY
（ serie ）参考 serie （ id ））

SQLSTATE[23000]: Integrity constraint violation: 1451 Cannot delete or update a parent row: a foreign key constraint fails (galanthis.asset, CONSTRAINT FK_2AF5A5CAA3A9334 FOREIGN KEY (serie) REFERENCES serie (id))

当然，如果我在以下代码中删除预览字段及其注释，则问题将消失：

Of course, the problem disappear if I delete the "preview" field and its annotations in the following code:

/**
 * Serie
 *
 * @ORM\Table(name="serie")
 * @ORM\Entity(repositoryClass="Gedmo\Sortable\Entity\Repository\SortableRepository")
 * @ORM\HasLifecycleCallbacks
 */
class Serie
{
/**
 * @var integer
 *
 * @ORM\Column(name="id", type="integer")
 * @ORM\Id
 * @ORM\GeneratedValue(strategy="AUTO")
 */
private $id;

/**
 * @var string
 *
 * @ORM\Column(name="title", type="string", length=96)
 */
private $title;

/**
 * @var integer
 *
 * @Gedmo\SortablePosition
 * @ORM\Column(name="position", type="integer", nullable=true)
 */
private $position;

/**
 * @var \Portfolio
 *
 * @ORM\ManyToOne(targetEntity="Portfolio", inversedBy="series")
 * @ORM\JoinColumns({
 *   @ORM\JoinColumn(name="portfolio", referencedColumnName="id")
 * })
 */
private $portfolio;


/**
 * @var \Asset
 *
 * @ORM\OneToOne(targetEntity="Asset")
 * @ORM\JoinColumns({
 *   @ORM\JoinColumn(name="preview", referencedColumnName="id", nullable=true, onDelete="SET NULL")
 * })
 */
private $preview;

/**
 * @var \Doctrine\Common\Collections\Collection
 *
 * @ORM\OneToMany(targetEntity="Asset", mappedBy="serie", cascade={"remove"})
 **/
private $assets;

以下是资产实体的代码：

Here's the code for the Asset entity:

/**
 * Asset
 *
 * @ORM\Table(name="asset")
 * @ORM\Entity(repositoryClass="Gedmo\Sortable\Entity\Repository\SortableRepository")
 * @ORM\HasLifecycleCallbacks
 * @ORM\InheritanceType("SINGLE_TABLE")
 * @ORM\DiscriminatorColumn(name="asset", type="string")
 * @ORM\DiscriminatorMap({"asset" = "Asset", "video" = "Video","image" = "Image"})
 *
 */
class Asset
{
/**
 * @var integer
 *
 * @ORM\Column(name="id", type="integer")
 * @ORM\Id
 * @ORM\GeneratedValue(strategy="AUTO")
 */
protected $id;

/**
 * @var string
 *
 * @ORM\Column(name="path", type="string", length=128)
 */
protected $path;

/**
 * @var string
 *
 * @ORM\Column(name="filename", type="string", length=64)
 */
protected $filename;

/**
 * @var integer
 *
 * @ORM\Column(name="position", type="integer", nullable=true)
 * @Gedmo\SortablePosition
 */
protected $position;

/**
 * @var string
 *
 * @ORM\Column(name="description", type="string", length=255, nullable=true)
 */
protected $description;

/**
 * @var string
 *
 * @ORM\Column(name="mime", type="string", length=16, nullable=true)
 */
protected $mime;

/**
 * @var \Serie
 *
 * @ORM\ManyToOne(targetEntity="Serie", inversedBy="assets")
 * @ORM\JoinColumns({
 *   @ORM\JoinColumn(name="serie", referencedColumnName="id")
 * })
 */
protected $serie;

/**
 * @var UploadedFile
 */
protected $file;

/**
 * @var string
 */
protected $extension;

这让我疯狂，这只是一些简单的关系...有一个错误我不是看到了，还是需要使用解决方法？

It's driving me crazy, it's just some simple relationships... Is there a mistake I'm not seeing anymore, or do i need to use a workaround?

推荐答案

我的猜测是设置cascade = {remove}在资产实体中的 ManyToOne关系而不是其他方式。这样，它告诉Doctrine当你删除与许多资产相关联的系列时该怎么办。

My guess is to set the cascade={"remove"} on the ManyToOne relationship in the Asset entity and not the other way around. That way, it tells Doctrine what to do when you delete a serie that is linked to many assets.

这篇关于OneToMany和OneToOne中的教义级联删除失败的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！