Symfony2, Doctrine, @UniqueEntity manejan excepción
ENTIDAD
use Doctrine\ORM\Mapping as ORM;
use Symfony\Component\Validator\Constraints as Assert;
use Symfony\Bridge\Doctrine\Validator\Constraints\UniqueEntity;
/**
* @ORM\Table(name="_apiKey")
* @ORM\Entity(repositoryClass="Eve\ProfileBundle\Entity\Repository\apiKeyRepository")
* @UniqueEntity(fields={"keyID", "vCode", "accountID"},
* message="you already own this api")
*/
class apiKey
{
public function __construct()
{
// empty
}
// relations start
// relations end
/**
* @ORM\Column(name="entryID", type="integer")
* @ORM\Id
* @ORM\GeneratedValue(strategy="AUTO")
*/
private $entryID;
/**
* @ORM\Column(name="accountID", type="integer", nullable=false, unique=true)
*/
private $accountID;
/**
* @ORM\Column(name="keyID", type="integer", nullable=false, unique=true)
* @Assert\NotBlank(message="keyID cannot be blank")
*/
private $keyID;
/**
* @ORM\Column(name="vCode", type="string", nullable=false, unique=true)
* @Assert\NotBlank(message="vCode cannot be blank")
*/
private $vCode;
en db
CREATE TABLE IF NOT EXISTS `_apiKey` (
`entryID` int(11) NOT NULL AUTO_INCREMENT,
`accountID` int(11) NOT NULL,
`keyID` int(11) NOT NULL,
`vCode` varchar(255) NOT NULL,
PRIMARY KEY (`entryID`),
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=18 ;
Cuando intento agregar dublicate tengo un error
An exception occurred while executing 'INSERT INTO _apiKey (accountID, keyID, vCode) VALUES (?, ?, ?)' with params {"1":38,"2":"1233","3":"123"}:
SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '38-1233-123' for key 'accountID'
y está bien, pero ¿cómo puedo manejarlo? "Opción de mensaje" no está funcionando@UniqueEntity () ¿Cómo puedo mostrar este error en errores de formulario (sin excepción)
Lo que quiero (ejemplo simple para db sin entryID)
123 123 123 - add
123 123 1234 - add
123 125 123 - add
123 123 1234 - form-error on inserting
123 123 123 - form-error on inserting
234 123 123 - add
234 123 123 - form-error on inserting