CActiveRecord

Package	system.db.ar
Inheritance	abstract class CActiveRecord » CModel » CComponent
Implements	Traversable, ArrayAccess, IteratorAggregate
Since	1.0
Source Code	framework/db/ar/CActiveRecord.php

Property Details

Returns all column attribute values. Note, related objects are not returned.

Returns the command builder used by this AR.

the default database connection for all active record classes. By default, this is the 'db' application component.

Returns the database connection used by active record. By default, the "db" application component is used as the database connection. You may override this method if you want to use a different database connection.

Returns the query criteria associated with this model.

Returns if the current record is new (was never saved to database)

Returns the meta-data for this AR

Returns the old primary key value. This refers to the primary key value that is populated into the record after executing a find method (e.g. find(), findAll()). The value remains unchanged even if the primary key attribute is manually assigned with a different value.

Returns the primary key value.

Returns the table alias to be used by the find methods. In relational queries, the returned table alias may vary according to the corresponding relation declaration. Also, the default table alias set by setTableAlias may be overridden by the applied scopes.

Returns the metadata of the table that this AR belongs to

Method Details

public mixed __call(string $name, array $parameters)
$name	string	the method name
$parameters	array	method parameters
{return}	mixed	the method return value

Calls the named method which is not a class method. Do not call this method. This is a PHP magic method that we override to implement the named scope feature.

public void __construct(string $scenario='insert')
$scenario	string	scenario name. See CModel::scenario for more details about this parameter. Note: in order to setup initial model parameters use init() or afterConstruct(). Do NOT override the constructor unless it is absolutely necessary!

Constructor.

public mixed __get(string $name)
$name	string	property name
{return}	mixed	property value

PHP getter magic method. This method is overridden so that AR attributes can be accessed like properties.

public boolean __isset(string $name)
$name	string	the property name or the event name
{return}	boolean	whether the property value is null

Checks if a property value is null. This method overrides the parent implementation by checking if the named attribute is null or not.

public void __set(string $name, mixed $value)
$name	string	property name
$value	mixed	property value

PHP setter magic method. This method is overridden so that AR attributes can be accessed like properties.

public array __sleep()
{return}	array

PHP sleep magic method. This method ensures that the model meta data reference is set to null.

public void __unset(string $name)
$name	string	the property name or the event name

Sets a component property to be null. This method overrides the parent implementation by clearing the specified attribute value.

public void addRelatedRecord(string $name, mixed $record, mixed $index)
$name	string	attribute name
$record	mixed	the related record
$index	mixed	the index value in the related object collection. If true, it means using zero-based integer index. If false, it means a HAS_ONE or BELONGS_TO object and no index is needed.

Do not call this method. This method is used internally by CActiveFinder to populate related objects. This method adds a related object to this record.

protected void afterDelete()

This method is invoked after deleting a record. The default implementation raises the onAfterDelete event. You may override this method to do postprocessing after the record is deleted. Make sure you call the parent implementation so that the event is raised properly.

protected void afterFind()

This method is invoked after each record is instantiated by a find method. The default implementation raises the onAfterFind event. You may override this method to do postprocessing after each newly found record is instantiated. Make sure you call the parent implementation so that the event is raised properly.

public void afterFindInternal()

Calls afterFind. This method is internally used.

protected void afterSave()

This method is invoked after saving a record successfully. The default implementation raises the onAfterSave event. You may override this method to do postprocessing after record saving. Make sure you call the parent implementation so that the event is raised properly.

public void applyScopes(CDbCriteria &$criteria)
$criteria	CDbCriteria	the query criteria. This parameter may be modified by merging dbCriteria.

Applies the query scopes to the given criteria. This method merges dbCriteria with the given criteria parameter. It then resets dbCriteria to be null.

public array attributeNames()
{return}	array	list of attribute names.

Returns the list of all attribute names of the model. This would return all column names of the table associated with this AR class.

protected void beforeCount()

This method is invoked before an AR finder executes a count call. The count calls include count and countByAttributes The default implementation raises the onBeforeCount event. If you override this method, make sure you call the parent implementation so that the event is raised properly.

protected boolean beforeDelete()
{return}	boolean	whether the record should be deleted. Defaults to true.

