构建自个儿的PHP框架-实现Model类(3)

    /**     * Updates models using the provided attribute values and conditions.     * For example, to change the status to be 2 for all customers whose status is 1:     *     * ~~~     * Customer::updateAll(['status' => 1], ['status' => '2']);     * ~~~     *     * @param array $attributes attribute values (name-value pairs) to be saved for the model.     * @param array $condition the condition that matches the models that should get updated.     * An empty condition will match all models.     * @return integer the number of rows updated     */    public static function updateAll($condition, $attributes)    {        $sql = 'update ' . static::tableName();        $params = [];        if (!empty($attributes)) {            $sql .= ' set ';            $params = array_values($attributes);            $keys = [];            foreach ($attributes as $key => $value) {                array_push($keys, "$key = ?");            }            $sql .= implode(' , ', $keys);        }        list($where, $params) = static::buildWhere($condition, $params);        $sql .= $where;        $stmt = static::getDb()->prepare($sql);        $execResult = $stmt->execute($params);        if ($execResult) {            // 获取更新的行数            $execResult = $stmt->rowCount();        }        return $execResult;    }    /**     * Deletes models 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]);     * ~~~     *     * @param array $condition the condition that matches the models that should get deleted.     * An empty condition will match all models.     * @return integer the number of rows deleted     */    public static function deleteAll($condition)    {        list($where, $params) = static::buildWhere($condition);        $sql = 'delete from ' . static::tableName() . $where;        $stmt = static::getDb()->prepare($sql);        $execResult = $stmt->execute($params);        if ($execResult) {            // 获取删除的行数            $execResult = $stmt->rowCount();        }        return $execResult;    }    /**     * Inserts the model into the database using the attribute values of this record.     *     * Usage example:     *     * ```php     * $customer = new Customer;     * $customer->name = $name;     * $customer->email = $email;     * $customer->insert();     * ```     *     * @return boolean whether the model is inserted successfully.     */    public function insert()    {        $sql = 'insert into ' . static::tableName();        $params = [];        $keys = [];        foreach ($this as $key => $value) {            array_push($keys, $key);            array_push($params, $value);        }        // 构建由？组成的数组，其个数与参数相等数相同        $holders = array_fill(0, count($keys), '?');        $sql .= ' (' . implode(' , ', $keys) . ') values ( ' . implode(' , ', $holders) . ')';        $stmt = static::getDb()->prepare($sql);        $execResult = $stmt->execute($params);        // 将一些自增值赋回Model中        $primaryKeys = static::primaryKey();        foreach ($primaryKeys as $name) {            // Get the primary key            $lastId = static::getDb()->lastInsertId($name);            $this->$name = (int) $lastId;        }        return $execResult;    }    /**     * Saves the changes to this model into the database.     *     * Usage example:     *     * ```php     * $customer = Customer::findOne(['id' => $id]);     * $customer->name = $name;     * $customer->email = $email;     * $customer->update();     * ```     *     * @return integer|boolean the number of rows affected.     * Note that it is possible that the number of rows affected is 0, even though the     * update execution is successful.     */    public function update()    {        $primaryKeys = static::primaryKey();        $condition = [];        foreach ($primaryKeys as $name) {            $condition[$name] = isset($this->$name) ? $this->$name : null;        }        $attributes = [];        foreach ($this as $key => $value) {            if (!in_array($key, $primaryKeys, true)) {                $attributes[$key] = $value;            }        }        return static::updateAll($condition, $attributes) !== false;    }    /**     * Deletes the model from the database.     *     * @return integer|boolean the number of rows deleted.     * Note that it is possible that the number of rows deleted is 0, even though the deletion execution is successful.     */    public function delete()    {        $primaryKeys = static::primaryKey();        $condition = [];        foreach ($primaryKeys as $name) {            $condition[$name] = isset($this->$name) ? $this->$name : null;        }        return static::deleteAll($condition) !== false;    }

这样基本的Model就算是暂时完成了，虽然可能还有很多问题和局限，但暂时先这样了，我们之后有机会会一步一步的去完善。

好了，今天就先到这里。项目内容和博客内容也都会放到Github上，欢迎大家提建议。

code：https://github.com/CraryPrimitiveMan/simple-framework/tree/0.7

blog project：https://github.com/CraryPrimitiveMan/create-your-own-php-framework