ActiveRecord.php 9.96 KB
Newer Older
Carsten Brandt committed
1 2 3
<?php
/**
 * @link http://www.yiiframework.com/
4
 * @copyright Copyright (c) 2008 Yii Software LLC
Carsten Brandt committed
5 6 7
 * @license http://www.yiiframework.com/license/
 */

8
namespace yii\redis;
Carsten Brandt committed
9

10
use yii\base\InvalidConfigException;
Carsten Brandt committed
11
use yii\db\BaseActiveRecord;
12
use yii\helpers\Inflector;
13
use yii\helpers\StringHelper;
14

Carsten Brandt committed
15 16 17
/**
 * ActiveRecord is the base class for classes representing relational data in terms of objects.
 *
18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34
 * This class implements the ActiveRecord pattern for the [redis](http://redis.io/) key-value store.
 *
 * For defining a record a subclass should at least implement the [[attributes()]] method to define
 * attributes. A primary key can be defined via [[primaryKey()]] which defaults to `id` if not specified.
 *
 * The following is an example model called `Customer`:
 *
 * ```php
 * class Customer extends \yii\redis\ActiveRecord
 * {
 *     public function attributes()
 *     {
 *         return ['id', 'name', 'address', 'registration_date'];
 *     }
 * }
 * ```
 *
Carsten Brandt committed
35 36 37
 * @author Carsten Brandt <mail@cebe.cc>
 * @since 2.0
 */
