inhere/simple-active-record

This package is abandoned and no longer maintained. The author suggests using the php-comp/lite-activerecord package instead.

a simple activeRecord library of the php

v1.1.0 2018-11-20 12:57 UTC

Requires

• php: >=7.0.0
• inhere/php-validate: ^2.0
• php-comp/lite-db: dev-master
• psr/log: ~1.0
• toolkit/collection: ~1.0

Suggests

• inhere/console: a lightweight php console application library.
• inhere/sroute: Very fast php router

MIT

• inhere

• php
• library
• pdo
• activerecord
• tool

README

一个简洁的php activeRecord库

功能：

• 简洁，使用简单
• 支持 findByPk findOne findAll insert update 等常用方法
• 内置数据验证检查，保存数据之前自动验证。（像 yii 的模型，验证基于 inhere/php-validate）

安装

• By composer require

composer require php-comp/lite-activerecord

• By composer.json

{
    "require": {
        "php-comp/lite-activerecord": "~1.0"
    }
}

• Pull directly

git clone https://github.com/php-comp/lite-activeRecord.git

如何使用

• 引入类并继承

use PhpComp\LiteActiveRecord\RecordModel

class User extends RecordModel
{
    // ...
    
    /**
     * 表名称(可选定义)
     * @return string
     */
    public static function tableName(): string
    {
        return 'user';
    }

    /**
     * 表的字段。
     *  - 必须定义，只有这里定义的字段才会被保存
     * @return array
     */
    public function columns(): array
    {
        return [
            // column => [type]

            'id' => ['int'],
            'name' => ['string'],
        ];    
    }
    
    
    /**
     * define attribute field translate list(可选定义)
     * @return array
     */
    public function translates(): array
    {
        return [
            // 'field' => 'translate',
            // e.g. 'name'=>'名称',
    }    
    
    /**
     * 数据验证规则(可选定义)
     * - 保存数据之前会自动验证
     * @return array
     */
    public function rules(): array
    {
        return [
            // ['body', 'string'],
            // ['id, createTime', 'int'],
        }
    }
}

• 插入

$user = User::load($data);
$user->insert();

if ($model->hasError()) {
    var_dump($model->firstError())
}

var_dump($user->id);

• 查找

$user = User::findById(12);
$user = User::findOne(['name' => 'inhere']);

// 查找多个
$users = User::findAll([
    ['id', '>', 23], 
    'status' => [1, 2], // status IN (1,2)
    ['name', 'like', "%tom%"],
]);

• 更新

$user->name = 'new name';
$user->update();

• 删除

// 模型删除
$affected = $user->delete();

// 通过id删除
$affected = User::deleteByPk(23);

Projects

• github https://github.com/inhere/php-simple-activeRecord.git
• gitee https://gitee.com/inhere/php-simple-activeRecord.git

参考

• https://github.com/illuminate/database
• https://github.com/ventoviro/windwalker-query

License

MIT