This method is invoked before deleting a record. The default implementation raises the onBeforeDelete event. You may override this method to do any preparation work for record deletion. Make sure you call the parent implementation so that the event is raised properly.

protected void beforeFind()

This method is invoked before an AR finder executes a find call. The find calls include find, findAll, findByPk, findAllByPk, findByAttributes, findAllByAttributes, findBySql and findAllBySql. The default implementation raises the onBeforeFind event. If you override this method, make sure you call the parent implementation so that the event is raised properly. For details on modifying query criteria see onBeforeFind event.

public void beforeFindInternal()

Calls beforeFind. This method is internally used.

protected boolean beforeSave()
{return}	boolean	whether the saving should be executed. Defaults to true.

This method is invoked before saving a record (after validation, if any). The default implementation raises the onBeforeSave event. You may override this method to do any preparation work for record saving. Use isNewRecord to determine whether the saving is for inserting or updating record. Make sure you call the parent implementation so that the event is raised properly.

public static cache(integer $duration, CCacheDependency|ICacheDependency $dependency=NULL, integer $queryCount=1)
$duration	integer	the number of seconds that query results may remain valid in cache. If this is 0, the caching will be disabled.
$dependency	CCacheDependency|ICacheDependency	the dependency that will be used when saving the query results into cache.
$queryCount	integer	number of SQL queries that need to be cached after calling this method. Defaults to 1, meaning that the next SQL query will be cached.
{return}	static	the active record instance itself.

Sets the parameters about query caching. This is a shortcut method to CDbConnection::cache(). It changes the query caching parameter of the dbConnection instance.

public string count(mixed $condition='', array $params=array ( ))
$condition	mixed	query condition or criteria.
$params	array	parameters to be bound to an SQL statement.
{return}	string	the number of rows satisfying the specified query condition. Note: type is string to keep max. precision.

Finds the number of rows satisfying the specified query condition. See find() for detailed explanation about $condition and $params.

public string countByAttributes(array $attributes, mixed $condition='', array $params=array ( ))
$attributes	array	list of attribute values (indexed by attribute names) that the active records should match. An attribute value can be an array which will be used to generate an IN condition.
$condition	mixed	query condition or criteria.
$params	array	parameters to be bound to an SQL statement.
{return}	string	the number of rows satisfying the specified query condition. Note: type is string to keep max. precision.

Finds the number of rows that have the specified attribute values. See find() for detailed explanation about $condition and $params.

public string countBySql(string $sql, array $params=array ( ))
$sql	string	the SQL statement
$params	array	parameters to be bound to the SQL statement
{return}	string	the number of rows using the given SQL statement. Note: type is string to keep max. precision.

Finds the number of rows using the given SQL statement. This is equivalent to calling CDbCommand::queryScalar with the specified SQL statement and the parameters.

public array defaultScope()
{return}	array	the query criteria. This will be used as the parameter to the constructor of CDbCriteria.

Returns the default named scope that should be implicitly applied to all queries for this model. Note, default scope only applies to SELECT queries. It is ignored for INSERT, UPDATE and DELETE queries. The default implementation simply returns an empty array. You may override this method if the model needs to be queried with some default criteria (e.g. only active records should be returned).

public boolean delete()
{return}	boolean	whether the deletion is successful.

Deletes the row corresponding to this active record.

public integer deleteAll(mixed $condition='', array $params=array ( ))
$condition	mixed	query condition or criteria.
$params	array	parameters to be bound to an SQL statement.
{return}	integer	the number of rows deleted

Deletes rows with the specified condition. See find() for detailed explanation about $condition and $params.

public integer deleteAllByAttributes(array $attributes, mixed $condition='', array $params=array ( ))
$attributes	array	list of attribute values (indexed by attribute names) that the active records should match. An attribute value can be an array which will be used to generate an IN condition.
$condition	mixed	query condition or criteria.
$params	array	parameters to be bound to an SQL statement.
{return}	integer	number of rows affected by the execution.

Deletes rows which match the specified attribute values. See find() for detailed explanation about $condition and $params.

public integer deleteByPk(mixed $pk, mixed $condition='', array $params=array ( ))
$pk	mixed	primary key value(s). Use array for multiple primary keys. For composite key, each key value must be an array (column name=>column value).
$condition	mixed	query condition or criteria.
$params	array	parameters to be bound to an SQL statement.
{return}	integer	the number of rows deleted

