Edit Question - KnowledgeHub

Title Body

I want to make a unique constraint in my Doctrine 2 entity such that name & test are unique column wise. Meaning obj1 name: name1 test: test obj2 name: name2 test: test <---- duplicated This should trigger an error as test is duplicated. I tried using the unique constraint ( Symfony\Bridge\Doctrine\Validator\Constraints\UniqueEntity ). Tried * @UniqueEntity("name") * @UniqueEntity("test") and * @UniqueEntity({"name", "test"}) Both seem to only trigger error when I have BOTH name and test duplicated. eg. obj1 name: name1 test: test obj2 name: name2 test: test Whats the right setup? Or I might have made a mistake somewhere? Perhaps I should include the doctrine annotation like: @Table(name="ecommerce_products",uniqueConstraints={@UniqueConstraint(name="search_idx", columns={"name", "email"})}) But that still wont handle my symfony form validation I think? UPDATE My test code: /** * @ORM\Entity * @ORM\Table(name="roles") * @UniqueEntity("name") * @UniqueEntity("test") */ class Role { /** * @var integer * @ORM\Column(type="integer") * @ORM\Id * @ORM\GeneratedValue */ protected $id; /** * @var string * * @ORM\Column(type="string", length=32, unique=true) * @Assert\MaxLength(32) * @Assert\Regex("/^[a-zA-Z0-9_]+$/") */ protected $name; } $v = $this->get('validator'); $role = new Role(); $role->setName('jm'); $role->setTest('test'); $e = $v->validate($role); echo '=== 1 ==='; var_dump($e); if (count($e) == 0) $em->persist($role);

Tags (comma-separated) Cancel