Carsten Brandt committed
38
class ActiveRecord extends BaseActiveRecord
Carsten Brandt committed
39
{
40 41 42 43 44 45 46 47
    /**
     * Returns the database connection used by this AR class.
     * By default, the "redis" application component is used as the database connection.
     * You may override this method if you want to use a different database connection.
     * @return Connection the database connection used by this AR class.
     */
    public static function getDb()
    {
48
        return \Yii::$app->get('redis');
49
    }
Carsten Brandt committed
50

51
    /**
Alexander Makarov committed
52
     * @inheritdoc
53
     */
Alexander Makarov committed
54
    public static function find()
55
    {
56
        return new ActiveQuery(get_called_class());
57
    }
58

59 60 61 62 63 64 65 66 67 68 69 70
    /**
     * Returns the primary key name(s) for this AR class.
     * This method should be overridden by child classes to define the primary key.
     *
     * Note that an array should be returned even when it is a single primary key.
     *
     * @return string[] the primary keys of this record.
     */
    public static function primaryKey()
    {
        return ['id'];
    }
71

72 73 74 75 76 77 78 79 80
    /**
     * Returns the list of all attribute names of the model.
     * This method must be overridden by child classes to define available attributes.
     * @return array list of attribute names.
     */
    public function attributes()
    {
        throw new InvalidConfigException('The attributes() method of redis ActiveRecord has to be implemented by child classes.');
    }
81

82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105
    /**
     * Declares prefix of the key that represents the keys that store this records in redis.
     * By default this method returns the class name as the table name by calling [[Inflector::camel2id()]].
     * For example, 'Customer' becomes 'customer', and 'OrderItem' becomes
     * 'order_item'. You may override this method if you want different key naming.
     * @return string the prefix to apply to all AR keys
     */
    public static function keyPrefix()
    {
        return Inflector::camel2id(StringHelper::basename(get_called_class()), '_');
    }

    /**
     * @inheritdoc
     */
    public function insert($runValidation = true, $attributes = null)
    {
        if ($runValidation && !$this->validate($attributes)) {
            return false;
        }
        if ($this->beforeSave(true)) {
            $db = static::getDb();
            $values = $this->getDirtyAttributes($attributes);
            $pk = [];
106
            //			if ($values === []) {
107 108 109 110 111 112 113
            foreach ($this->primaryKey() as $key) {
                $pk[$key] = $values[$key] = $this->getAttribute($key);
                if ($pk[$key] === null) {
                    $pk[$key] = $values[$key] = $db->executeCommand('INCR', [static::keyPrefix() . ':s:' . $key]);
                    $this->setAttribute($key, $values[$key]);
                }
            }
114
            //			}
115 116 117 118 119 120 121 122 123 124 125 126 127
            // save pk in a findall pool
            $db->executeCommand('RPUSH', [static::keyPrefix(), static::buildKey($pk)]);

            $key = static::keyPrefix() . ':a:' . static::buildKey($pk);
            // save attributes
            $args = [$key];
            foreach ($values as $attribute => $value) {
                $args[] = $attribute;
                $args[] = $value;
            }
            $db->executeCommand('HMSET', $args);

            $this->afterSave(true);
128
            $this->setOldAttributes($values);
129 130 131 132 133 134 135 136 137 138 139 140 141 142 143

            return true;
        }

        return false;
    }

    /**
     * Updates the whole table 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], ['id' => 2]);
     * ~~~
     *
144 145 146
     * @param array $attributes attribute values (name-value pairs) to be saved into the table
     * @param array $condition the conditions that will be put in the WHERE part of the UPDATE SQL.
     * Please refer to [[ActiveQuery::where()]] on how to specify this parameter.
147 148 149 150 151 152 153 154 155
     * @return integer the number of rows updated
     */
    public static function updateAll($attributes, $condition = null)
    {
        if (empty($attributes)) {
            return 0;
        }
        $db = static::getDb();
        $n = 0;
Carsten Brandt committed
156
        foreach (self::fetchPks($condition) as $pk) {
157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181 182 183 184 185 186 187 188 189 190 191 192 193 194 195
            $newPk = $pk;
            $pk = static::buildKey($pk);
            $key = static::keyPrefix() . ':a:' . $pk;
            // save attributes
            $args = [$key];
            foreach ($attributes as $attribute => $value) {
                if (isset($newPk[$attribute])) {
                    $newPk[$attribute] = $value;
                }
                $args[] = $attribute;
                $args[] = $value;
            }
            $newPk = static::buildKey($newPk);
            $newKey = static::keyPrefix() . ':a:' . $newPk;
            // rename index if pk changed
            if ($newPk != $pk) {
                $db->executeCommand('MULTI');
                $db->executeCommand('HMSET', $args);
                $db->executeCommand('LINSERT', [static::keyPrefix(), 'AFTER', $pk, $newPk]);
                $db->executeCommand('LREM', [static::keyPrefix(), 0, $pk]);
                $db->executeCommand('RENAME', [$key, $newKey]);
                $db->executeCommand('EXEC');
            } else {
                $db->executeCommand('HMSET', $args);
            }
            $n++;
        }

        return $n;
    }

    /**
     * Updates the whole table using the provided counter changes and conditions.
     * For example, to increment all customers' age by 1,
     *
     * ~~~
     * Customer::updateAllCounters(['age' => 1]);
     * ~~~
     *
196 197 198 199
     * @param array $counters the counters to be updated (attribute name => increment value).
     * Use negative values if you want to decrement the counters.
     * @param array $condition the conditions that will be put in the WHERE part of the UPDATE SQL.
     * Please refer to [[ActiveQuery::where()]] on how to specify this parameter.
200 201 202 203 204 205 206 207 208
     * @return integer the number of rows updated
     */
    public static function updateAllCounters($counters, $condition = null)
    {
        if (empty($counters)) {
            return 0;
        }
        $db = static::getDb();
        $n = 0;
Carsten Brandt committed
209
        foreach (self::fetchPks($condition) as $pk) {
210 211 212 213 214 215 216 217 218
            $key = static::keyPrefix() . ':a:' . static::buildKey($pk);
            foreach ($counters as $attribute => $value) {
                $db->executeCommand('HINCRBY', [$key, $attribute, $value]);
            }
            $n++;
        }

        return $n;
    }
219

220 221 222 223 224 225 226 227 228 229
    /**
     * Deletes rows in the table 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]);
     * ~~~
     *
230 231
     * @param array $condition the conditions that will be put in the WHERE part of the DELETE SQL.
     * Please refer to [[ActiveQuery::where()]] on how to specify this parameter.
232 233 234 235 236 237
     * @return integer the number of rows deleted
     */
    public static function deleteAll($condition = null)
    {
        $db = static::getDb();
        $attributeKeys = [];
Carsten Brandt committed
238
        $pks = self::fetchPks($condition);
239 240 241 242 243 244 245 246
        $db->executeCommand('MULTI');
        foreach ($pks as $pk) {
            $pk = static::buildKey($pk);
            $db->executeCommand('LREM', [static::keyPrefix(), 0, $pk]);
            $attributeKeys[] = static::keyPrefix() . ':a:' . $pk;
        }
        if (empty($attributeKeys)) {
            $db->executeCommand('EXEC');
247

248 249 250 251
            return 0;
        }
        $db->executeCommand('DEL', $attributeKeys);
        $result = $db->executeCommand('EXEC');
252

253 254
        return end($result);
    }
255

256 257
    private static function fetchPks($condition)
    {
Alexander Makarov committed
258
        $query = static::find();
259 260 261
        $query->where($condition);
        $records = $query->asArray()->all(); // TODO limit fetched columns to pk
        $primaryKey = static::primaryKey();
262

263 264 265 266 267 268 269 270
        $pks = [];
        foreach ($records as $record) {
            $pk = [];
            foreach ($primaryKey as $key) {
                $pk[$key] = $record[$key];
            }
            $pks[] = $pk;
        }
271

272 273
        return $pks;
    }
274

275 276 277
    /**
     * Builds a normalized key from a given primary key value.
     *
278
     * @param mixed $key the key to be normalized
279 280 281 282 283 284 285 286 287 288 289 290 291 292 293 294 295 296 297 298 299 300 301
     * @return string the generated key
     */
    public static function buildKey($key)
    {
        if (is_numeric($key)) {
            return $key;
        } elseif (is_string($key)) {
            return ctype_alnum($key) && StringHelper::byteLength($key) <= 32 ? $key : md5($key);
        } elseif (is_array($key)) {
            if (count($key) == 1) {
                return self::buildKey(reset($key));
            }
            ksort($key); // ensure order is always the same
            $isNumeric = true;
            foreach ($key as $value) {
                if (!is_numeric($value)) {
                    $isNumeric = false;
                }
            }
            if ($isNumeric) {
                return implode('-', $key);
            }
        }
302

303 304
        return md5(json_encode($key));
    }
Carsten Brandt committed
305
}