Unique entity for two columns - Symfony2

Question

I have restaurants and categories - each category has one restaurant and each restaurant can have many categories. I want for each restaurant the categories to have unique names and I want if someone tries to break this, to get message that the form is not valid, not to be stopped by the schema. So here is what I try:

use Symfony\Bridge\Doctrine\Validator\Constraints\UniqueEntity;

/**
 * @ORM\Table(name="categories", uniqueConstraints={@ORM\UniqueConstraint(name="name_restaurant_id_idx", columns={"name", "restaurant_id"})}))
 * @ORM\Entity(repositoryClass="MyBundle\Entity\CategoryRepository")
 * @UniqueEntity({"name", "restaurant"})
 */
class Category
{
     /** @ORM\Column(name="category_id", type="integer")
     * @ORM\Id
     * @ORM\GeneratedValue(strategy="IDENTITY")
     */
    private $categoryId;

    /**
     * @ORM\Column(name="name", type="string", length=45, nullable=false, unique=true)
     */
    private $name;

    /**
     * @ORM\ManyToOne(targetEntity="MyBundle\Entity\Restaurant")
     * @ORM\JoinColumns({
     *   @ORM\JoinColumn(name="restaurant_id", referencedColumnName="restaurant_id", unique=true)
     * })
     */
    private $restaurant;

but it's not working :( I'm stopped by the schema with

SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry

I also tried * @UniqueEntity({"name", "restaurant_id"}), but I get an error that restaurant_id is not mapped by Doctrine.

Any ideas why it's not working :(

This question appears related: stackoverflow.com/questions/12001753/… — Darragh Enright
– Darragh Enright, Commented Apr 1, 2014 at 12:21
Thank you! But I don't have validation groups and I don't want to create. — Faery
– Faery, Commented Apr 1, 2014 at 12:32
what do you mean by but it's not working :( I'm stopped by the schema with? When does this happen? Please elaborate. — lordrhodos
– lordrhodos, Commented Jun 21, 2017 at 3:49

Boefjim · Accepted Answer · 2022-12-15 11:12:59Z

1

To create a unique constraint on more than one field you have to add them to the fields argument in @UniqueEntity().

For example:

    @UniqueEntity(fields={"name", "restaurant"}).

I also hope this issue has since been resolved https://github.com/symfony/symfony/issues/6727

edited Dec 15, 2022 at 11:12

Boefjim

151 silver badge8 bronze badges

answered Apr 3, 2014 at 5:26

M.B Kakadiya

5761 gold badge5 silver badges18 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Alberto Fernández · Accepted Answer · 2014-04-01 13:01:49Z

0

I think your problem is that you already have data in your table that does not comply with you new constraint. Try truncating the table and updating again, or manually editing the data to reflect the new constraint prior updating the schema.

answered Apr 1, 2014 at 13:01

Alberto Fernández

1,60814 silver badges23 bronze badges

Comments

Graham · Accepted Answer · 2017-08-14 01:05:23Z

0

In my own UniqueEntity I had a customer field and an option field that had to be a unique combination. The customer was set by the request to the controller, not by the form itself, so the assert wasn't working. I was able to fix the problem by having the form Render the customer, then hiding that option in the rendered form view.

edited Aug 14, 2017 at 1:05

Graham

7,86020 gold badges67 silver badges92 bronze badges

answered Jun 20, 2017 at 23:00

Matt J

415 bronze badges

Collectives™ on Stack Overflow

Unique entity for two columns - Symfony2

3 Answers 3

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related