Deletes rows with the specified primary key. See find() for detailed explanation about $condition and $params.

public boolean equals(CActiveRecord $record)
$record	CActiveRecord	record to compare to
{return}	boolean	whether the two active records refer to the same row in the database table.

Compares current active record with another one. The comparison is made by comparing table name and the primary key values of the two active records.

public boolean exists(mixed $condition='', array $params=array ( ))
$condition	mixed	query condition or criteria.
$params	array	parameters to be bound to an SQL statement.
{return}	boolean	whether there is row satisfying the specified condition.

Checks whether there is row satisfying the specified condition. See find() for detailed explanation about $condition and $params.

public static|null find(mixed $condition='', array $params=array ( ))
$condition	mixed	query condition or criteria. If a string, it is treated as query condition (the WHERE clause); If an array, it is treated as the initial values for constructing a CDbCriteria object; Otherwise, it should be an instance of CDbCriteria.
$params	array	parameters to be bound to an SQL statement. This is only used when the first parameter is a string (query condition). In other cases, please use CDbCriteria::params to set parameters.
{return}	static|null	the record found. Null if no record is found.

Finds a single active record with the specified condition.

public static[] findAll(mixed $condition='', array $params=array ( ))
$condition	mixed	query condition or criteria.
$params	array	parameters to be bound to an SQL statement.
{return}	static[]	list of active records satisfying the specified condition. An empty array is returned if none is found.

Finds all active records satisfying the specified condition. See find() for detailed explanation about $condition and $params.

public static[] findAllByAttributes(array $attributes, mixed $condition='', array $params=array ( ))
$attributes	array	list of attribute values (indexed by attribute names) that the active records should match. An attribute value can be an array which will be used to generate an IN condition.
$condition	mixed	query condition or criteria.
$params	array	parameters to be bound to an SQL statement.
{return}	static[]	the records found. An empty array is returned if none is found.

Finds all active records that have the specified attribute values. See find() for detailed explanation about $condition and $params.

public static[] findAllByPk(mixed $pk, mixed $condition='', array $params=array ( ))
$pk	mixed	primary key value(s). Use array for multiple primary keys. For composite key, each key value must be an array (column name=>column value).
$condition	mixed	query condition or criteria.
$params	array	parameters to be bound to an SQL statement.
{return}	static[]	the records found. An empty array is returned if none is found.

Finds all active records with the specified primary keys. See find() for detailed explanation about $condition and $params.

public static[] findAllBySql(string $sql, array $params=array ( ))
$sql	string	the SQL statement
$params	array	parameters to be bound to the SQL statement
{return}	static[]	the records found. An empty array is returned if none is found.

Finds all active records using the specified SQL statement.

public static|null findByAttributes(array $attributes, mixed $condition='', array $params=array ( ))
$attributes	array	list of attribute values (indexed by attribute names) that the active records should match. An attribute value can be an array which will be used to generate an IN condition.
$condition	mixed	query condition or criteria.
$params	array	parameters to be bound to an SQL statement.
{return}	static|null	the record found. Null if none is found.

Finds a single active record that has the specified attribute values. See find() for detailed explanation about $condition and $params.

public static|null findByPk(mixed $pk, mixed $condition='', array $params=array ( ))
$pk	mixed	primary key value(s). Use array for multiple primary keys. For composite key, each key value must be an array (column name=>column value).
$condition	mixed	query condition or criteria.
$params	array	parameters to be bound to an SQL statement.
{return}	static|null	the record found. Null if none is found.

Finds a single active record with the specified primary key. See find() for detailed explanation about $condition and $params.

public static|null findBySql(string $sql, array $params=array ( ))
$sql	string	the SQL statement
$params	array	parameters to be bound to the SQL statement
{return}	static|null	the record found. Null if none is found.

Finds a single active record with the specified SQL statement.

public CActiveFinder getActiveFinder(mixed $with)
$with	mixed	the relation names to be actively looked for
{return}	CActiveFinder	active finder for the operation

Given 'with' options returns a new active finder instance.

public CActiveRelation getActiveRelation(string $name)
$name	string	the relation name
{return}	CActiveRelation	the named relation declared for this AR class. Null if the relation does not exist.

