cbsantos/model-factory

Model Factory using DoctrineDBAL

Model Factory

Factory mapping model DB - Uses DoctrineDBAL, _(*1)

Install via Composer

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

Create Connection DataBase:

Connected in DataBase using Doctrine Connection, _(*2)

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));

Example Using:

Defined Model Users - Test, _(*3)

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');
    }
}

Init Model's Interface, _(*4)

$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

================, _(*5)