Set the migration table name
| public setMigrationsTableName ( string $tableName ) | ||
| $tableName | string | The migration table name |
public function indexAction()
{
$container = $this->container;
$conn = $this->get('doctrine')->getConnection();
$dir = $container->getParameter('doctrine_migrations.dir_name');
if (!file_exists($dir)) {
mkdir($dir, 0777, true);
}
$configuration = new Configuration($conn);
$configuration->setMigrationsNamespace($container->getParameter('doctrine_migrations.namespace'));
$configuration->setMigrationsDirectory($dir);
$configuration->registerMigrationsFromDirectory($dir);
$configuration->setName($container->getParameter('doctrine_migrations.name'));
$configuration->setMigrationsTableName($container->getParameter('doctrine_migrations.table_name'));
$versions = $configuration->getMigrations();
foreach ($versions as $version) {
$migration = $version->getMigration();
if ($migration instanceof ContainerAwareInterface) {
$migration->setContainer($container);
}
}
$migration = new Migration($configuration);
$migrated = $migration->migrate();
// ...
}
/**
* Bootstraps the application.
*
* This method is called after all services are registered
* and should be used for "dynamic" configuration (whenever
* a service must be requested).
* @param Application $app
*/
public function boot(Application $app)
{
if (php_sapi_name() === 'cli') {
$app['console.commands'] = $app->extend('console.commands', function ($commands) use($app) {
$migrationCommands = [new Proxy\DiffCommandProxy(), new Proxy\ExecuteCommandProxy(), new Proxy\GenerateCommandProxy(), new Proxy\LatestCommandProxy(), new Proxy\MigrateCommandProxy(), new Proxy\StatusCommandProxy(), new Proxy\VersionCommandProxy()];
if (isset($app['migrations.directory'])) {
$config = new Configuration($app['db']);
$config->setMigrationsDirectory($app['migrations.directory']);
$config->setMigrationsNamespace('DocMigrations');
$config->setMigrationsTableName('doc_migrations');
$config->registerMigrationsFromDirectory($app['migrations.directory']);
/** @var AbstractCommand $cmd */
foreach ($migrationCommands as $cmd) {
$cmd->setMigrationConfiguration($config);
}
}
return array_merge($commands, $migrationCommands, [new Proxy\ClearMetadataCacheDoctrineCommand(), new Proxy\ClearQueryCacheDoctrineCommand(), new Proxy\ClearResultCacheDoctrineCommand(), new Proxy\ConvertMappingDoctrineCommand(), new Proxy\CreateSchemaDoctrineCommand(), new Proxy\DropSchemaDoctrineCommand(), new Proxy\EnsureProductionSettingsDoctrineCommand(), new Proxy\InfoDoctrineCommand(), new Proxy\RunDqlDoctrineCommand(), new Proxy\RunSqlDoctrineCommand(), new Proxy\UpdateSchemaDoctrineCommand(), new Proxy\UpdateSchemaDoctrineCommand(), new Proxy\ValidateSchemaCommand(), new Proxy\GenProxiesDoctrineCommand(), new CreateDatabaseDoctrineCommand(), new DropDatabaseDoctrineCommand()]);
});
if (isset($app['console'])) {
$app['console'] = $app->share($app->extend('console', function (ConsoleApplication $consoleApplication) use($app) {
$helperSet = $consoleApplication->getHelperSet();
$helperSet->set(new ManagerRegistryHelper($app['doctrine']), 'doctrine');
return $consoleApplication;
}));
}
}
}
/**
* @param Connection $connection
* @param AppKernel $kernel
*
* @throws \Claroline\MigrationBundle\Migrator\InvalidDirectionException
* @throws \Claroline\MigrationBundle\Migrator\InvalidVersionException
* @throws \Doctrine\DBAL\Migrations\MigrationException
*/
protected function migrateBadgeTables(Connection $connection, AppKernel $kernel)
{
$portfolioBundle = $this->container->get('claroline.persistence.object_manager')->getRepository('ClarolineCoreBundle:Plugin')->findBy(array('vendorName' => 'Icap', 'bundleName' => 'PortfolioBundle'));
$portfolioBundle = count($portfolioBundle) === 1 ? true : false;
if (!$portfolioBundle && $connection->getSchemaManager()->tablesExist(['icap__portfolio_widget_badges'])) {
$this->log('Deleting portfolios badges tables...');
$connection->getSchemaManager()->dropTable('icap__portfolio_widget_badges_badge');
$connection->getSchemaManager()->dropTable('icap__portfolio_widget_badges');
$this->log('Portfolios badges tables deleted.');
}
if ($portfolioBundle && !$connection->getSchemaManager()->tablesExist(['icap__portfolio_widget_badges'])) {
$badgeBundle = $kernel->getBundle('IcapBadgeBundle');
$this->log('Executing migrations for portfolio interaction');
$migrationsDir = "{$badgeBundle->getPath()}/Installation/Migrations";
$migrationsName = "{$badgeBundle->getName()} migration";
$migrationsNamespace = "{$badgeBundle->getNamespace()}\\Installation\\Migrations";
$migrationsTableName = 'doctrine_' . strtolower($badgeBundle->getName()) . '_versions';
$config = new Configuration($connection);
$config->setName($migrationsName);
$config->setMigrationsDirectory($migrationsDir);
$config->setMigrationsNamespace($migrationsNamespace);
$config->setMigrationsTableName($migrationsTableName);
$config->registerMigrationsFromDirectory($migrationsDir);
$migration = new Migration($config);
$executedQueriesNumber = $migration->migrate('20150929141509');
$this->log(sprintf('%d queries executed', $executedQueriesNumber));
}
}
public function boot(Application $app)
{
$app['dispatcher']->addListener(ConsoleEvents::INIT, function (ConsoleEvent $event) use($app) {
$console = $event->getConsole();
$helpers = ['dialog' => new QuestionHelper()];
if (isset($app['orm.em'])) {
$helpers['em'] = new EntityManagerHelper($app['orm.em']);
}
$helperSet = new HelperSet($helpers);
$console->setHelperSet($helperSet);
$config = new Configuration($app['db']);
$config->setMigrationsNamespace($app['db.migrations.namespace']);
if ($app['db.migrations.path']) {
$config->setMigrationsDirectory($app['db.migrations.path']);
$config->registerMigrationsFromDirectory($app['db.migrations.path']);
}
if ($app['db.migrations.name']) {
$config->setName($app['db.migrations.name']);
}
if ($app['db.migrations.table_name']) {
$config->setMigrationsTableName($app['db.migrations.table_name']);
}
$commands = [new Command\DiffCommand(), new Command\ExecuteCommand(), new Command\GenerateCommand(), new Command\MigrateCommand(), new Command\StatusCommand(), new Command\VersionCommand()];
foreach ($commands as $command) {
/** @var \Doctrine\DBAL\Migrations\Tools\Console\Command\AbstractCommand $command */
$command->setMigrationConfiguration($config);
$console->add($command);
}
});
}
/**
* @param Connection $connection
* @param AppKernel $kernel
*/
public function preUpdate(Connection $connection, AppKernel $kernel)
{
/** @var \Symfony\Component\HttpKernel\Bundle\Bundle[] $bundles */
$bundles = $kernel->getBundles();
$isPortfolioBundleInstalled = false;
foreach ($bundles as $bundle) {
if ('IcapPortfolioBundle' === $bundle->getName()) {
$isPortfolioBundleInstalled = true;
}
}
if ($connection->getSchemaManager()->tablesExist(['icap__portfolio_widget_badges'])) {
if ($isPortfolioBundleInstalled) {
$this->log('Found existing database schema: skipping install migration...');
$config = new Configuration($connection);
$config->setMigrationsTableName('doctrine_icapbadgebundle_versions');
$config->setMigrationsNamespace('claro_badge');
// required but useless
$config->setMigrationsDirectory('claro_badge');
// idem
try {
$version = new Version($config, '20150929141509', 'stdClass');
$version->markMigrated();
} catch (\Exception $e) {
$this->log('Already migrated');
}
} else {
$this->log('Deleting badges tables for portfolio...');
$connection->getSchemaManager()->dropTable('icap__portfolio_widget_badges_badge');
$connection->getSchemaManager()->dropTable('icap__portfolio_widget_badges');
$this->log('badges tables for portfolio deleted.');
}
}
}
/**
* {@inheritdoc}
*/
public function register(Container $c)
{
$c['migrations.apps'] = function ($c) {
$apps = new Container();
foreach ($c['migrations.options'] as $key => $options) {
$apps[$key] = function () use($c, $key, $options) {
$db = $c['dbs'][$key];
return $c['migrations.create_app']($c['migrations.create_helpers']($db), $c['migrations.create_commands']($db, $options));
};
}
return $apps;
};
$c['migrations.create_app'] = $c->protect(function ($helpers, $commands) {
return ConsoleRunner::createApplication($helpers, $commands);
});
$c['migrations.create_helpers'] = $c->protect(function ($db) {
return new HelperSet(['db' => new ConnectionHelper($db), 'dialog' => new QuestionHelper()]);
});
$c['migrations.create_commands'] = $c->protect(function ($db, $options) {
$config = new Configuration($db);
if (isset($options['namespace'])) {
$config->setMigrationsNamespace($options['namespace']);
}
$config->setMigrationsDirectory($options['path']);
$config->registerMigrationsFromDirectory($options['path']);
if (isset($options['table'])) {
$config->setMigrationsTableName($options['table']);
}
$commands = [new DiffCommand(), new ExecuteCommand(), new GenerateCommand(), new MigrateCommand(), new StatusCommand(), new VersionCommand()];
foreach ($commands as $command) {
$command->setMigrationConfiguration($config);
}
return $commands;
});
}
public static function create(Connection $connection)
{
$directory = __DIR__ . "/../app/migrations";
$configuration = new Configuration($connection);
$configuration->setMigrationsNamespace('DoctrineMigrations');
$configuration->setMigrationsTableName('migrations');
$configuration->setMigrationsDirectory($directory);
$configuration->registerMigrationsFromDirectory($directory);
return $configuration;
}
public static function configureMigrationsForBundle(Application $application, $bundle, Configuration $configuration)
{
$bundle = $application->getKernel()->getBundle($bundle);
$dir = $bundle->getPath() . '/DoctrineMigrations';
$configuration->setMigrationsNamespace($bundle->getNamespace() . '\\DoctrineMigrations');
$configuration->setMigrationsDirectory($dir);
$configuration->registerMigrationsFromDirectory($dir);
$configuration->setName($bundle->getName() . ' Migrations');
$configuration->setMigrationsTableName(Inflector::tableize($bundle->getName()) . '_migration_versions');
}
/**
* @param string $dir
* @param \Closure $outputWriter
*
* @return Configuration
*/
private function getConfiguration($dir, \Closure $outputWriter = null)
{
$connection = $this->container->get('database_connection');
$configuration = new Configuration($connection, new OutputWriter($outputWriter));
$configuration->setMigrationsNamespace($this->container->getParameter('doctrine_migrations.namespace'));
$configuration->setMigrationsDirectory($dir);
$configuration->registerMigrationsFromDirectory($dir);
$configuration->setName($this->container->getParameter('doctrine_migrations.name'));
$configuration->setMigrationsTableName($this->container->getParameter('doctrine_migrations.table_name'));
return $configuration;
}
private function buildVersion($bundle, $version)
{
$bundle = strtolower($bundle);
$config = new Configuration($this->connection);
$config->setMigrationsTableName('doctrine_' . $bundle . '_versions');
$config->setMigrationsNamespace(ucfirst($bundle));
// required but useless
$config->setMigrationsDirectory(ucfirst($bundle));
// idem
return new Version($config, $version, 'stdClass');
}
public static function configureMigrations(ContainerInterface $container, Configuration $configuration)
{
if (!$configuration->getMigrationsDirectory()) {
$dir = $container->getParameter('doctrine_migrations.dir_name');
if (!file_exists($dir)) {
mkdir($dir, 0777, true);
}
$configuration->setMigrationsDirectory($dir);
} else {
$dir = $configuration->getMigrationsDirectory();
// class Kernel has method getKernelParameters with some of the important path parameters
$pathPlaceholderArray = array('kernel.root_dir', 'kernel.cache_dir', 'kernel.logs_dir');
foreach ($pathPlaceholderArray as $pathPlaceholder) {
if ($container->hasParameter($pathPlaceholder) && preg_match('/\\%' . $pathPlaceholder . '\\%/', $dir)) {
$dir = str_replace('%' . $pathPlaceholder . '%', $container->getParameter($pathPlaceholder), $dir);
}
}
if (!file_exists($dir)) {
mkdir($dir, 0777, true);
}
$configuration->setMigrationsDirectory($dir);
}
if (!$configuration->getMigrationsNamespace()) {
$configuration->setMigrationsNamespace($container->getParameter('doctrine_migrations.namespace'));
}
if (!$configuration->getName()) {
$configuration->setName($container->getParameter('doctrine_migrations.name'));
}
// For backward compatibility, need use a table from parameters for overwrite the default configuration
if (!$configuration->getMigrationsTableName() || !$configuration instanceof AbstractFileConfiguration) {
$configuration->setMigrationsTableName($container->getParameter('doctrine_migrations.table_name'));
}
// Migrations is not register from configuration loader
if (!$configuration instanceof AbstractFileConfiguration) {
$configuration->registerMigrationsFromDirectory($configuration->getMigrationsDirectory());
}
if ($container->hasParameter('doctrine_migrations.organize_migrations')) {
$organizeMigrations = $container->getParameter('doctrine_migrations.organize_migrations');
switch ($organizeMigrations) {
case Configuration::VERSIONS_ORGANIZATION_BY_YEAR:
$configuration->setMigrationsAreOrganizedByYear(true);
break;
case Configuration::VERSIONS_ORGANIZATION_BY_YEAR_AND_MONTH:
$configuration->setMigrationsAreOrganizedByYearAndMonth(true);
break;
case false:
break;
default:
throw new InvalidConfigurationException('Unrecognized option "' . $organizeMigrations . '" under "organize_migrations"');
}
}
self::injectContainerToMigrations($container, $configuration->getMigrations());
}
public static function configureMigrations(ContainerInterface $container, Configuration $configuration)
{
$dir = $container->getParameter('doctrine_migrations.dir_name');
if (!file_exists($dir)) {
mkdir($dir, 0777, true);
}
$configuration->setMigrationsNamespace($container->getParameter('doctrine_migrations.namespace'));
$configuration->setMigrationsDirectory($dir);
$configuration->registerMigrationsFromDirectory($dir);
$configuration->setName($container->getParameter('doctrine_migrations.name'));
$configuration->setMigrationsTableName($container->getParameter('doctrine_migrations.table_name'));
}
protected function configureMigrations(Container $container, Configuration $config)
{
$dir = $container['doctrine.migrations.dir_name'];
if (!file_exists($dir)) {
mkdir($dir, 0777, true);
}
$config->setMigrationsNamespace($container['doctrine.migrations.namespace']);
$config->setMigrationsDirectory($dir);
$config->registerMigrationsFromDirectory($dir);
$config->setName($container['doctrine.migrations.name']);
$config->setMigrationsTableName($container['doctrine.migrations.table_name']);
}
public function migrationSchema($app, $migrationFilePath, $pluginCode, $version = null)
{
$config = new Configuration($app['db']);
$config->setMigrationsNamespace('DoctrineMigrations');
$config->setMigrationsDirectory($migrationFilePath);
$config->registerMigrationsFromDirectory($migrationFilePath);
$config->setMigrationsTableName(self::MIGRATION_TABLE_PREFIX . $pluginCode);
$migration = new Migration($config);
// null 又は 'last' を渡すと最新バージョンまでマイグレートする
// 0か'first'を渡すと最初に戻る
$migration->migrate($version, false);
}
protected function configureMigrations(ContainerInterface $container, Configuration $configuration)
{
$dir = $container->getParameter('ezpublish_migrations.dir_name');
if (!file_exists($dir)) {
mkdir($dir, 0777, true);
}
$configuration->setMigrationsNamespace($container->getParameter('ezpublish_migrations.namespace'));
$configuration->setMigrationsDirectory($dir);
$configuration->registerMigrationsFromDirectory($dir);
$configuration->setName($container->getParameter('ezpublish_migrations.name'));
$configuration->setMigrationsTableName($container->getParameter('ezpublish_migrations.table_name'));
self::injectContainerToMigrations($container, $configuration->getMigrations());
}
public static function configureMigrationsForBundle(Application $application, $bundle, Configuration $configuration)
{
$configuration->setMigrationsNamespace($bundle . '\\DoctrineMigrations');
$dirs = $application->getKernel()->getBundleDirs();
$tmp = str_replace('\\', '/', $bundle);
$namespace = str_replace('/', '\\', dirname($tmp));
$bundle = basename($tmp);
$dir = $dirs[$namespace] . '/' . $bundle . '/DoctrineMigrations';
$configuration->setMigrationsDirectory($dir);
$configuration->registerMigrationsFromDirectory($dir);
$configuration->setName($bundle . ' Migrations');
$configuration->setMigrationsTableName(Inflector::tableize($bundle) . '_migration_versions');
}
private function skipInstallIfMigratingFromCore()
{
if ($this->conn->getSchemaManager()->tablesExist(['claro_event'])) {
$this->log('Found existing database schema: skipping install migration...');
$config = new Configuration($this->conn);
$config->setMigrationsTableName('doctrine_clarolineagendabundle_versions');
$config->setMigrationsNamespace('claro_event');
// required but useless
$config->setMigrationsDirectory('claro_event');
// idem
$version = new Version($config, '20150429110105', 'stdClass');
$version->markMigrated();
}
}
/**
* @param HelperSet $helperSet
*
* @return array
*/
public function getConsoleCommands(HelperSet $helperSet)
{
$configuration = new Configuration($this->em->getConnection());
$configuration->setMigrationsNamespace($this->config->getMigrationsNamespace());
$configuration->setMigrationsDirectory($this->config->getMigrationsPath());
$configuration->setMigrationsTableName($this->config->getMigrationsTable());
$commands = [new DiffCommand(), new ExecuteCommand(), new GenerateCommand(), new LatestCommand(), new MigrateCommand(), new StatusCommand(), new VersionCommand()];
/** @var AbstractCommand $command */
foreach ($commands as $command) {
$command->setHelperSet($helperSet);
$command->setMigrationConfiguration($configuration);
}
return $commands;
}
public function preInstall()
{
if ($this->conn->getSchemaManager()->tablesExist(['claro_message'])) {
$this->log('Found existing database schema: skipping install migration...');
$config = new Configuration($this->conn);
$config->setMigrationsTableName('doctrine_clarolinemessagebundle_versions');
$config->setMigrationsNamespace('claro_message');
// required but useless
$config->setMigrationsDirectory('claro_message');
// idem
$version = new Version($config, '20150429114010', 'stdClass');
$version->markMigrated();
}
}
/**
* {@inheritDoc}
*
* @return \Doctrine\DBAL\Migrations\Configuration\Configuration
*/
public function createService(ServiceLocatorInterface $serviceLocator)
{
$name = $this->getName();
/* @var $connection \Doctrine\DBAL\Connection */
$connection = $serviceLocator->get('doctrine.connection.' . $name);
$appConfig = $serviceLocator->get('Config');
$migrationsConfig = $appConfig['doctrine']['migrations_configuration'][$name];
$configuration = new Configuration($connection);
$configuration->setName($migrationsConfig['name']);
$configuration->setMigrationsDirectory($migrationsConfig['directory']);
$configuration->setMigrationsNamespace($migrationsConfig['namespace']);
$configuration->setMigrationsTableName($migrationsConfig['table']);
$configuration->registerMigrationsFromDirectory($migrationsConfig['directory']);
return $configuration;
}
public function loadProviders(Application $app)
{
$app->register(new Provider\MonologServiceProvider(), $app['monolog.config']);
$app->register(new Provider\DoctrineServiceProvider());
// connect to db
// \SimpleRecord\Record::connection($app['db']);
$models = ['post.model' => 'App\\Model\\Post', 'tag.model' => 'App\\Model\\Tag', 'post_tags.model' => 'App\\Model\\PostTags'];
foreach ($models as $name => $class) {
if (is_callable($class)) {
$callable = $class;
} else {
$callable = function () use($class, $app) {
return new $class($app);
};
}
$app[$name] = $app->factory($callable);
}
$app['migrations.output_writer'] = new OutputWriter(function ($message) {
$output = new ConsoleOutput();
$output->writeln($message);
});
$app['migrations.configuration'] = function () use($app) {
$configuration = new Configuration($app['db'], $app['migrations.output_writer']);
$configuration->setMigrationsDirectory($app['migrations']['directory']);
$configuration->setName($app['migrations']['name']);
$configuration->setMigrationsNamespace($app['migrations']['namespace']);
$configuration->setMigrationsTableName($app['migrations']['table_name']);
$configuration->registerMigrationsFromDirectory($app['migrations']['directory']);
return $configuration;
};
$app->register(new Provider\TwigServiceProvider(), ['twig.path' => $app['root.path'] . '/templates/', 'twig.form.templates' => ['bootstrap_3_horizontal_layout.html.twig'], 'twig.options' => ['cache' => $app['cache.path'] . '/twig']]);
$app->register(new Provider\AssetServiceProvider(), ['assets.named_packages' => ['css' => ['version' => 'v1', 'base_path' => '/asset/css'], 'js' => ['version' => 'v1', 'base_path' => '/asset/js']]]);
$app->register(new Provider\SecurityServiceProvider());
$app->register(new Provider\RoutingServiceProvider());
// $app->register(new Silex\Provider\HttpCacheServiceProvider(), [
// 'http_cache.cache_dir' => $app['cache.path'] . '/http',
// ]);
// $app->register(new Silex\Provider\HttpFragmentServiceProvider());
$app->register(new Provider\ValidatorServiceProvider());
$app->register(new Provider\LocaleServiceProvider());
$app->register(new Provider\TranslationServiceProvider());
$app->register(new Provider\CsrfServiceProvider());
$app->register(new Provider\FormServiceProvider());
$app->register(new Provider\ServiceControllerServiceProvider());
$app->register(new Provider\SessionServiceProvider());
$app->register(new \Paginator\Provider\PaginatorServiceProvider());
// $app->register(new \Sorien\Provider\PimpleDumpProvider(), ['dump.path' => $app['root.path']]);
}
protected function _before()
{
$credentials = new DbCredentials();
$container = ContainerService::getInstance()->setDbCredentials($credentials)->addEntityPath('src/Entity')->getContainer();
$em = $container['doctrine.entity_manager'];
$helperSet = ConsoleRunner::createHelperSet($em);
$helperSet->set(new DialogHelper(), 'dialog');
$configuration = new Configuration($em->getConnection());
$configuration->setMigrationsNamespace('Migrations');
$configuration->setMigrationsTableName('Migration');
$this->app = new Application();
$mig = new Migration();
$mig->setMigrationConfiguration($configuration);
$this->app->add($mig);
$this->app->add(new VersionCommand());
}
/**
* @Route("/{connectionName}/execute/{version}")
* @Method("POST")
*/
public function executeAction($connectionName, $version)
{
$connection = $this->getDoctrine()->getConnection($connectionName);
$outputWriter = new MemoryOutputWriter();
$configuration = new Configuration($connection);
$configuration->setName($this->container->getParameter('doctrine_migrations.name'));
$configuration->setOutputWriter($outputWriter);
$configuration->setMigrationsTableName($this->container->getParameter('doctrine_migrations.table_name'));
$configuration->setMigrationsDirectory($this->container->getParameter('doctrine_migrations.dir_name'));
$configuration->setMigrationsNamespace($this->container->getParameter('doctrine_migrations.namespace'));
$migration = new Migration($configuration);
$currentVersion = $configuration->getCurrentVersion();
$dryRun = false;
$migration->setNoMigrationException(true);
$sql = $migration->migrate($version, $dryRun, true);
return $this->render('MarkeiDoctrineMigrationWebBundle:Migrate:execute.html.twig', ['connectionName' => $connectionName, 'to' => $version, 'from' => $currentVersion, 'output' => $outputWriter->getMemory(), 'name' => $this->container->getParameter('doctrine_migrations.name')]);
}
/**
* creates and returns the configuration for doctrine migrations
* @return Doctrine\DBAL\Migrations\Configuration\Configuration
*/
private function getMigrationsConfiguration()
{
//get instances
$scriptBaseDir = realpath(dirname(__FILE__));
$ormController = OrmController::create();
$connection = $ormController->getEntityManager()->getConnection();
//fix to handle enum types for migrating old yourCMDB versions
$connection->getDatabasePlatform()->registerDoctrineTypeMapping('enum', 'string');
//migration configuration
$migrationConfig = new Configuration($connection);
$migrationConfig->setName("yourCMDB datastore migrations");
$migrationConfig->setMigrationsTableName(self::MIGRATIONS_TABLE_NAME);
$migrationConfig->setMigrationsDirectory("{$scriptBaseDir}/DatastoreMigrations");
$migrationConfig->setMigrationsNamespace(self::MIGRATIONS_NAMESPACE);
$migrationConfig->registerMigrationsFromDirectory("{$scriptBaseDir}/DatastoreMigrations");
//return migrations configuration
return $migrationConfig;
}
/**
* {@inheritDoc}
*
* @return \Doctrine\DBAL\Migrations\Configuration\Configuration
*/
public function __invoke(ContainerInterface $container, $requestedName, array $options = null)
{
$name = $this->getName();
/* @var $connection \Doctrine\DBAL\Connection */
$connection = $container->get('doctrine.connection.' . $name);
$appConfig = $container->get('Config');
$migrationsConfig = $appConfig['doctrine']['migrations_configuration'][$name];
$configuration = new Configuration($connection);
$configuration->setName($migrationsConfig['name']);
$configuration->setMigrationsDirectory($migrationsConfig['directory']);
$configuration->setMigrationsNamespace($migrationsConfig['namespace']);
$configuration->setMigrationsTableName($migrationsConfig['table']);
$configuration->registerMigrationsFromDirectory($migrationsConfig['directory']);
if (method_exists($configuration, 'setMigrationsColumnName')) {
$configuration->setMigrationsColumnName($migrationsConfig['column']);
}
return $configuration;
}
/**
* Constructor
*
* @param Application $console Console
* @param ContainerInterface $container Container DI
*/
public function __construct(Application $console, ContainerInterface $container)
{
$config = $container->get('Config');
$entityManager = $container->get('EntityManager');
$migrationConfiguration = new Configuration($entityManager->getConnection());
$migrationConfiguration->setMigrationsTableName($config->{'doctrine.orm'}->migrations->table);
$migrationConfiguration->setMigrationsNamespace($config->{'doctrine.orm'}->migrations->namespace);
$migrationConfiguration->setMigrationsDirectory($config->{'doctrine.orm'}->migrations->directory);
$migrationConfiguration->registerMigrationsFromDirectory($config->{'doctrine.orm'}->migrations->directory);
$migrationCommands = ['DiffCommand', 'ExecuteCommand', 'GenerateCommand', 'MigrateCommand', 'StatusCommand', 'VersionCommand'];
foreach ($migrationCommands as $commandName) {
/** @var \Doctrine\DBAL\Migrations\Tools\Console\Command\AbstractCommand $command */
$fullCommandName = 'Doctrine\\DBAL\\Migrations\\Tools\\Console\\Command\\' . $commandName;
$command = new $fullCommandName();
$command->setMigrationConfiguration($migrationConfiguration);
$console->add($command);
}
}
public function register(Application $app)
{
if (!isset($app['migration.outputwriter'])) {
$app['migration.outputwriter'] = null;
}
$app['migration'] = $app->share(function () use($app) {
return new Migration($app['migration.configuration']);
});
$app['migration.configuration'] = $app->share(function () use($app) {
$configuration = new Configuration($app['db'], $app['migration.outputwriter']);
if (isset($app['migration.table'])) {
$configuration->setMigrationsTableName($app['migration.table']);
}
$configuration->setMigrationsNamespace($app['migration.namespace']);
$configuration->setMigrationsDirectory($app['migration.directory']);
$configuration->registerMigrationsFromDirectory($configuration->getMigrationsDirectory());
return $configuration;
});
}
public static function createMigrationsCommands(ContainerInterface $container) : array
{
$config = self::getConfig($container, 'migrations', []);
$doctrineConfig = new Configuration($container->get(Connection::class));
$doctrineConfig->setMigrationsNamespace($config['namespace']);
if (isset($config['path'])) {
$doctrineConfig->setMigrationsDirectory($config['path']);
$doctrineConfig->registerMigrationsFromDirectory($config['path']);
}
if (isset($config['name'])) {
$doctrineConfig->setName($config['name']);
}
if (isset($config['table_name'])) {
$doctrineConfig->setMigrationsTableName($config['table_name']);
}
$commands = [new DiffCommand(), new ExecuteCommand(), new GenerateCommand(), new MigrateCommand(), new StatusCommand(), new VersionCommand()];
foreach ($commands as $key => $command) {
$command->setMigrationConfiguration($doctrineConfig);
$commands[$key] = $command;
}
return $commands;
}
public function migrate()
{
$container = $this->container;
$conn = $this->entityManager->getConnection();
$SSoneCMSbundle = new SSoneCMSBundle();
$dir = $SSoneCMSbundle->getPath() . "/Migrations";
$configuration = new Configuration($conn);
$configuration->setMigrationsNamespace('SSone\\CMSBundle\\Migrations');
$configuration->setMigrationsDirectory($dir);
$configuration->registerMigrationsFromDirectory($dir);
$configuration->setName('One CMS Migrations');
$configuration->setMigrationsTableName('cms_migrations');
$versions = $configuration->getMigrations();
foreach ($versions as $version) {
$migration = $version->getMigration();
if ($migration instanceof ContainerAwareInterface) {
$migration->setContainer($container);
}
}
$migration = new Migration($configuration);
$migrated = $migration->migrate();
}
public static function configureMigrations(ContainerInterface $container, Configuration $configuration)
{
if (!$configuration->getMigrationsDirectory()) {
$dir = $container->getParameter('doctrine_migrations.dir_name');
if (!file_exists($dir)) {
mkdir($dir, 0777, true);
}
$configuration->setMigrationsDirectory($dir);
} else {
$dir = $configuration->getMigrationsDirectory();
// class Kernel has method getKernelParameters with some of the important path parameters
$pathPlaceholderArray = array('kernel.root_dir', 'kernel.cache_dir', 'kernel.logs_dir');
foreach ($pathPlaceholderArray as $pathPlaceholder) {
if ($container->hasParameter($pathPlaceholder) && preg_match('/\\%' . $pathPlaceholder . '\\%/', $dir)) {
$dir = str_replace('%' . $pathPlaceholder . '%', $container->getParameter($pathPlaceholder), $dir);
}
}
if (!file_exists($dir)) {
mkdir($dir, 0777, true);
}
$configuration->setMigrationsDirectory($dir);
}
if (!$configuration->getMigrationsNamespace()) {
$configuration->setMigrationsNamespace($container->getParameter('doctrine_migrations.namespace'));
}
if (!$configuration->getName()) {
$configuration->setName($container->getParameter('doctrine_migrations.name'));
}
// For backward compatibility, need use a table from parameters for overwrite the default configuration
if (!$configuration->getMigrationsTableName() || !$configuration instanceof AbstractFileConfiguration) {
$configuration->setMigrationsTableName($container->getParameter('doctrine_migrations.table_name'));
}
// Migrations is not register from configuration loader
if (!$configuration instanceof AbstractFileConfiguration) {
$configuration->registerMigrationsFromDirectory($configuration->getMigrationsDirectory());
}
self::injectContainerToMigrations($container, $configuration->getMigrations());
}