Returns the named relation declared for this AR class.

public mixed getAttribute(string $name)
$name	string	the attribute name
{return}	mixed	the attribute value. Null if the attribute is not set or does not exist.

Returns the named attribute value. If this is a new record and the attribute is not set before, the default column value will be returned. If this record is the result of a query and the attribute is not loaded, null will be returned. You may also use $this->AttributeName to obtain the attribute value.

public string getAttributeLabel(string $attribute)
$attribute	string	the attribute name
{return}	string	the attribute label

Returns the text label for the specified attribute. This method overrides the parent implementation by supporting returning the label defined in relational object. In particular, if the attribute name is in the form of "post.author.name", then this method will derive the label from the "author" relation's "name" attribute.

public array getAttributes(mixed $names=true)
$names	mixed	names of attributes whose value needs to be returned. If this is true (default), then all attribute values will be returned, including those that are not loaded from DB (null will be returned for those attributes). If this is null, all attributes except those that are not loaded from DB will be returned.
{return}	array	attribute values indexed by attribute names.

Returns all column attribute values. Note, related objects are not returned.

public CDbCommandBuilder getCommandBuilder()
{return}	CDbCommandBuilder	the command builder used by this AR

Returns the command builder used by this AR.

public CDbConnection getDbConnection()
{return}	CDbConnection	the database connection used by active record.

Returns the database connection used by active record. By default, the "db" application component is used as the database connection. You may override this method if you want to use a different database connection.

public CDbCriteria getDbCriteria(boolean $createIfNull=true)
$createIfNull	boolean	whether to create a criteria instance if it does not exist. Defaults to true.
{return}	CDbCriteria	the query criteria that is associated with this model. This criteria is mainly used by named scope feature to accumulate different criteria specifications.

Returns the query criteria associated with this model.

public boolean getIsNewRecord()
{return}	boolean	whether the record is new and should be inserted when calling save. This property is automatically set in constructor and populateRecord and is set to false right after inserting record to database. Defaults to false, but it will be set to true if the instance is created using the new operator.

Returns if the current record is new (was never saved to database)

public CActiveRecordMetaData getMetaData()
{return}	CActiveRecordMetaData	the meta for this AR class.

Returns the meta-data for this AR

public mixed getOldPrimaryKey()
{return}	mixed	the old primary key value. An array (column name=>column value) is returned if the primary key is composite. If primary key is not defined, null will be returned.

Returns the old primary key value. This refers to the primary key value that is populated into the record after executing a find method (e.g. find(), findAll()). The value remains unchanged even if the primary key attribute is manually assigned with a different value.

public mixed getPrimaryKey()
{return}	mixed	the primary key value. An array (column name=>column value) is returned if the primary key is composite. If primary key is not defined, null will be returned.

Returns the primary key value.

public mixed getRelated(string $name, boolean $refresh=false, mixed $params=array ( ))
$name	string	the relation name (see relations)
$refresh	boolean	whether to reload the related objects from database. Defaults to false. If the current record is not a new record and it does not have the related objects loaded they will be retrieved from the database even if this is set to false. If the current record is a new record and this value is false, the related objects will not be retrieved from the database.
$params	mixed	array or CDbCriteria object with additional parameters that customize the query conditions as specified in the relation declaration. If this is supplied the related record(s) will be retrieved from the database regardless of the value or $refresh. The related record(s) retrieved when this is supplied will only be returned by this method and will not be loaded into the current record's relation. The value of the relation prior to running this method will still be available for the current record if this is supplied.
{return}	mixed	the related object(s).

Returns the related record(s). This method will return the related record(s) of the current record. If the relation is HAS_ONE or BELONGS_TO, it will return a single object or null if the object does not exist. If the relation is HAS_MANY or MANY_MANY, it will return an array of objects or an empty array.

public string getTableAlias(boolean $quote=false, boolean $checkScopes=true)
$quote	boolean	whether to quote the alias name
$checkScopes	boolean	whether to check if a table alias is defined in the applied scopes so far. This parameter must be set false when calling this method in defaultScope. An infinite loop would be formed otherwise.
{return}	string	the default table alias

Returns the table alias to be used by the find methods. In relational queries, the returned table alias may vary according to the corresponding relation declaration. Also, the default table alias set by setTableAlias may be overridden by the applied scopes.

