initialize.md

Initialize EQM / DDL

EQM is a static class but it is able to manage multiple connections.

Basic connection

You can initialize troba if you call EQM::initailze() with an array as configuration and an optional second parameter for a second connection name.

EQM::initialize([
    'dsn' => '<pdo dsn>',
    'username' => '<username>',
    'password' => '<password>'
]);

The configuration array has more parameters but there are a lot of defaults. The full array is this:

$config = [
    'dsn' => '<the pdo dsn>',
    'username' => '<the username if necessary>'
    'password' => 'the password if necessary>',
    EQM::RUN_MODE => [EQM::DEV_MODE | EQM::PROD_MODE]
    EQM::CONVENTION_HANDLER => <object that implements ConventionHandlerInterface>
    EQM::SQL_BUILDER => <object that implements SqlBuilderInterface>
];

The defaults are

$config = [
    'dsn' => '<the pdo dsn>',
    'username' => '<the username if necessary>'
    'password' => 'the password if necessary>',
    EQM::RUN_MODE => EQM::PROD_MODE,
    EQM::CONVENTION_HANDLER => new troba\EQM\DefaultConventionHandler(),
    EQM::SQL_BUILDER => new troba\EQM\MySqlBuilder()
];

Multiple connections

The first call of initialize() sets the 'default' connection. With initialize($config, $connectionName) you can add another connection with adifferent name. If you want to use another conntection than the default connection you have to call activateConnection($connectionName). The following example shows a table copy from one database to another with a different convention handler that means another table naming.

require_once '../troba/lib/troba/Util/ClassLoader.php';
$loader = new \troba\Util\ClassLoader('troba', '../troba/lib');
$loader->register();

use troba\EQM\EQM;

// init the default connection
EQM::initialize([
    'dsn' => 'mysql:host=localhost;dbname=orm_test',
    'username' => 'root',
    'password' => 'root',
    EQM::RUN_MODE => EQM::DEV_MODE,
]);

// init the second connection
EQM::initialize([
    'dsn' => 'mysql:host=localhost;dbname=orm_test2',
    'username' => 'root',
    'password' => 'root',
    EQM::RUN_MODE => EQM::DEV_MODE,
    EQM::CONVENTION_HANDLER => new \troba\EQM\ClassicConventionHandler();
], 'second');

// read all records from table Company in database orm_test
$companies = EQM::query(new Company())->result();

// switch to second connection
EQM::activateConnection('second');

// iterate over the result set and insert into
// the table company in the database orm_test2
foreach($companies as $company) {
    EQM::insert($company);
}

// reactivate default connection
EQM::activateConnection();