2017 © Pedro Peláez
 

library fastd-eloquent

image

zqhong/fastd-eloquent

  • Wednesday, June 13, 2018
  • by zqhong
  • Repository
  • 1 Watchers
  • 3 Stars
  • 568 Installations
  • PHP
  • 0 Dependents
  • 0 Suggesters
  • 1 Forks
  • 0 Open issues
  • 11 Versions
  • 14 % Grown

The README.md

fastD Eloquent

使用 Eloquent 替换 fastD 自带的 Medoo, (*1)

安装

$ composer require -vvv zqhong/fastd-eloquent

配置

修改配置文件 config/app.conf，添加 EloquentServiceProvider，如下：, (*2)

<?php
return [
    // 省略了无关配置
    'services' => [
        \ServiceProvider\EloquentServiceProvider::class,
    ],
];

修改配置文件 .env.yml，添加如下信息：, (*3)

database:
    default:
        adapter: db_adapter
        name: db_name
        host: db_host
        user: db_username
        pass: db_password
        charset: db_charset
        port: db_port
        prefix: db_prefix

其中，driver 的可选值为：mysql、pgsql、sqlite 和 sqlsrv。, (*4)

直接使用

<?php
<?php

use Illuminate\Database\Capsule\Manager;

// create
Manager::connection('default')
    ->table('demo')
    ->insert([
        'content' => 'hello world',
    ]);

// read
// 参数一可省略，默认值为 default
Manager::connection('default')
    ->table('demo')
    ->where('id', 1)
    ->where('created_at', '<=', time())
    ->get([
        'id',
        'content',
    ]);

// update
Manager::connection('default')
    ->table('demo')
    ->where('id', 1)
    ->update([
        'content' => 'hello 2',
    ]);

// delete
Manager::connection('default')
    ->table('demo')
    ->where('id', 1)
    ->delete();

配置 Model 使用

<?php

namespace Model;

use Illuminate\Database\Eloquent\Model;

class DemoModel extends Model
{
    public $table = 'demo';

    public static function fetchAll()
    {
        return static::query()
            ->get()
            ->toArray();
    }
}

分页

分页的简单使用

<?php
$perPage = 10;
$columns = ['*'];
$pageName = 'page';

$paginator = YourModel::query()->paginate($perPage, $columns, $pageName);
$data = $paginator->toArray();

// 注：page 参数（当前页）会自动从 $_GET 或 $_POST 中的 page 参数自动获取，不需要单独设置。
// 参考代码
//LengthAwarePaginator::currentPageResolver(function () {
//    return (int)Arr::get(array_merge($_GET, $_POST), 'page', 1);
//});

其他资源

如果你对在其他框架中使用 Eloquent 感兴趣，请参考 Slim 的这篇文章 - Using Eloquent with Slim。, (*5)

如果你对 Eloquent 不熟悉，请阅读下面的资料。 * Laravel - Database: Query Builder * Laravel - Database: Pagination * Laravel - Eloquent: Getting Started * Laravel - Eloquent: Collections, (*6)

The Versions

13/06 2018

dev-master

9999999-dev

  Sources   Download

The Requires

 

The Development Requires

by Avatar zqhong

13/06 2018

v1.1.2

1.1.2.0

  Sources   Download

The Requires

 

The Development Requires

by Avatar zqhong

13/06 2018

v1.1.0

1.1.0.0

  Sources   Download

The Requires

 

The Development Requires

by Avatar zqhong

05/06 2018

v1.0.1

1.0.1.0

  Sources   Download

The Requires

 

The Development Requires

by Avatar zqhong

04/06 2018

v1.0.0

1.0.0.0

  Sources   Download

The Requires

 

The Development Requires

by Avatar zqhong

14/10 2017

v0.2.0

0.2.0.0

  Sources   Download

The Requires

 

by Avatar zqhong

14/09 2017

v0.1.4

0.1.4.0

  Sources   Download

The Requires

 

by Avatar zqhong

06/09 2017

v0.1.3

0.1.3.0

  Sources   Download

The Requires

 

by Avatar zqhong

28/08 2017

v0.1.2

0.1.2.0

  Sources   Download

The Requires

 

by Avatar zqhong

29/06 2017

v0.1.1

0.1.1.0

  Sources   Download

The Requires

 

by Avatar zqhong

29/06 2017

v0.1.0

0.1.0.0

  Sources   Download

The Requires

 

by Avatar zqhong