public CDbTableSchema getTableSchema()
{return}	CDbTableSchema	the metadata of the table that this AR belongs to

Returns the metadata of the table that this AR belongs to

public boolean hasAttribute(string $name)
$name	string	attribute name
{return}	boolean	whether this AR has the named attribute (table column).

Checks whether this AR has the named attribute

public boolean hasRelated(string $name)
$name	string	the relation name
{return}	boolean	a value indicating whether the named related object(s) has been loaded.

Returns a value indicating whether the named related object(s) has been loaded.

public void init()

Initializes this model. This method is invoked when an AR instance is newly created and has its scenario set. You may override this method to provide code that is needed to initialize the model (e.g. setting initial property values.)

public boolean insert(array $attributes=NULL)
$attributes	array	list of attributes that need to be saved. Defaults to null, meaning all attributes that are loaded from DB will be saved.
{return}	boolean	whether the attributes are valid and the record is inserted successfully.

Inserts a row into the table based on this active record attributes. If the table's primary key is auto-incremental and is null before insertion, it will be populated with the actual value after insertion. Note, validation is not performed in this method. You may call validate to perform the validation. After the record is inserted to DB successfully, its isNewRecord property will be set false, and its scenario property will be set to be 'update'.

protected static instantiate(array $attributes)
$attributes	array	list of attribute values for the active records.
{return}	static	the active record

Creates an active record instance. This method is called by populateRecord and populateRecords. You may override this method if the instance being created depends the attributes that are to be populated to the record. For example, by creating a record based on the value of a column, you may implement the so-called single-table inheritance mapping.

public static static model(string $className='CActiveRecord')
$className	string	active record class name.
{return}	static	active record model instance.

Returns the static model of the specified AR class. The model returned is a static instance of the AR class. It is provided for invoking class-level methods (something similar to static class methods.)

EVERY derived AR class must override this method as follows,

public static function model($className=__CLASS__)
{
    return parent::model($className);
}

public boolean offsetExists(mixed $offset)
$offset	mixed	the offset to check on
{return}	boolean

Returns whether there is an element at the specified offset. This method is required by the interface ArrayAccess.

public void onAfterDelete(CEvent $event)
$event	CEvent	the event parameter

This event is raised after the record is deleted.

public void onAfterFind(CEvent $event)
$event	CEvent	the event parameter

This event is raised after the record is instantiated by a find method.

public void onAfterSave(CEvent $event)
$event	CEvent	the event parameter

This event is raised after the record is saved.

public void onBeforeCount(CModelEvent $event)
$event	CModelEvent	the event parameter

This event is raised before an AR finder performs a count call. If you want to access or modify the query criteria used for the count call, you can use getDbCriteria() to customize it based on your needs. When modifying criteria in beforeCount you have to make sure you are using the right table alias which is different on normal count and relational call. You can use getTableAlias() to get the alias used for the upcoming count call.

public void onBeforeDelete(CModelEvent $event)
$event	CModelEvent	the event parameter

This event is raised before the record is deleted. By setting CModelEvent::isValid to be false, the normal delete() process will be stopped.

public void onBeforeFind(CModelEvent $event)
$event	CModelEvent	the event parameter

This event is raised before an AR finder performs a find call. This can be either a call to CActiveRecords find methods or a find call when model is loaded in relational context via lazy or eager loading. If you want to access or modify the query criteria used for the find call, you can use getDbCriteria() to customize it based on your needs. When modifying criteria in beforeFind you have to make sure you are using the right table alias which is different on normal find and relational call. You can use getTableAlias() to get the alias used for the upcoming find call. Please note that modification of criteria is fully supported as of version 1.1.13. Earlier versions had some problems with relational context and applying changes correctly.

public void onBeforeSave(CModelEvent $event)
$event	CModelEvent	the event parameter

This event is raised before the record is saved. By setting CModelEvent::isValid to be false, the normal save() process will be stopped.

public static|null populateRecord(array $attributes, boolean $callAfterFind=true)
$attributes	array	attribute values (column name=>column value)
$callAfterFind	boolean	whether to call afterFind after the record is populated.
{return}	static|null	the newly created active record. The class of the object is the same as the model class. Null is returned if the input data is false.

Creates an active record with the given attributes. This method is internally used by the find methods.

