Example #1
0
 public function validate($value, Constraint $constraint)
 {
     if (!$constraint instanceof UniqueInDb) {
         throw new UnexpectedTypeException($constraint, get_class(new UniqueInDb()));
     }
     /* @var $constraint UniqueInDb */
     $config = $constraint->getDbOptions();
     //        'em'    => $this->container->get('doctrine.orm.entity_manager'),
     //        'table' => 'users',
     //        'field' => 'email'
     $query = "\nSELECT          count(*) c\nFROM            {$config['table']}\nWHERE           {$config['field']} = :value\n";
     $stmt = $config['em']->getConnection()->prepare($query);
     $stmt->bindValue('value', $value);
     $stmt->execute();
     $c = 1;
     if ($row = $stmt->fetch(PDO::FETCH_ASSOC)) {
         $c = (int) $row['c'];
     }
     if ($c) {
         $this->buildViolation($constraint->message)->setParameter('{{ unique }}', $value)->setInvalidValue($value)->setCode(UniqueInDb::NOT_UNIQUE)->addViolation();
     }
 }