Ejemplo n.º 1
0
 public function validate($db, &$row)
 {
     $sql = sprintf('select %s from %s', $this->foreignKeyMapping[0]->foreign, $this->foreignTable);
     $sep = ' where ';
     foreach ($this->foreignKeyMapping as $fkm) {
         $sql .= sprintf('%s%s = ?', $sep, $fkm->foreign);
         if ($sep != ' and ') {
             $sep = ' and ';
         }
     }
     $ps = new PreparedStatement($sql, 0, 1);
     foreach ($this->foreignKeyMapping as $fkm) {
         $vn = $fkm->local;
         $val = property_exists($row, $vn) ? $row->{$vn} : '';
         // If we're set to allow nulls and any value is null, don't validate.
         if ($this->allowNULL && $val === null) {
             return '';
         }
         switch ($fkm->type) {
             case 'int':
                 $ps->setInt($val);
                 break;
             case 'float':
                 $ps->setFloat($val);
                 break;
             case 'double':
                 $ps->setDouble($val);
                 break;
             case 'boolean':
                 $ps->setBoolean($val);
                 break;
             case 'string':
                 $ps->setString($val);
                 break;
             case 'binary':
                 $ps->setBinary($val);
                 break;
             default:
                 throw new Exception(sprintf('Unexpected PreparedStatement data type: %s', $fkm->type));
         }
     }
     if (!$db->fetchObject($db->executeQuery($ps), true)) {
         if ($this->errorMsg != '') {
             return $this->errorMsg;
         }
         return _t('ForeignKeyValidator.class.errorMsg.mustMatchAnExistingEntry');
     }
     return '';
 }
 public function validate($db, &$row)
 {
     $sql = sprintf('select %s from %s', $this->fields[0]->field, $this->table);
     $sep = ' where ';
     foreach ($this->fields as $fld) {
         $qo = $fld->queryOperator;
         if ($qo == 'beginsWith' || $qo == 'contains' || $qo == 'endsWith') {
             $qo = 'like';
         }
         $sql .= sprintf('%s%s %s ?', $sep, $fld->field, $qo);
         if ($sep != ' and ') {
             $sep = ' and ';
         }
     }
     $ps = new PreparedStatement($sql, 0, 1);
     foreach ($this->fields as $fld) {
         $vn = $fld->field;
         $val = property_exists($row, $vn) ? $row->{$vn} : '';
         // If we're set to allow nulls and any value is null, don't validate.
         if ($this->allowNULL && $val === null) {
             return '';
         }
         switch ($fld->type) {
             case 'int':
                 $ps->setInt($val);
                 break;
             case 'float':
                 $ps->setFloat($val);
                 break;
             case 'double':
                 $ps->setDouble($val);
                 break;
             case 'boolean':
                 $ps->setBoolean($val);
                 break;
             case 'string':
                 switch ($fld->queryOperator) {
                     case 'beginsWith':
                         $ps->setString($val . '%');
                         break;
                     case 'contains':
                         $ps->setString('%' . $val . '%');
                         break;
                     case 'endsWith':
                         $ps->setString('%' . $val);
                         break;
                     default:
                         $ps->setString($val);
                         break;
                 }
                 break;
             case 'binary':
                 $ps->setBinary($val);
                 break;
             default:
                 throw new Exception(sprintf('Unexpected PreparedStatement data type: %s', $fld->type));
         }
     }
     if ($db->fetchObject($db->executeQuery($ps), true)) {
         if ($this->errorMsg != '') {
             return $this->errorMsg;
         }
         return _t('NoDuplicatesValidator.class.errorMsg.anEntryAlreadyExistsWithThisValue');
     }
     return '';
 }