speedwork/database

此包已废弃且不再维护。未建议替代包。

Speedwork 数据库库

v1.0.4 2017-07-29 11:27 UTC

This package is not auto-updated.

Last update: 2018-08-08 05:24:59 UTC


README

=============================================

Latest Stable Version Latest Unstable Version License Total Downloads Build Status

示例连接配置


    'sample' => [
        'driver'     => 'mysqli',
        'persistent' => false,
        'host'       => env('DB_HOST', '127.0.0.1'),
        'database'   => env('DB_DATABASE', 'speedwork'),
        'username'   => env('DB_USERNAME', 'root'),
        'password'   => env('DB_PASSWORD', ''),
        'charset'    => 'utf8',
        'collation'  => 'utf8_general_ci',
        'prefix'     => env('DB_PREFIX', 'speed_'),
    ],

    // With failover connection
    'sample1' => [
        'driver'     => 'mysqli',
        'persistent' => false,
        'host'       => env('DB_HOST', '127.0.0.1'),
        'database'   => env('DB_DATABASE', 'speedwork'),
        'username'   => env('DB_USERNAME', 'root'),
        'password'   => env('DB_PASSWORD', ''),
        'charset'    => 'utf8',
        'collation'  => 'utf8_general_ci',
        'prefix'     => env('DB_PREFIX', 'speed_'),
        'masters' => [
            ['host' => '172.16.1.207'],
            ['host' => '172.16.1.184'],
        ],
    ],

    'master' => [
        'driver'     => 'mysqli',
        'persistent' => false,
        'wrapper'    => 'MasterSlave',
        'database'   => env('DB_DATABASE', 'speedwork'),
        'username'   => env('DB_USERNAME', 'root'),
        'password'   => env('DB_PASSWORD', ''),
        'charset'    => 'utf8',
        'collation'  => 'utf8_general_ci',
        'prefix'     => env('DB_PREFIX', 'speed_'),
        'master'     => [
            'host' => '172.16.1.213',
        ],
        'slaves' => [
            ['host' => '172.16.1.207'],
            ['host' => '172.16.1.184'],
        ],
        'connections' => [
            'select' => 'slave',
            'update' => 'master',
            'other'  => 'master',
        ],
    ],
    
    'master' => [
            'driver'     => 'mysqli',
            'persistent' => false,
            'wrapper'    => 'MasterSlaveExtended',
            'database'   => env('DB_DATABASE', 'speedwork'),
            'username'   => env('DB_USERNAME', 'root'),
            'password'   => env('DB_PASSWORD', ''),
            'charset'    => 'utf8',
            'collation'  => 'utf8_general_ci',
            'prefix'     => env('DB_PREFIX', 'speed_'),
            'master'     => [
                'host' => '172.16.1.213',
            ],
            'slaves' => [
                ['host' => '172.16.1.207'],
                ['host' => '172.16.1.184'],
            ],
            'connections' => [
                'types' => [
                    'select' => 'slave',
                    'update' => 'master',
                    'other'  => 'master',
                ],
                'patterns' => [
                    'table_name' => 'salve'
                ]
            ],
        ],

## 贡献

  1. 创建分支
  2. 创建你的功能分支(git checkout -b my-new-feature
  3. 进行修改
  4. 运行测试,如有必要为你的代码添加新测试(phpunit
  5. 提交你的更改(git commit -am 'Added some feature'
  6. 推送到分支(git push origin my-new-feature
  7. 创建新的 Pull Request