public function register(Container $app)
 {
     $app['dbal.parameters'] = function ($app) {
         $parameters = array('host' => 'localhost', 'port' => null, 'dbname' => null, 'user' => null, 'password' => null, 'driver' => 'pdo_mysql', 'unix_socket' => null, 'charset' => 'utf8');
         foreach ($parameters as $key => $value) {
             if (isset($app['dbal.' . $key])) {
                 $parameters[$key] = $app['dbal.' . $key];
             }
         }
         return $parameters;
     };
     $app['dbal.event_manager'] = function ($app) {
         return new EventManager();
     };
     $app['dbal.logger'] = function ($app) {
         return new DBALLogger($app['logger']);
     };
     $app['dbal.configuration'] = function ($app) {
         $cfg = new Configuration();
         $cfg->setSqlLogger($app['dbal.logger']);
         return $cfg;
     };
     $app['dbal'] = function ($app) {
         return DriverManager::getConnection($app['dbal.parameters'], $app['dbal.configuration'], $app['dbal.event_manager']);
     };
 }