Provider for integrating Idiorm with Silex
$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
To get all records for given table:
$app['idiorm.db']->for_table('my_table')->findMany();
For more query examples see: Idiorm querying
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();