API Documentation for Yii 1.1
0 follower
CUniqueValidator
| Package | system.validators |
|---|---|
| Inheritance | class CUniqueValidator » CValidator » CComponent |
| Since | 1.0 |
| Source Code | framework/validators/CUniqueValidator.php |
CUniqueValidator validates that the attribute value is unique in the corresponding database table.
When using the message property to define a custom error message, the message may contain additional placeholders that will be replaced with the actual content. In addition to the "{attribute}" placeholder, recognized by all validators (see CValidator), CUniqueValidator allows for the following placeholders to be specified:
When using the message property to define a custom error message, the message may contain additional placeholders that will be replaced with the actual content. In addition to the "{attribute}" placeholder, recognized by all validators (see CValidator), CUniqueValidator allows for the following placeholders to be specified:
- {value}: replaced with current value of the attribute.
Public Properties
| Property | Type | Description | Defined By |
|---|---|---|---|
| allowEmpty | boolean | whether the attribute value can be null or empty. | CUniqueValidator |
| attributeName | string | the ActiveRecord class attribute name that should be used to look for the attribute value being validated. | CUniqueValidator |
| attributes | array | list of attributes to be validated. | CValidator |
| builtInValidators | array | list of built-in validators (name=>class) | CValidator |
| caseSensitive | boolean | whether the comparison is case sensitive. | CUniqueValidator |
| className | string | the ActiveRecord class name that should be used to look for the attribute value being validated. | CUniqueValidator |
| criteria | mixed | additional query criteria. | CUniqueValidator |
| enableClientValidation | boolean | whether to perform client-side validation. | CValidator |
| except | array | list of scenarios that the validator should not be applied to. | CValidator |
| message | string | the user-defined error message. | CUniqueValidator |
| on | array | list of scenarios that the validator should be applied. | CValidator |
| safe | boolean | whether attributes listed with this validator should be considered safe for massive assignment. | CValidator |
| skipOnError | boolean | whether this validation rule should be skipped if when there is already a validation error for the current attribute. | CUniqueValidator |
Public Methods
| Method | Description | Defined By |
|---|---|---|
| __call() | Calls the named method which is not a class method. | CComponent |
| __get() | Returns a property value, an event handler list or a behavior based on its name. | CComponent |
| __isset() | Checks if a property value is null. | CComponent |
| __set() | Sets value of a component property. | CComponent |
| __unset() | Sets a component property to be null. | CComponent |
| applyTo() | Returns a value indicating whether the validator applies to the specified scenario. | CValidator |
| asa() | Returns the named behavior object. | CComponent |
| attachBehavior() | Attaches a behavior to this component. | CComponent |
| attachBehaviors() | Attaches a list of behaviors to the component. | CComponent |
| attachEventHandler() | Attaches an event handler to an event. | CComponent |
| canGetProperty() | Determines whether a property can be read. | CComponent |
| canSetProperty() | Determines whether a property can be set. | CComponent |
| clientValidateAttribute() | Returns the JavaScript needed for performing client-side validation. | CValidator |
| createValidator() | Creates a validator object. | CValidator |
| detachBehavior() | Detaches a behavior from the component. | CComponent |
| detachBehaviors() | Detaches all behaviors from the component. | CComponent |
| detachEventHandler() | Detaches an existing event handler. | CComponent |
| disableBehavior() | Disables an attached behavior. | CComponent |
| disableBehaviors() | Disables all behaviors attached to this component. | CComponent |
| enableBehavior() | Enables an attached behavior. | CComponent |
| enableBehaviors() | Enables all behaviors attached to this component. | CComponent |
| evaluateExpression() | Evaluates a PHP expression or callback under the context of this component. | CComponent |
| getEventHandlers() | Returns the list of attached event handlers for an event. | CComponent |
| hasEvent() | Determines whether an event is defined. | CComponent |
| hasEventHandler() | Checks whether the named event has attached handlers. | CComponent |
| hasProperty() | Determines whether a property is defined. | CComponent |
| raiseEvent() | Raises an event. | CComponent |
| validate() | Validates the specified object. | CValidator |
Protected Methods
| Method | Description | Defined By |
|---|---|---|
| addError() | Adds an error about the specified attribute to the active record. | CValidator |
| getModel() | Given active record class name returns new model instance. | CUniqueValidator |
| isEmpty() | Checks if the given value is empty. | CValidator |
| validateAttribute() | Validates the attribute of the object. | CUniqueValidator |
Property Details
allowEmpty
property
public boolean $allowEmpty;
whether the attribute value can be null or empty. Defaults to true, meaning that if the attribute is empty, it is considered valid.
attributeName
property
public string $attributeName;
the ActiveRecord class attribute name that should be used to look for the attribute value being validated. Defaults to null, meaning using the name of the attribute being validated.
See Also
caseSensitive
property
public boolean $caseSensitive;
whether the comparison is case sensitive. Defaults to true. Note, by setting it to false, you are assuming the attribute type is string.
className
property
public string $className;
the ActiveRecord class name that should be used to look for the attribute value being validated. Defaults to null, meaning using the class of the object currently being validated. You may use path alias to reference a class name here.
See Also
criteria
property
public mixed $criteria;
additional query criteria. Either an array or CDbCriteria. This will be combined with the condition that checks if the attribute value exists in the corresponding table column. This array will be used to instantiate a CDbCriteria object.
message
property
public string $message;
the user-defined error message. The placeholders "{attribute}" and "{value}" are recognized, which will be replaced with the actual attribute name and value, respectively.
skipOnError
property
(available since v1.1.1)
public boolean $skipOnError;
whether this validation rule should be skipped if when there is already a validation error for the current attribute. Defaults to true.
Method Details
getModel()
method
(available since v1.1.14)
|
protected CActiveRecord getModel(string $className)
| ||
| $className | string | active record class name. |
| {return} | CActiveRecord | active record model instance. |
Source Code: framework/validators/CUniqueValidator.php#146 (show)
protected function getModel($className)
{
return CActiveRecord::model($className);
}
Given active record class name returns new model instance.
validateAttribute()
method
|
protected void validateAttribute(CModel $object, string $attribute)
| ||
| $object | CModel | the object being validated |
| $attribute | string | the attribute being validated |
Source Code: framework/validators/CUniqueValidator.php#80 (show)
protected function validateAttribute($object,$attribute)
{
$value=$object->$attribute;
if($this->allowEmpty && $this->isEmpty($value))
return;
if(is_array($value))
{
// https://github.com/yiisoft/yii/issues/1955
$this->addError($object,$attribute,Yii::t('yii','{attribute} is invalid.'));
return;
}
$className=$this->className===null?get_class($object):Yii::import($this->className);
$attributeName=$this->attributeName===null?$attribute:$this->attributeName;
$finder=$this->getModel($className);
$table=$finder->getTableSchema();
if(($column=$table->getColumn($attributeName))===null)
throw new CException(Yii::t('yii','Table "{table}" does not have a column named "{column}".',
array('{column}'=>$attributeName,'{table}'=>$table->name)));
$columnName=$column->rawName;
$criteria=new CDbCriteria();
if($this->criteria!==array())
$criteria->mergeWith($this->criteria);
$tableAlias = empty($criteria->alias) ? $finder->getTableAlias(true) : $criteria->alias;
$valueParamName = CDbCriteria::PARAM_PREFIX.CDbCriteria::$paramCount++;
$criteria->addCondition($this->caseSensitive ? "{$tableAlias}.{$columnName}={$valueParamName}" : "LOWER({$tableAlias}.{$columnName})=LOWER({$valueParamName})");
$criteria->params[$valueParamName] = $value;
if(!$object instanceof CActiveRecord || $object->isNewRecord || $object->tableName()!==$finder->tableName())
$exists=$finder->exists($criteria);
else
{
$criteria->limit=2;
$objects=$finder->findAll($criteria);
$n=count($objects);
if($n===1)
{
if($column->isPrimaryKey) // primary key is modified and not unique
$exists=$object->getOldPrimaryKey()!=$object->getPrimaryKey();
else
{
// non-primary key, need to exclude the current record based on PK
$exists=array_shift($objects)->getPrimaryKey()!=$object->getOldPrimaryKey();
}
}
else
$exists=$n>1;
}
if($exists)
{
$message=$this->message!==null?$this->message:Yii::t('yii','{attribute} "{value}" has already been taken.');
$this->addError($object,$attribute,$message,array('{value}'=>$value));
}
}
Validates the attribute of the object. If there is any error, the error message is added to the object.
Check in many tables
You can check the attribute to be unique in many tables. I have an attribute called idPerfil to generate urls like:
arenalesvive.com.ar/my.company
arenalesvive.com.ar/paul.vity
class PerfilEmpresa extends Perfil{ public function rules(){ array('idPerfil', 'unique', 'className'=> 'PerfilEmpresa'), array('idPerfil', 'unique', 'className'=> 'PerfilPersona'), } } class PerfilPersona extends Perfil{ public function rules(){ array('idPerfil', 'unique', 'className'=> 'PerfilEmpresa'), array('idPerfil', 'unique', 'className'=> 'PerfilPersona'), } }cFormModel
If you have cFormModel return error: xy and its behaviors do not have a method or closure named "getDbConnection". You can specify model class in unique array and problem slove.
public function rules() { return array ( array('email','required'), array('email','email'), array('email','unique', 'className' => 'Users'), array('email','length','min'=>3,"max"=>32), ); }Validation rules issues when using model's attribute as additional parameters
You may get into trouble when using model's attributes as additional parameters for validators. Take a look at: https://github.com/yiisoft/yii/issues/3001
<?php class MyCFormModel extends CFormModel { public function validate($attributes = null, $clearErrors = true, $recreateValidators = true) { if ($clearErrors) $this->clearErrors(); if ($this->beforeValidate()) { foreach ($this->getValidators(null,$recreateValidators) as $validator) $validator->validate($this, $attributes); $this->afterValidate(); return !$this->hasErrors(); } else return false; } public function getValidators($attribute = null, $recreateValidators = false) { if (parent::getValidators() === null || $recreateValidators) { $_validators = $this->createValidators(); } else $_validators = parent::getValidators(); $validators = array(); $scenario = $this->getScenario(); foreach ($_validators as $validator) { if ($validator->applyTo($scenario)) { if ($attribute === null || in_array($attribute, $validator->attributes, true)) $validators[] = $validator; } } return $validators; } } ?>Signup or Login in order to comment.