ActiveRecordInterface.php 14.2 KB
Newer Older
Carsten Brandt committed
1 2
<?php
/**
3 4
 *
 *
Carsten Brandt committed
5 6 7 8 9 10 11 12 13 14 15 16 17 18
 * @author Carsten Brandt <mail@cebe.cc>
 */

namespace yii\db;

/**
 * ActiveRecordInterface
 *
 * @author Qiang Xue <qiang.xue@gmail.com>
 * @author Carsten Brandt <mail@cebe.cc>
 * @since 2.0
 */
interface ActiveRecordInterface
{
19 20 21 22 23 24 25 26 27 28
    /**
     * Returns the primary key **name(s)** for this AR class.
     *
     * Note that an array should be returned even when the record only has a single primary key.
     *
     * For the primary key **value** see [[getPrimaryKey()]] instead.
     *
     * @return string[] the primary key name(s) for this AR class.
     */
    public static function primaryKey();
Carsten Brandt committed
29

30 31 32 33 34
    /**
     * Returns the list of all attribute names of the record.
     * @return array list of attribute names.
     */
    public function attributes();
Carsten Brandt committed
35

36 37 38 39
    /**
     * Returns the named attribute value.
     * If this record is the result of a query and the attribute is not loaded,
     * null will be returned.
40 41
     * @param string $name the attribute name
     * @return mixed the attribute value. Null if the attribute is not set or does not exist.
42 43 44
     * @see hasAttribute()
     */
    public function getAttribute($name);
Carsten Brandt committed
45

46 47
    /**
     * Sets the named attribute value.
48 49
     * @param string $name the attribute name.
     * @param mixed $value the attribute value.
50 51 52
     * @see hasAttribute()
     */
    public function setAttribute($name, $value);
Carsten Brandt committed
53

54 55
    /**
     * Returns a value indicating whether the record has an attribute with the specified name.
56
     * @param string $name the name of the attribute
57 58 59
     * @return boolean whether the record has an attribute with the specified name.
     */
    public function hasAttribute($name);
Carsten Brandt committed
60

61 62
    /**
     * Returns the primary key value(s).
63 64 65 66 67 68
     * @param boolean $asArray whether to return the primary key value as an array. If true,
     * the return value will be an array with attribute names as keys and attribute values as values.
     * Note that for composite primary keys, an array will always be returned regardless of this parameter value.
     * @return mixed the primary key value. An array (attribute name => attribute value) is returned if the primary key
     * is composite or `$asArray` is true. A string is returned otherwise (null will be returned if
     * the key value is null).
69 70
     */
    public function getPrimaryKey($asArray = false);
Carsten Brandt committed
71

72 73 74 75 76
    /**
     * Returns the old primary key value(s).
     * 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.
77 78 79
     * @param boolean $asArray whether to return the primary key value as an array. If true,
     * the return value will be an array with column name as key and column value as value.
     * If this is false (default), a scalar value will be returned for non-composite primary key.
80
     * @property mixed The old primary key value. An array (column name => column value) is
81 82 83 84 85
     * returned if the primary key is composite. A string is returned otherwise (null will be
     * returned if the key value is null).
     * @return mixed the old primary key value. An array (column name => column value) is returned if the primary key
     * is composite or `$asArray` is true. A string is returned otherwise (null will be returned if
     * the key value is null).
86 87
     */
    public function getOldPrimaryKey($asArray = false);
88

89 90
    /**
     * Returns a value indicating whether the given set of attributes represents the primary key for this model
91
     * @param array $keys the set of attributes to check
92 93 94
     * @return boolean whether the given set of attributes represents the primary key for this model
     */
    public static function isPrimaryKey($keys);
95

96 97 98
    /**
     * Creates an [[ActiveQueryInterface|ActiveQuery]] instance for query purpose.
     *
99 100 101
     * The returned [[ActiveQueryInterface|ActiveQuery]] instance can be further customized by calling
     * methods defined in [[ActiveQueryInterface]] before `one()` or `all()` is called to return
     * populated ActiveRecord instances. For example,
102 103
     *
     * ```php
104 105 106 107 108 109 110 111
     * // find the customer whose ID is 1
     * $customer = Customer::find()->where(['id' => 1])->one();
     *
     * // find all active customers and order them by their age:
     * $customers = Customer::find()
     *     ->where(['status' => 1])
     *     ->orderBy('age')
     *     ->all();
112 113
     * ```
     *
114
     * This method can also take a parameter which can be:
115 116
     *
     *  - a scalar value (integer or string): query by a single primary key value and return the
117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136
     *    corresponding record (or null if not found).
     *  - an array of name-value pairs: query by a set of attribute values and return a single record
     *    matching all of them (or null if not found).
     *
     * Note that in this case, the method will automatically call the `one()` method and return an
     * [[ActiveRecordInterface|ActiveRecord]] instance. For example,
     *
     * ```php
     * // find a single customer whose primary key value is 10
     * $customer = Customer::find(10);
     *
     * // the above code is equivalent to:
     * $customer = Customer::find()->where(['id' => 10])->one();
     *
     * // find a single customer whose age is 30 and whose status is 1
     * $customer = Customer::find(['age' => 30, 'status' => 1]);
     *
     * // the above code is equivalent to:
     * $customer = Customer::find()->where(['age' => 30, 'status' => 1])->one();
     * ```
137
     *
138 139 140 141
     * @return ActiveQueryInterface|static|null When this method receives no parameter, a new [[ActiveQuery]] instance
     * will be returned; Otherwise, the parameter will be treated as a primary key value or a set of column
     * values, and an ActiveRecord object matching it will be returned (null will be returned if there is no matching).
     * @see createQuery()
142
     */
143
    public static function find();
Carsten Brandt committed
144

145 146 147 148 149 150 151 152 153 154 155 156 157
    /**
     * Creates an [[ActiveQueryInterface|ActiveQuery]] instance.
     *
     * This method is called by [[find()]] to start a SELECT query but also
     * by [[BaseActiveRecord::hasOne()]] and [[BaseActiveRecord::hasMany()]] to
     * create a relational query.
     *
     * You may override this method to return a customized query (e.g. `CustomerQuery` specified
     * written for querying `Customer` purpose.)
     *
     * You may also define default conditions that should apply to all queries unless overridden:
     *
     * ```php
158
     * public static function createQuery()
159
     * {
160
     *     return parent::createQuery()->where(['deleted' => false]);
161 162 163 164 165 166 167 168
     * }
     * ```
     *
     * Note that all queries should use [[Query::andWhere()]] and [[Query::orWhere()]] to keep the
     * default condition. Using [[Query::where()]] will override the default condition.
     *
     * @return ActiveQueryInterface the newly created [[ActiveQueryInterface|ActiveQuery]] instance.
     */
169
    public static function createQuery();
170

171 172 173 174 175 176 177 178
    /**
     * Updates records using the provided attribute values and conditions.
     * For example, to change the status to be 1 for all customers whose status is 2:
     *
     * ~~~
     * Customer::updateAll(['status' => 1], ['status' => '2']);
     * ~~~
     *
179 180 181 182 183
     * @param array $attributes attribute values (name-value pairs) to be saved for the record.
     * Unlike [[update()]] these are not going to be validated.
     * @param array $condition the condition that matches the records that should get updated.
     * Please refer to [[QueryInterface::where()]] on how to specify this parameter.
     * An empty condition will match all records.
184 185 186
     * @return integer the number of rows updated
     */
    public static function updateAll($attributes, $condition = null);
Carsten Brandt committed
187

188 189 190 191 192 193 194 195 196 197
    /**
     * Deletes records using the provided conditions.
     * WARNING: If you do not specify any condition, this method will delete ALL rows in the table.
     *
     * For example, to delete all customers whose status is 3:
     *
     * ~~~
     * Customer::deleteAll([status = 3]);
     * ~~~
     *
198 199 200
     * @param array $condition the condition that matches the records that should get deleted.
     * Please refer to [[QueryInterface::where()]] on how to specify this parameter.
     * An empty condition will match all records.
201 202 203
     * @return integer the number of rows deleted
     */
    public static function deleteAll($condition = null);
Carsten Brandt committed
204

205 206 207 208 209 210 211 212 213 214 215 216 217 218 219
    /**
     * Saves the current record.
     *
     * This method will call [[insert()]] when [[getIsNewRecord|isNewRecord]] is true, or [[update()]]
     * when [[getIsNewRecord|isNewRecord]] is false.
     *
     * For example, to save a customer record:
     *
     * ~~~
     * $customer = new Customer; // or $customer = Customer::find($id);
     * $customer->name = $name;
     * $customer->email = $email;
     * $customer->save();
     * ~~~
     *
220 221 222 223 224
     * @param boolean $runValidation whether to perform validation before saving the record.
     * If the validation fails, the record will not be saved to database. `false` will be returned
     * in this case.
     * @param array $attributes list of attributes that need to be saved. Defaults to null,
     * meaning all attributes that are loaded from DB will be saved.
225 226 227
     * @return boolean whether the saving succeeds
     */
    public function save($runValidation = true, $attributes = null);
Carsten Brandt committed
228

229 230 231 232 233 234 235 236 237 238 239 240
    /**
     * Inserts the record into the database using the attribute values of this record.
     *
     * Usage example:
     *
     * ```php
     * $customer = new Customer;
     * $customer->name = $name;
     * $customer->email = $email;
     * $customer->insert();
     * ```
     *
241 242 243 244
     * @param boolean $runValidation whether to perform validation before saving the record.
     * If the validation fails, the record will not be inserted into the database.
     * @param array $attributes list of attributes that need to be saved. Defaults to null,
     * meaning all attributes that are loaded from DB will be saved.
245 246 247
     * @return boolean whether the attributes are valid and the record is inserted successfully.
     */
    public function insert($runValidation = true, $attributes = null);
Carsten Brandt committed
248

249 250 251 252 253 254 255 256 257 258 259 260
    /**
     * Saves the changes to this active record into the database.
     *
     * Usage example:
     *
     * ```php
     * $customer = Customer::find($id);
     * $customer->name = $name;
     * $customer->email = $email;
     * $customer->update();
     * ```
     *
261 262 263 264
     * @param boolean $runValidation whether to perform validation before saving the record.
     * If the validation fails, the record will not be inserted into the database.
     * @param array $attributes list of attributes that need to be saved. Defaults to null,
     * meaning all attributes that are loaded from DB will be saved.
265
     * @return integer|boolean the number of rows affected, or false if validation fails
266 267 268
     * or updating process is stopped for other reasons.
     * Note that it is possible that the number of rows affected is 0, even though the
     * update execution is successful.
269 270
     */
    public function update($runValidation = true, $attributes = null);
Carsten Brandt committed
271

272 273 274 275
    /**
     * Deletes the record from the database.
     *
     * @return integer|boolean the number of rows deleted, or false if the deletion is unsuccessful for some reason.
276
     * Note that it is possible that the number of rows deleted is 0, even though the deletion execution is successful.
277 278
     */
    public function delete();
Carsten Brandt committed
279

280 281 282 283 284
    /**
     * Returns a value indicating whether the current record is new (not saved in the database).
     * @return boolean whether the record is new and should be inserted when calling [[save()]].
     */
    public function getIsNewRecord();
Carsten Brandt committed
285

286 287 288
    /**
     * Returns a value indicating whether the given active record is the same as the current one.
     * Two [[isNewRecord|new]] records are considered to be not equal.
289
     * @param static $record record to compare to
290 291 292
     * @return boolean whether the two active records refer to the same row in the same database table.
     */
    public function equals($record);
Carsten Brandt committed
293

294 295 296 297 298
    /**
     * Returns the relation object with the specified name.
     * A relation is defined by a getter method which returns an object implementing the [[ActiveQueryInterface]]
     * (normally this would be a relational [[ActiveQuery]] object).
     * It can be declared in either the ActiveRecord class itself or one of its behaviors.
299 300
     * @param string $name the relation name
     * @param boolean $throwException whether to throw exception if the relation does not exist.
301 302 303
     * @return ActiveQueryInterface the relational query object
     */
    public function getRelation($name, $throwException = true);
Carsten Brandt committed
304

305 306 307 308 309 310 311 312 313 314 315 316
    /**
     * Establishes the relationship between two records.
     *
     * The relationship is established by setting the foreign key value(s) in one record
     * to be the corresponding primary key value(s) in the other record.
     * The record with the foreign key will be saved into database without performing validation.
     *
     * If the relationship involves a pivot table, a new row will be inserted into the
     * pivot table which contains the primary key values from both records.
     *
     * This method requires that the primary key value is not null.
     *
317 318 319 320 321
     * @param string $name the case sensitive name of the relationship.
     * @param static $model the record to be linked with the current one.
     * @param array $extraColumns additional column values to be saved into the pivot table.
     * This parameter is only meaningful for a relationship involving a pivot table
     * (i.e., a relation set with `[[ActiveQueryInterface::via()]]`.)
322 323
     */
    public function link($name, $model, $extraColumns = []);
Carsten Brandt committed
324

325 326 327 328 329 330
    /**
     * Destroys the relationship between two records.
     *
     * The record with the foreign key of the relationship will be deleted if `$delete` is true.
     * Otherwise, the foreign key will be set null and the record will be saved without validation.
     *
331 332
     * @param string $name the case sensitive name of the relationship.
     * @param static $model the model to be unlinked from the current one.
333
     * @param boolean $delete whether to delete the model that contains the foreign key.
334 335
     * If false, the model's foreign key will be set null and saved.
     * If true, the model containing the foreign key will be deleted.
336 337
     */
    public function unlink($name, $model, $delete = false);
338
}