README

工厂映射模型数据库 - 使用 DoctrineDBAL

通过 Composer 安装

composer.json
{
    "require": {
       "cbsantos/model-factory": "dev-master",
       "doctrine/dbal": "dev-master"
    }
}

创建数据库连接

使用 Doctrine 连接在数据库中建立连接

use \CBSantos\ModelFactory\ConnectionDB;

$config = new \Doctrine\DBAL\Configuration;

$params['dbname']   = 'nameDataBase'; 
$params['user']     = 'userDB';
$params['password'] = 'passwordDB'; 
$params['port']     = 'portConnection'; 
$params['host']     = 'hostConnection'; 
$params['driver']   = 'driverConnection'; 
$params['charset']  = 'charset'; 
$params['server']   = 'serverConnection'; 

- Information connection DB - Static method connection

new ConnectionDB(\Doctrine\DBAL\DriverManager::getConnection($params, $config));

## 使用示例

定义模型 Users - 测试

use \CBSantos\ModelFactory\Providers\ModelProvider;

class Users extends ModelProvider
{

    protected $table      = 'MODEL.Users';
    protected $primaryKey = 'Id';

    public function Business()
    {
        return $this->hasOne(new Business,'Id','Id');
    }
}

初始化模型接口

$users = new Users;

*Basic Operations*:

* $users->Get();       //Select all model
* $users->GetById(??); //Select element by Id
* $users->Put(??);     //Update in request input
* $users->Delete(??);  //Delete element by Id - Reference in ForeignKey Model

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