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

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

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

Method	Description	Defined 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.

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.

User Contributed Notes