public static[] populateRecords(array $data, boolean $callAfterFind=true, string $index=NULL)
$data	array	list of attribute values for the active records.
$callAfterFind	boolean	whether to call afterFind after each record is populated.
$index	string	the name of the attribute whose value will be used as indexes of the query result array. If null, it means the array will be indexed by zero-based integers.
{return}	static[]	list of active records.

Creates a list of active records based on the input data. This method is internally used by the find methods.

public mixed primaryKey()
{return}	mixed	the primary key of the associated database table. If the key is a single column, it should return the column name; If the key is a composite one consisting of several columns, it should return the array of the key column names.

Returns the primary key of the associated database table. This method is meant to be overridden in case when the table is not defined with a primary key (for some legency database). If the table is already defined with a primary key, you do not need to override this method. The default implementation simply returns null, meaning using the primary key defined in the database.

protected mixed query(CDbCriteria $criteria, boolean $all=false)
$criteria	CDbCriteria	the query criteria
$all	boolean	whether to return all data
{return}	mixed	the AR objects populated with the query result

Performs the actual DB query and populates the AR objects with the query result. This method is mainly internally used by other AR query methods.

public boolean refresh()
{return}	boolean	whether the row still exists in the database. If true, the latest data will be populated to this active record.

Repopulates this active record with the latest data.

public void refreshMetaData()

Refreshes the meta data for this AR class. By calling this method, this AR class will regenerate the meta data needed. This is useful if the table schema has been changed and you want to use the latest available table schema. Make sure you have called CDbSchema::refresh before you call this method. Otherwise, old table schema data will still be used.

public array relations()
{return}	array	list of related object declarations. Defaults to empty array.

This method should be overridden to declare related objects.

There are four types of relations that may exist between two active record objects:

• BELONGS_TO: e.g. a member belongs to a team;
• HAS_ONE: e.g. a member has at most one profile;
• HAS_MANY: e.g. a team has many members;
• MANY_MANY: e.g. a member has many skills and a skill belongs to a member.

Besides the above relation types, a special relation called STAT is also supported that can be used to perform statistical query (or aggregational query). It retrieves the aggregational information about the related objects, such as the number of comments for each post, the average rating for each product, etc.

Each kind of related objects is defined in this method as an array with the following elements:

'varName'=>array('relationType', 'className', 'foreignKey', ...additional options)

where 'varName' refers to the name of the variable/property that the related object(s) can be accessed through; 'relationType' refers to the type of the relation, which can be one of the following four constants: self::BELONGS_TO, self::HAS_ONE, self::HAS_MANY and self::MANY_MANY; 'className' refers to the name of the active record class that the related object(s) is of; and 'foreignKey' states the foreign key that relates the two kinds of active record. Note, for composite foreign keys, they can be either listed together, separated by commas or specified as an array in format of array('key1','key2'). In case you need to specify custom PK->FK association you can define it as array('fk'=>'pk'). For composite keys it will be array('fk_c1'=>'pk_с1','fk_c2'=>'pk_c2'). For foreign keys used in MANY_MANY relation, the joining table must be declared as well (e.g. 'join_table(fk1, fk2)').

Additional options may be specified as name-value pairs in the rest array elements:

• 'select': string|array, a list of columns to be selected. Defaults to '*', meaning all columns. Column names should be disambiguated if they appear in an expression (e.g. COUNT(relationName.name) AS name_count).
• 'condition': string, the WHERE clause. Defaults to empty. Note, column references need to be disambiguated with prefix 'relationName.' (e.g. relationName.age>20)
• 'order': string, the ORDER BY clause. Defaults to empty. Note, column references need to be disambiguated with prefix 'relationName.' (e.g. relationName.age DESC)
• 'with': string|array, a list of child related objects that should be loaded together with this object. Note, this is only honored by lazy loading, not eager loading.
• 'joinType': type of join. Defaults to 'LEFT OUTER JOIN'.
• 'alias': the alias for the table associated with this relationship. It defaults to null, meaning the table alias is the same as the relation name.
• 'params': the parameters to be bound to the generated SQL statement. This should be given as an array of name-value pairs.
• 'on': the ON clause. The condition specified here will be appended to the joining condition using the AND operator.
• 'index': the name of the column whose values should be used as keys of the array that stores related objects. This option is only available to HAS_MANY and MANY_MANY relations.
• 'scopes': scopes to apply. In case of a single scope can be used like 'scopes'=>'scopeName', in case of multiple scopes can be used like 'scopes'=>array('scopeName1','scopeName2'). This option has been available since version 1.1.9.

