console-config.php 6.5 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207
  1. <?php
  2. /* For licensing terms, see /license.txt */
  3. $config = new \Doctrine\ORM\Configuration();
  4. $config->setMetadataCacheImpl(new \Doctrine\Common\Cache\ArrayCache);
  5. use Doctrine\Common\Annotations\AnnotationReader;
  6. use Doctrine\Common\Annotations\AnnotationRegistry;
  7. use Symfony\Component\Yaml\Parser;
  8. $sysPath = __DIR__."../../";
  9. AnnotationRegistry::registerFile($sysPath."vendor/doctrine/orm/lib/Doctrine/ORM/Mapping/Driver/DoctrineAnnotations.php");
  10. $reader = new AnnotationReader();
  11. $driverImpl = new \Doctrine\ORM\Mapping\Driver\AnnotationDriver($reader, array($sysPath."tests/doctrine_console/mapping"));
  12. $config->setMetadataDriverImpl($driverImpl);
  13. $config->setProxyDir(__DIR__ . '/Proxies');
  14. $config->setProxyNamespace('Proxies');
  15. $courseList = CourseManager::get_real_course_list();
  16. $configurationPath = $sysPath.'main/inc/conf/';
  17. $newConfigurationFile = $configurationPath.'configuration.yml';
  18. //Including configuration.php
  19. $configurationFile = $configurationPath.'configuration.php';
  20. if (is_file($configurationFile) && file_exists($configurationFile)) {
  21. require $configurationFile;
  22. }
  23. //Merge with the configuration.yml file, if exits
  24. if (is_file($newConfigurationFile) && file_exists($newConfigurationFile)) {
  25. $yaml = new Parser();
  26. $_configurationYML = $yaml->parse(file_get_contents($newConfigurationFile));
  27. if (!empty($_configurationYML)) {
  28. if (isset($_configuration)) {
  29. $_configuration = array_merge($_configuration, $_configurationYML);
  30. } else {
  31. $_configuration = $_configurationYML;
  32. }
  33. }
  34. }
  35. $app['chamilo.log'] = $app['cache.path'].'chamilo-cli.log';
  36. // Loading db connections
  37. $connectionOptions = array();
  38. if (!empty($courseList)) {
  39. $dbPrefix = isset($_configuration['db_prefix']) && !empty($_configuration['db_prefix']) ? $_configuration['db_prefix'].$_configuration['db_glue'] : null;
  40. foreach ($courseList as $course) {
  41. $connectionOptions['_chamilo_course_'.$course['db_name']] = array(
  42. 'driver' => 'pdo_mysql',
  43. 'dbname' => $dbPrefix.$course['db_name'],
  44. 'user' => $_configuration['db_user'],
  45. 'password' => $_configuration['db_password'],
  46. 'host' => $_configuration['db_host'],
  47. );
  48. }
  49. }
  50. if (isset($_configuration['main_database'])) {
  51. $connectionOptions['main_database'] = array(
  52. 'driver' => 'pdo_mysql',
  53. 'dbname' => $_configuration['main_database'],
  54. 'user' => $_configuration['db_user'],
  55. 'password' => $_configuration['db_password'],
  56. 'host' => $_configuration['db_host'],
  57. );
  58. }
  59. if (isset($_configuration['statistics_database'])) {
  60. $connectionOptions['statistics_database'] = array(
  61. 'driver' => 'pdo_mysql',
  62. 'dbname' => $_configuration['statistics_database'],
  63. 'user' => $_configuration['db_user'],
  64. 'password' => $_configuration['db_password'],
  65. 'host' => $_configuration['db_host'],
  66. );
  67. } else {
  68. if (isset($_configuration['main_database'])) {
  69. $connectionOptions['statistics_database'] = $connectionOptions['main_database'];
  70. }
  71. }
  72. if (isset($_configuration['user_personal_database'])) {
  73. $connectionOptions['user_personal_database'] = array(
  74. 'driver' => 'pdo_mysql',
  75. 'dbname' => $_configuration['user_personal_database'],
  76. 'user' => $_configuration['db_user'],
  77. 'password' => $_configuration['db_password'],
  78. 'host' => $_configuration['db_host'],
  79. );
  80. } else {
  81. if (isset($_configuration['main_database'])) {
  82. $connectionOptions['user_personal_database'] = $connectionOptions['main_database'];
  83. }
  84. }
  85. $defaultConnection = array(
  86. 'driver' => 'pdo_mysql'
  87. );
  88. if (isset($_configuration['main_database'])) {
  89. $defaultConnection = array(
  90. 'driver' => 'pdo_mysql',
  91. 'dbname' => $_configuration['main_database'],
  92. 'user' => $_configuration['db_user'],
  93. 'password' => $_configuration['db_password'],
  94. 'host' => $_configuration['db_host'],
  95. );
  96. }
  97. $em = \Doctrine\ORM\EntityManager::create($defaultConnection, $config);
  98. //Fixes some errors
  99. $platform = $em->getConnection()->getDatabasePlatform();
  100. $platform->registerDoctrineTypeMapping('enum', 'string');
  101. $platform->registerDoctrineTypeMapping('set', 'string');
  102. $helpers = array(
  103. 'db' => new \Doctrine\DBAL\Tools\Console\Helper\ConnectionHelper($em->getConnection()),
  104. 'em' => new \Doctrine\ORM\Tools\Console\Helper\EntityManagerHelper($em),
  105. 'configuration' => new \Chash\Helpers\ConfigurationHelper()
  106. );
  107. use Doctrine\DBAL\DriverManager;
  108. $multipleEM = array();
  109. foreach ($connectionOptions as $name => $connection) {
  110. $em = \Doctrine\ORM\EntityManager::create($connection, $config);
  111. //$helpers[$name] = new \Doctrine\ORM\Tools\Console\Helper\EntityManagerHelper($em);
  112. $helpers[$name] = new \Doctrine\DBAL\Tools\Console\Helper\ConnectionHelper($em->getConnection());
  113. }
  114. /*
  115. To generate doctrine2 entities you must:
  116. cd /var/www/chamilo11/tests/doctrine_console
  117. Delete old mappings/entities
  118. sudo rm -R mapping generated repository
  119. Creating the mapping from the DB
  120. sudo mkdir mapping generated repository
  121. You can add a Namespace if you want to with: --namespace "Entity"
  122. sudo php5 doctrine.php orm:convert-mapping --force --from-database --namespace "Entity" annotation mapping
  123. 1. Generate entities
  124. sudo php5 doctrine.php orm:generate-entities --generate-annotations="true" generated
  125. Validate schema
  126. sudo php5 doctrine.php orm:validate-schema -v
  127. Move generated files in a chamilo folder:
  128. sudo rm -R main/inc/Entity/*
  129. mkdir main/inc/Entity
  130. cp -R tests/doctrine_console/generated/* main/inc/Entity
  131. fixes \ORM bug see http://redgreenrefactor.blogsite.org/php/code-first-approaching-php-with-doctrine-2-2-1-and-composer/
  132. cd main/inc/Entity
  133. sed -i 's/@ORM\\/@/g' *.php
  134. For tests
  135. php5 tests/doctrine_console/doctrine.php orm:generate-entities --generate-annotations="true" main/inc/Entity
  136. Then autoload classes with composer
  137. sudo php5 composer.phar update or sudo composer.phar update
  138. 2. Migrations
  139. a. Generate empty migration file
  140. cd /var/www/chamilo11/tests/doctrine_console
  141. php5 doctrine.php migrations:generate
  142. b. Check status
  143. php5 doctrine.php migrations:status
  144. c. Check sql
  145. php5 doctrine.php migrations:migrate --dry-run
  146. d. execute migration
  147. php5 doctrine.php migrations:migrate
  148. e. Revert migrations
  149. php5 doctrine.php migrations:migrate 0
  150. http://docs.doctrine-project.org/projects/doctrine-migrations/en/latest/reference/managing_migrations.html
  151. */