0 follower

CUniqueValidator

Package system.validators
Inheritance class CUniqueValidator » CValidator » CComponent
Since 1.0
Version $Id$
Source Code framework/validators/CUniqueValidator.php
CUniqueValidator validates that the attribute value is unique in the corresponding database table.

Public Properties

Hide inherited properties

PropertyTypeDescriptionDefined 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 array additional query criteria. CUniqueValidator
message string the user-defined error message. CValidator
on array list of scenarios that the validator should be applied. CValidator

Public Methods

Hide inherited methods

MethodDescriptionDefined 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
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
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

Hide inherited methods

MethodDescriptionDefined By
addError() Adds an error about the specified attribute to the active record. CValidator
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 (available since v1.0.8)
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 (available since v1.0.8)
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 (available since v1.0.8)
public array $criteria;

additional query criteria. 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.

Method Details

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#63 (show)
protected function validateAttribute($object,$attribute)
{
    
$value=$object->$attribute;
    if(
$this->allowEmpty && $this->isEmpty($value))
        return;

    
$className=$this->className===null?get_class($object):Yii::import($this->className);
    
$attributeName=$this->attributeName===null?$attribute:$this->attributeName;
    
$finder=CActiveRecord::model($className);
    
$table=$finder->getTableSchema();
    if((
$column=$table->getColumn($attributeName))===null)
        throw new 
CException(Yii::t('yii','Column "{column} does not exist in table "{table}".',
            array(
'{column}'=>$attributeName,'{table}'=>$table->name)));

    
$columnName=$column->rawName;
    
$criteria=new CDbCriteria(array(
        
'condition'=>$this->caseSensitive "$columnName=:value" "LOWER($columnName)=LOWER(:value)",
        
'params'=>array(':value'=>$value),
    ));
    if(
$this->criteria!==array())
        
$criteria->mergeWith($this->criteria);

    if(
$column->isPrimaryKey || $this->className!==null)
        
$exists=$finder->exists($criteria);
    else
    {
        
// need to exclude the current record based on PK
        
$criteria->limit=2;
        
$objects=$finder->findAll($criteria);
        
$n=count($objects);
        if(
$n===1)
            
$exists=$objects[0]->getPrimaryKey()!=$object->getPrimaryKey();
        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.