The following options are available for certain relations when lazy loading:

• 'group': string, the GROUP BY clause. Defaults to empty. Note, column references need to be disambiguated with prefix 'relationName.' (e.g. relationName.age). This option only applies to HAS_MANY and MANY_MANY relations.
• 'having': string, the HAVING clause. Defaults to empty. Note, column references need to be disambiguated with prefix 'relationName.' (e.g. relationName.age). This option only applies to HAS_MANY and MANY_MANY relations.
• 'limit': limit of the rows to be selected. This option does not apply to BELONGS_TO relation.
• 'offset': offset of the rows to be selected. This option does not apply to BELONGS_TO relation.
• 'through': name of the model's relation that will be used as a bridge when getting related data. Can be set only for HAS_ONE and HAS_MANY. This option has been available since version 1.1.7.

Below is an example declaring related objects for 'Post' active record class:

return array(
    'author'=>array(self::BELONGS_TO, 'User', 'author_id'),
    'comments'=>array(self::HAS_MANY, 'Comment', 'post_id', 'with'=>'author', 'order'=>'create_time DESC'),
    'tags'=>array(self::MANY_MANY, 'Tag', 'post_tag(post_id, tag_id)', 'order'=>'name'),
);

public static resetScope(boolean $resetDefault=true)
$resetDefault	boolean	including default scope. This parameter available since 1.1.12
{return}	static	the AR instance itself

Resets all scopes and criterias applied.

public boolean save(boolean $runValidation=true, array $attributes=NULL)
$runValidation	boolean	whether to perform validation before saving the record. If the validation fails, the record will not be saved to database.
$attributes	array	list of attributes that need to be saved. Defaults to null, meaning all attributes that are loaded from DB will be saved.
{return}	boolean	whether the saving succeeds

Saves the current record.

The record is inserted as a row into the database table if its isNewRecord property is true (usually the case when the record is created using the 'new' operator). Otherwise, it will be used to update the corresponding row in the table (usually the case if the record is obtained using one of those 'find' methods.)

Validation will be performed before saving the record. If the validation fails, the record will not be saved. You can call getErrors() to retrieve the validation errors.

If the record is saved via insertion, its isNewRecord property will be set false, and its scenario property will be set to be 'update'. And if its primary key is auto-incremental and is not set before insertion, the primary key will be populated with the automatically generated key value.

public boolean saveAttributes(array $attributes)
$attributes	array	attributes to be updated. Each element represents an attribute name or an attribute value indexed by its name. If the latter, the record's attribute will be changed accordingly before saving.
{return}	boolean	whether the update is successful. Note that false is also returned if the saving was successfull but no attributes had changed and the database driver returns 0 for the number of updated records.

Saves a selected list of attributes. Unlike save, this method only saves the specified attributes of an existing row dataset and does NOT call either beforeSave or afterSave. Also note that this method does neither attribute filtering nor validation. So do not use this method with untrusted data (such as user posted data). You may consider the following alternative if you want to do so:

$postRecord=Post::model()->findByPk($postID);
$postRecord->attributes=$_POST['post'];
$postRecord->save();

public boolean saveCounters(array $counters)
$counters	array	the counters to be updated (column name=>increment value)
{return}	boolean	whether the saving is successful

Saves one or several counter columns for the current AR object. Note that this method differs from updateCounters in that it only saves the current AR object. An example usage is as follows:

$postRecord=Post::model()->findByPk($postID);
$postRecord->saveCounters(array('view_count'=>1));

Use negative values if you want to decrease the counters.

public array scopes()
{return}	array	the scope definition. The array keys are scope names; the array values are the corresponding scope definitions. Each scope definition is represented as an array whose keys must be properties of CDbCriteria.

Returns the declaration of named scopes. A named scope represents a query criteria that can be chained together with other named scopes and applied to a query. This method should be overridden by child classes to declare named scopes for the particular AR classes. For example, the following code declares two named scopes: 'recently' and 'published'.

