/**
* Provide information about phraseanet configuration
*
* @param \Silex\Application $app the silex application
*
* @return array
*/
private function get_config_info(Application $app)
{
$ret = [];
$ret['phraseanet']['version'] = ['name' => $app['phraseanet.version']::getName(), 'number' => $app['phraseanet.version']::getNumber()];
$ret['phraseanet']['environment'] = $app->getEnvironment();
$ret['phraseanet']['debug'] = $app['debug'];
$ret['phraseanet']['maintenance'] = $app['conf']->get(['main', 'maintenance']);
$ret['phraseanet']['errorsLog'] = $app['debug'];
$ret['phraseanet']['serverName'] = $app['conf']->get('servername');
return $ret;
}
public function register(Application $app)
{
$app['EM.sql-logger.file'] = $app->share(function (Application $app) {
return $app['log.path'] . '/doctrine-log.log';
});
$app['EM.sql-logger.max-files'] = 5;
$app['EM.sql-logger'] = $app->share(function (Application $app) {
$logger = new $app['monolog.logger.class']('doctrine-logger');
$logger->pushHandler(new RotatingFileHandler($app['EM.sql-logger.file'], $app['EM.sql-logger.max-files']));
return new MonologSQLLogger($logger, 'yaml');
});
$app['EM.driver'] = $app->share(function (Application $app) {
AnnotationRegistry::registerFile($app['root.path'] . '/vendor/doctrine/orm/lib/Doctrine/ORM/Mapping/Driver/DoctrineAnnotations.php');
$annotationReader = new AnnotationReader();
$fileCacheReader = new FileCacheReader($annotationReader, $app['cache.path'] . '/doctrine', $app['debug']);
$driverChain = new MappingDriverChain();
DoctrineExtensions::registerAbstractMappingIntoDriverChainORM($driverChain, $fileCacheReader);
$annotationDriver = new AnnotationDriver($annotationReader, [$app['root.path'] . '/lib/Alchemy/Phrasea/Model/Entities']);
$driverChain->addDriver($annotationDriver, 'Alchemy\\Phrasea\\Model\\Entities');
return $driverChain;
});
$app['EM.config'] = $app->share(function (Application $app) {
$config = new ORMConfiguration();
if ($app->getEnvironment() === PhraseaApplication::ENV_DEV) {
$config->setSQLLogger($app['EM.sql-logger']);
}
$config->setMetadataCacheImpl($app['phraseanet.cache-service']->factory('ORMmetadata', $app['EM.opcode-cache-type'], $app['EM.opcode-cache-options']));
$config->setQueryCacheImpl($app['phraseanet.cache-service']->factory('ORMquery', $app['EM.opcode-cache-type'], $app['EM.opcode-cache-options']));
$config->setResultCacheImpl($app['phraseanet.cache-service']->factory('ORMresult', $app['EM.cache-type'], $app['EM.cache-options']));
$config->setAutoGenerateProxyClasses($app['debug']);
$config->setMetadataDriverImpl($app['EM.driver']);
$config->setProxyDir($app['root.path'] . '/resources/proxies');
$config->setProxyNamespace('Alchemy\\Phrasea\\Model\\Proxies');
$config->setAutoGenerateProxyClasses($app['debug']);
$config->addEntityNamespace('Phraseanet', 'Alchemy\\Phrasea\\Model\\Entities');
return $config;
});
$app['EM.opcode-cache-type'] = $app->share(function (Application $app) {
if ($app['configuration.store']->isSetup()) {
return $app['conf']->get(['main', 'opcodecache', 'type']);
}
return 'ArrayCache';
});
$app['EM.opcode-cache-options'] = $app->share(function (Application $app) {
if ($app['configuration.store']->isSetup()) {
return $app['conf']->get(['main', 'opcodecache', 'options']);
}
return [];
});
$app['EM.cache-type'] = $app->share(function (Application $app) {
if ($app['configuration.store']->isSetup()) {
return $app['conf']->get(['main', 'cache', 'type']);
}
return 'ArrayCache';
});
$app['EM.cache-options'] = $app->share(function (Application $app) {
if ($app['configuration.store']->isSetup()) {
return $app['conf']->get(['main', 'cache', 'options']);
}
return [];
});
$app['EM.events-manager'] = $app->share(function (Application $app) {
$evm = new EventManager();
$evm->addEventSubscriber(new TimestampableListener());
return $evm;
});
$app['EM.dbal-conf'] = $app->share(function (Application $app) {
if ('test' === $app->getEnvironment()) {
return $app['conf']->get(['main', 'database-test']);
}
return $app['conf']->get(['main', 'database']);
});
$app['dbal.provider'] = $app->share(function (Application $app) {
return new ConnectionProvider($app['EM.config'], $app['EM.events-manager'], isset($app['task-manager.logger']) ? $app['task-manager.logger'] : $app['monolog']);
});
$app['EM'] = $app->share(function (Application $app) {
try {
$em = EntityManager::create($app['EM.dbal-conf'], $app['EM.config'], $app['EM.events-manager']);
} catch (\Exception $e) {
throw new RuntimeException("Unable to create database connection", $e->getCode(), $e);
}
$platform = $em->getConnection()->getDatabasePlatform();
$types = ['blob' => 'Alchemy\\Phrasea\\Model\\Types\\Blob', 'enum' => 'Alchemy\\Phrasea\\Model\\Types\\Blob', 'longblob' => 'Alchemy\\Phrasea\\Model\\Types\\LongBlob', 'varbinary' => 'Alchemy\\Phrasea\\Model\\Types\\VarBinary', 'binary' => 'Alchemy\\Phrasea\\Model\\Types\\Binary', 'binary_string' => 'Alchemy\\Phrasea\\Model\\Types\\BinaryString'];
foreach ($types as $type => $class) {
if (!Type::hasType($type)) {
Type::addType($type, $class);
}
$platform->registerDoctrineTypeMapping($type, $type);
}
return $em;
});
$app['EM.native-query'] = $app->share(function ($app) {
return new NativeQueryProvider($app['EM']);
});
}
public function register(Application $app)
{
// Provides DSN string using database information
$app['db.dsn'] = $app->protect(function (array $params) use($app) {
$params = $app['db.info']($params);
switch ($params['driver']) {
case 'pdo_mysql':
return sprintf('%s://%s:%s@%s:%s/%s', $params['driver'], $params['user'], $params['password'], $params['host'], $params['port'], $params['dbname']);
case 'pdo_sqlite':
return sprintf('%s:%s', $params['driver'], $params['path']);
default:
throw new \UnexpectedValueException(sprintf('Unknown driver "%s"', $params['driver']));
}
});
// Hash a DSN string
$app['hash.dsn'] = $app->protect(function ($dsn) {
return md5($dsn);
});
// Return database test configuration
$app['db.test.info'] = $app->share(function () use($app) {
return $app['conf']->get(['main', 'database-test'], array());
});
// Return application box database configuration
$app['db.appbox.info'] = $app->share(function () use($app) {
return $app['conf']->get(['main', 'database'], array());
});
// Return database fixture configuration
$app['db.fixture.info'] = $app->share(function () use($app) {
return ['driver' => 'pdo_sqlite', 'path' => sprintf('%s/%s', $app['tmp.path'], 'db-ref.sqlite'), 'charset' => 'UTF8'];
});
// Return databox database configuration
$app['db.databox.info'] = $app->share(function () use($app) {
if (false === $app['phraseanet.configuration']->isSetup()) {
return array();
}
/** @var Connection $connection */
$connection = $app['dbal.provider']($app['db.appbox.info']);
$sql = "SELECT" . " host, port, `user`, COALESCE(pwd, '') AS password, dbname, 'utf8' AS charset, 'pdo_mysql' AS driver" . " FROM sbas";
return $connection->fetchAll($sql);
});
// Return unique key for fixture database
$app['db.fixture.hash.key'] = $app->share(function () use($app) {
$info = $app['db.fixture.info'];
return $app['hash.dsn']($app['db.dsn']($info));
});
// Return unique key for test database
$app['db.test.hash.key'] = $app->share(function () use($app) {
$info = $app['db.test.info'];
return $app['hash.dsn']($app['db.dsn']($info));
});
// Return unique for appbox database
$app['db.appbox.hash.key'] = $app->share(function () use($app) {
$info = $app['db.appbox.info'];
return $app['hash.dsn']($app['db.dsn']($info));
});
// Return configuration option for test database in DoctrineServiceProvider
$app['db.test.options'] = $app->share(function () use($app) {
return array($app['db.test.hash.key'] => $app['db.test.info']);
});
// Return configuration option for test database in DoctrineServiceProvider
$app['db.fixture.options'] = $app->share(function () use($app) {
return array($app['db.fixture.hash.key'] => $app['db.fixture.info']);
});
// Return configuration option for appbox database in DoctrineServiceProvider
$app['db.appbox.options'] = $app->share(function () use($app) {
return array($app['db.appbox.hash.key'] => $app['db.appbox.info']);
});
// Return configuration option for databox databases in DoctrineServiceProvider
$app['dbs.databox.options'] = $app->share(function () use($app) {
$options = array();
foreach ($app['db.databox.info'] as $info) {
$info = $app['db.info']($info);
$key = $app['hash.dsn']($app['db.dsn']($info));
$options[$key] = $info;
}
return $options;
});
// Return DoctrineServiceProvider database options, it merges all previous
// set database configuration
$app['dbs.options'] = $app->share(function () use($app) {
if (false === $app['phraseanet.configuration']->isSetup()) {
return [];
}
return array_merge($app['db.appbox.options'], $app['dbs.databox.options'], $app['db.fixture.options'], $app['db.test.options']);
});
// Return DoctrineORMServiceProvider information for a database from its parameters
$app['orm.em.options.from_info'] = $app->protect(function (array $info) use($app) {
$info = $app['db.info']($info);
$key = $app['hash.dsn']($app['db.dsn']($info));
return array($key => $app['orm.options']($key));
});
//Return DoctrineServiceProvider information for a database from its parameters
$app['db.options.from_info'] = $app->protect(function (array $info) use($app) {
$info = $app['db.info']($info);
$key = $app['hash.dsn']($app['db.dsn']($info));
return array($key => $info);
});
/**
* Add orm on the fly, used only when a new databox is mounted.
* This allow to use new EM instance right after the database is mounted.
*/
$app['orm.add'] = $app->protect(function ($info) use($app) {
$info = $app['db.info']($info);
$key = $app['hash.dsn']($app['db.dsn']($info));
$evm = new EventManager();
$app['dbal.evm.register.listeners']($evm);
$app['dbs.event_manager'][$key] = $evm;
$app['dbs.config'][$key] = new Configuration();
$app['dbs'][$key] = $app['dbs']->share(function () use($app, $info, $key) {
return DriverManager::getConnection($info, $app['dbs.config'][$key], $app['dbs.event_manager'][$key]);
});
$options = $app['orm.options']($key);
$config = $app['orm.config.new']($key, $options);
$app['orm.annotation.register']($key);
$app['orm.ems'][$key] = $app['orm.ems']->share(function ($ems) use($app, $key, $options, $config) {
$connection = $app['dbs'][$key];
$app['connection.pool.manager']->add($connection);
$types = $options['types'];
$app['dbal.type.register']($connection, $types);
return EntityManager::create($connection, $config, $app['dbs.event_manager'][$options['connection']]);
});
return $key;
});
// Listeners should be attached with their events as info.
$app['dbal.evm.listeners'] = $app->share(function () {
return new \SplObjectStorage();
});
$app['dbal.evm.register.listeners'] = $app->protect(function (EventManager $evm) use($app) {
$evm->addEventSubscriber(new TimestampableListener());
/** @var \SplObjectStorage $listeners */
$listeners = $app['dbal.evm.listeners'];
foreach ($listeners as $listener) {
$evm->addEventListener($listeners[$listener], $listener);
}
});
$app['dbal.config.register.loggers'] = $app->protect(function (Configuration $config) use($app) {
if ($app->getEnvironment() === PhraseaApplication::ENV_DEV) {
$config->setSQLLogger($app['orm.query.logger']);
}
});
$app['orm.annotation.register'] = $app->protect(function ($key) use($app) {
$driver = new AnnotationDriver($app['orm.annotation.reader'], array($app['root.path'] . '/vendor/gedmo/doctrine-extensions/lib/Gedmo/Translatable/Entity/MappedSuperclass', $app['root.path'] . '/vendor/gedmo/doctrine-extensions/lib/Gedmo/Loggable/Entity/MappedSuperclass', $app['root.path'] . '/vendor/gedmo/doctrine-extensions/lib/Gedmo/Tree/Entity/MappedSuperclass'));
$app['orm.add_mapping_driver']($driver, 'Gedmo', $key);
});
$app['dbal.type.register'] = $app->protect(function (Connection $connection, $types) {
$platform = $connection->getDatabasePlatform();
foreach (array_keys((array) $types) as $type) {
$platform->registerDoctrineTypeMapping($type, $type);
}
});
$app['orm.config.new'] = $app->protect(function ($key, $options) use($app) {
$config = new ORMConfig();
$app['orm.cache.configurer']($key, $config, $options);
$config->setProxyDir($app['orm.proxies_dir']);
$config->setProxyNamespace($app['orm.proxies_namespace']);
$config->setAutoGenerateProxyClasses($app['orm.auto_generate_proxies']);
$config->setCustomStringFunctions($app['orm.custom.functions.string']);
$config->setCustomNumericFunctions($app['orm.custom.functions.numeric']);
$config->setCustomDatetimeFunctions($app['orm.custom.functions.datetime']);
$config->setCustomHydrationModes($app['orm.custom.hydration_modes']);
$config->setClassMetadataFactoryName($app['orm.class_metadata_factory_name']);
$config->setDefaultRepositoryClassName($app['orm.default_repository_class']);
$config->setEntityListenerResolver($app['orm.entity_listener_resolver']);
$config->setRepositoryFactory($app['orm.repository_factory']);
$config->setNamingStrategy($app['orm.strategy.naming']);
$config->setQuoteStrategy($app['orm.strategy.quote']);
$chain = $app['orm.mapping_driver_chain.locator']($key);
foreach ((array) $options['mappings'] as $entity) {
if (!is_array($entity)) {
throw new \InvalidArgumentException("The 'orm.em.options' option 'mappings' should be an array of arrays.");
}
if (!empty($entity['resources_namespace'])) {
$entity['path'] = $app['psr0_resource_locator']->findFirstDirectory($entity['resources_namespace']);
}
if (isset($entity['alias'])) {
$config->addEntityNamespace($entity['alias'], $entity['namespace']);
}
switch ($entity['type']) {
case 'annotation':
$useSimpleAnnotationReader = isset($entity['use_simple_annotation_reader']) ? $entity['use_simple_annotation_reader'] : true;
$driver = $config->newDefaultAnnotationDriver((array) $entity['path'], $useSimpleAnnotationReader);
$chain->addDriver($driver, $entity['namespace']);
break;
case 'yml':
$driver = new YamlDriver($entity['path']);
$chain->addDriver($driver, $entity['namespace']);
break;
case 'simple_yml':
$driver = new SimplifiedYamlDriver(array($entity['path'] => $entity['namespace']));
$chain->addDriver($driver, $entity['namespace']);
break;
case 'xml':
$driver = new XmlDriver($entity['path']);
$chain->addDriver($driver, $entity['namespace']);
break;
case 'simple_xml':
$driver = new SimplifiedXmlDriver(array($entity['path'] => $entity['namespace']));
$chain->addDriver($driver, $entity['namespace']);
break;
case 'php':
$driver = new StaticPHPDriver($entity['path']);
$chain->addDriver($driver, $entity['namespace']);
break;
default:
throw new \InvalidArgumentException(sprintf('"%s" is not a recognized driver', $entity['type']));
break;
}
}
$config->setMetadataDriverImpl($chain);
foreach ((array) $options['types'] as $typeName => $typeClass) {
if (Type::hasType($typeName)) {
Type::overrideType($typeName, $typeClass);
} else {
Type::addType($typeName, $typeClass);
}
}
return $config;
});
$app['orm.ems.options'] = $app->share(function () use($app) {
if (false === $app['phraseanet.configuration']->isSetup()) {
return [];
}
return array_merge($app['orm.em.appbox.options'], $app['orm.ems.databox.options'], $app['orm.em.fixture.options'], $app['orm.em.test.options']);
});
/**
* Check database connection information
*/
$app['db.info'] = $app->protect(function (array $info) {
if (!isset($info['driver'])) {
$info['driver'] = 'pdo_mysql';
}
if (!isset($info['charset'])) {
$info['charset'] = 'utf8';
}
switch ($info['driver']) {
case 'pdo_mysql':
foreach (array('user', 'password', 'host', 'dbname', 'port') as $param) {
if (!array_key_exists($param, $info)) {
throw new InvalidArgumentException(sprintf('Missing "%s" argument for database connection using driver %s', $param, $info['driver']));
}
}
break;
case 'pdo_sqlite':
if (!array_key_exists('path', $info)) {
throw new InvalidArgumentException(sprintf('Missing "path" argument for database connection using driver %s', $info['driver']));
}
break;
}
return $info;
});
/**
* Return configuration option for appbox database in DoctrineORMServiceProvider
*/
$app['orm.em.appbox.options'] = $app->share(function () use($app) {
$key = $app['db.appbox.hash.key'];
return array($key => $app['orm.options']($key));
});
/**
* Return configuration option for fixture database in DoctrineORMServiceProvider
*/
$app['orm.em.fixture.options'] = $app->share(function () use($app) {
$key = $app['db.fixture.hash.key'];
return array($key => $app['orm.options']($key));
});
/**
* Return configuration option for test database in DoctrineORMServiceProvider
*/
$app['orm.em.test.options'] = $app->share(function () use($app) {
$key = $app['db.test.hash.key'];
return array($key => $app['orm.options']($key));
});
/**
* Return configuration option for databox databases in DoctrineORMServiceProvider
*/
$app['orm.ems.databox.options'] = $app->share(function () use($app) {
$options = array();
foreach ($app['db.databox.info'] as $base) {
$info = $app['db.info']($base);
$key = $app['hash.dsn']($app['db.dsn']($info));
$options[$key] = $app['orm.options']($key);
}
return $options;
});
$app['orm.options.mappings'] = $app->share(function (PhraseaApplication $app) {
return array(array("type" => "annotation", "alias" => "Phraseanet", "use_simple_annotation_reader" => false, "namespace" => 'Alchemy\\Phrasea\\Model\\Entities', "path" => $app['root.path'] . '/lib/Alchemy/Phrasea/Model/Entities'));
});
// Return orm configuration for a connection given its unique id
$app['orm.options'] = $app->protect(function ($connection) use($app) {
return array("connection" => $connection, "mappings" => $app['orm.options.mappings'], "types" => array('blob' => 'Alchemy\\Phrasea\\Model\\Types\\Blob', 'enum' => 'Alchemy\\Phrasea\\Model\\Types\\Enum', 'longblob' => 'Alchemy\\Phrasea\\Model\\Types\\LongBlob', 'varbinary' => 'Alchemy\\Phrasea\\Model\\Types\\VarBinary', 'binary' => 'Alchemy\\Phrasea\\Model\\Types\\Binary', 'binary_string' => 'Alchemy\\Phrasea\\Model\\Types\\BinaryString'));
});
/**
* Path to doctrine log file
*/
$app['orm.monolog.handler.file'] = $app->share(function (Application $app) {
return $app['log.path'] . '/doctrine.log';
});
/**
* Maximum files of logs
*/
$app['orm.monolog.handler.file.max-files'] = 5;
/**
* Monolog handler for doctrine
*/
$app['orm.monolog.handler'] = $app->share(function (Application $app) {
return new RotatingFileHandler($app['orm.monolog.handler.file'], $app['orm.monolog.handler.file.max-files']);
});
/**
* Monolog instance for doctrine
*/
$app['orm.monolog.logger'] = $app->share(function (Application $app) {
$logger = new $app['monolog.logger.class']('doctrine-logger');
$logger->pushHandler($app['orm.monolog.handler']);
return $logger;
});
/**
* Doctrine query logger
*/
$app['orm.query.logger'] = $app->share(function () {
return new DebugStack();
});
/**
* Return cache driver
*/
$app['orm.cache.driver'] = $app->share(function (Application $app) {
if ($app['configuration.store']->isSetup()) {
return $app['conf']->get(['main', 'cache', 'type']);
}
return 'array';
});
/**
* Return cache options
*/
$app['orm.cache.options'] = $app->share(function (Application $app) {
if ($app['configuration.store']->isSetup()) {
return $app['conf']->get(['main', 'cache', 'options']);
}
return [];
});
/**
* Retrieve a registered DBALConnection using configuration parameters
*/
$app['db.provider'] = $app->protect(function (array $info) use($app) {
$info = $app['db.info']($info);
$key = $app['hash.dsn']($app['db.dsn']($info));
if (!isset($app['dbs'][$key])) {
return $app['dbal.provider']($info);
}
return $app['dbs'][$key];
});
// Returns a new DBALConnection instance using configuration parameters
$app['dbal.provider'] = $app->protect(function (array $info) use($app) {
$info = $app['db.info']($info);
/** @var ConnectionPoolManager $manager */
$manager = $app['connection.pool.manager'];
return $manager->get($info);
});
$app['connection.pool.manager'] = $app->share(function () {
return new ConnectionPoolManager();
});
/**
* Return an instance of native cache query for default ORM
* @todo return an instance of NativeQueryProvider for given orm;
*/
$app['orm.em.native-query'] = $app->share(function ($app) {
return new NativeQueryProvider($app['orm.em']);
});
/**
* Return an instance of annotation cache reader
*/
$app['orm.annotation.reader'] = $app->share(function () use($app) {
$cache = new ArrayCache();
if ($app->getEnvironment() !== PhraseaApplication::ENV_DEV) {
$cache = $app['phraseanet.cache-service']->factory('ORM_annotation', $app['orm.cache.driver'], $app['orm.cache.options']);
}
return new CachedReader(new AnnotationReader(), $cache);
});
}
