cli-config.php 6.2 KB

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