library silex-idiorm-provider

arseniew/silex-idiorm-provider

Silex service provider for Idiorm

Idiorm Service Provider

Provider for integrating Idiorm with Silex, _(*1)

Registering and configuration

$app->register(new \Arseniew\Silex\Provider\IdiormServiceProvider(), array(
        'idiorm.db.options' => array(
            'connection_string' => 'mysql:host=localhost;dbname=my_db',
            'username' => 'my_username',
            'password' => 'my_password',
        )
);

For more details on configuration array see: Idiorm configuration options, _(*2)

Usage in controller

To get all records for given table:, _(*3)

$app['idiorm.db']->for_table('my_table')->findMany();

For more query examples see: Idiorm querying, _(*4)

Multiple connections

To configure multiple connections use $app['idiorm.dbs.options'], _(*5)

$app['idiorm.dbs.options'] = array(
    'first_connection' => array(
        'connection_string' => 'mysql:host=localhost;dbname=my_db',
        'username' => 'my_username',
        'password' => 'my_password',
    ),
    'second_connection' => array(
        'connection_string' => 'sqlite:./example.db'
    )
);

$app['idiorm.dbs.options'] Needs to be associative array, where keys will be connection names, and value will contain configuration array, _(*6)

To use connections in controller:, _(*7)

$app['idiorm.dbs']['first_connection']->for_table('my_table')->findMany();
$app['idiorm.dbs']['second_connection']->for_table('other_table')->findMany();