arseniew/silex-idiorm-provider

Silex service provider for Idiorm

Installs: 77

Dependents: 0

Stars: 2

Watchers: 2

Forks: 3

Language: PHP

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

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