arseniew/silex-idiorm-provider

Silex service provider for Idiorm

v1.1.2 2014-09-19 21:02 UTC

Requires

• j4mie/idiorm: 1.4.*

MIT

• Marcin Batkowski

• silex
• service provider
• idiorm

README

Provider for integrating Idiorm with Silex

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

Usage in controller

To get all records for given table:

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

For more query examples see: Idiorm querying

Multiple connections

To configure multiple connections use $app['idiorm.dbs.options']

$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

To use connections in controller:

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