return array(
    'published'=>array(
          'condition'=>'status=1',
    ),
    'recently'=>array(
          'order'=>'create_time DESC',
          'limit'=>5,
    ),
);

If the above scopes are declared in a 'Post' model, we can perform the following queries:

$posts=Post::model()->published()->findAll();
$posts=Post::model()->published()->recently()->findAll();
$posts=Post::model()->published()->with('comments')->findAll();

Note that the last query is a relational query.

public boolean setAttribute(string $name, mixed $value)
$name	string	the attribute name
$value	mixed	the attribute value.
{return}	boolean	whether the attribute exists and the assignment is conducted successfully

Sets the named attribute value. You may also use $this->AttributeName to set the attribute value.

public void setDbCriteria(CDbCriteria $criteria)
$criteria	CDbCriteria	the query criteria

Sets the query criteria for the current model.

public void setIsNewRecord(boolean $value)
$value	boolean	whether the record is new and should be inserted when calling save.

Sets if the record is new.

public void setOldPrimaryKey(mixed $value)
$value	mixed	the old primary key value.

Sets the old primary key value.

public void setPrimaryKey(mixed $value)
$value	mixed	the new primary key value. If the primary key is composite, the new value should be provided as an array (column name=>column value).

Sets the primary key value. After calling this method, the old primary key value can be obtained from oldPrimaryKey.

public void setTableAlias(string $alias)
$alias	string	the table alias to be used in queries. The alias should NOT be quoted.

Sets the table alias to be used in queries.

public string tableName()
{return}	string	the table name

Returns the name of the associated database table. By default this method returns the class name as the table name. You may override this method if the table is not named after this convention.

public static together()
{return}	static	the AR object itself

Sets CDbCriteria::together property to be true. This is only used in relational AR query. Please refer to CDbCriteria::together for more details.

public boolean update(array $attributes=NULL)
$attributes	array	list of attributes that need to be saved. Defaults to null, meaning all attributes that are loaded from DB will be saved.
{return}	boolean	whether the update is successful

Updates the row represented by this active record. All loaded attributes will be saved to the database. Note, validation is not performed in this method. You may call validate to perform the validation.

public integer updateAll(array $attributes, mixed $condition='', array $params=array ( ))
$attributes	array	list of attributes (name=>$value) to be updated
$condition	mixed	query condition or criteria.
$params	array	parameters to be bound to an SQL statement.
{return}	integer	the number of rows being updated

Updates records with the specified condition. See find() for detailed explanation about $condition and $params. Note, the attributes are not checked for safety and no validation is done.

public integer updateByPk(mixed $pk, array $attributes, mixed $condition='', array $params=array ( ))
$pk	mixed	primary key value(s). Use array for multiple primary keys. For composite key, each key value must be an array (column name=>column value).
$attributes	array	list of attributes (name=>$value) to be updated
$condition	mixed	query condition or criteria.
$params	array	parameters to be bound to an SQL statement.
{return}	integer	the number of rows being updated

Updates records with the specified primary key(s). See find() for detailed explanation about $condition and $params. Note, the attributes are not checked for safety and validation is NOT performed.

public integer updateCounters(array $counters, mixed $condition='', array $params=array ( ))
$counters	array	the counters to be updated (column name=>increment value)
$condition	mixed	query condition or criteria.
$params	array	parameters to be bound to an SQL statement.
{return}	integer	the number of rows being updated

Updates one or several counter columns. Note, this updates all rows of data unless a condition or criteria is specified. See find() for detailed explanation about $condition and $params.

public static with()
{return}	static	the AR object itself.

Specifies which related objects should be eagerly loaded. This method takes variable number of parameters. Each parameter specifies the name of a relation or child-relation. For example,

// find all posts together with their author and comments
Post::model()->with('author','comments')->findAll();
// find all posts together with their author and the author's profile
Post::model()->with('author','author.profile')->findAll();

The relations should be declared in relations().

By default, the options specified in relations() will be used to do relational query. In order to customize the options on the fly, we should pass an array parameter to the with() method. The array keys are relation names, and the array values are the corresponding query options. For example,

Post::model()->with(array(
    'author'=>array('select'=>'id, name'),
    'comments'=>array('condition'=>'approved=1', 'order'=>'create_time'),
))->findAll();