Validate UniqueEntity for One-To-Many, Unidirectio

2019-07-08 09:35发布

I have 2 mapped entities,

Box

class Box{
    //[...]
    /**
     * @ORM\ManyToMany(targetEntity="Candy", cascade={"remove"})
     * @ORM\OrderBy({"power" = "DESC"})
     * @ORM\JoinTable(name="box_candies",
     *      joinColumns={@ORM\JoinColumn(name="box_id", referencedColumnName="id")},
     *      inverseJoinColumns={@ORM\JoinColumn(name="candy_id", referencedColumnName="id", unique=true)}
     *      )
     */
    private $candies;
}

And Candy

class Candy
{
    /**
     * @var integer
     *
     * @ORM\Column(name="id", type="integer")
     * @ORM\Id
     * @ORM\GeneratedValue(strategy="AUTO")
     */
    private $id;

    /**
     * @var string
     *
     * @ORM\Column(name="name", type="string", length=255)
     */
    private $name;
    //[...]
}

As you can see, this is One-To-Many, Unidirectional with Join Table association. Box can "store" candies, but Candy knows nothing about Box (where is).

Now I have page where I can make candy and there is form and standard isValid() and after that:

$box->addCandy($candy);
$entity_manager->persist($candy);
$entity_manager->persist($box);
$entity_manager->flush();

Now, where is my problem?

I would like to Box can store only unique candies (by name), that means Box can store Candy objects with names "Choco" and "Orange" but can't "Mayonnaise" and "Mayonnaise"

When making candy i can't validate with UniqueEntity constraint because the candy does not know about the box. I thought about Callback validator for Box or create own Constraint but i think it's better to ask:

How should I do it?

1条回答
别忘想泡老子
2楼-- · 2019-07-08 10:21

Answer is late but it may help someone so this is solution I implemented:

In my case I can create Candy only in one place via form so finally I decided to create additional special validation for that case in my controller/service.

Simply speaking I made code checking the name in my own way and when it's invalid, form just trow Error to prevent creation. I want to emphasize that this is a little dirty solution and also it is not scalable because you have to remember always to add it in correct place if you create Candy in other places.

    // special unique name validation
    $candy_name = $form->get('name')->getData();
    if($candy_name){
        $found_candy = $box->getCandyByName($candy_name);
        if($found_candy){
            $error = new FormError( $this->get('translator')->trans("candy.name.exist", array(), "validators") );
            $form->get('name')->addError($error);
        }
    }

Anyway it worked but depending on your case, Callback can be way better solution or even simple UniqueEntity constraint.

查看更多
登录 后发表回答