protected function runCommand(InputInterface $input, OutputInterface $output)
{
$migrations = $this->manager->findMigrationsToExecute(Manager::TYPE_DOWN);
if (empty($migrations)) {
$output->writeln('');
$output->writeln('<info>Nothing to rollback</info>');
$output->writeln('');
}
foreach ($migrations as $migration) {
$migration->rollback();
$this->manager->removeExecution($migration);
$output->writeln('');
$output->writeln('<info>Rollback for migration ' . $migration->getClassName() . ' executed</info>');
$output->writeln('Executed queries:', OutputInterface::VERBOSITY_DEBUG);
$output->writeln($migration->getExecutedQueries(), OutputInterface::VERBOSITY_DEBUG);
}
$filename = __DIR__ . '/../Migration/Init/0_init.php';
require_once $filename;
$migration = new Init($this->adapter, $this->config->getLogTableName());
$migration->rollback();
$output->writeln('');
$output->writeln('<info>Phoenix cleaned</info>');
$output->writeln('Executed queries:', OutputInterface::VERBOSITY_DEBUG);
$output->writeln($migration->getExecutedQueries(), OutputInterface::VERBOSITY_DEBUG);
$output->writeln('');
}
protected function runCommand(InputInterface $input, OutputInterface $output)
{
$filename = __DIR__ . '/../Migration/Init/0_init.php';
require_once $filename;
$migration = new Init($this->adapter, $this->config->getLogTableName());
$migration->migrate();
$output->writeln('');
$output->writeln('<info>Phoenix initialized</info>');
$output->writeln('Executed queries:', OutputInterface::VERBOSITY_DEBUG);
$output->writeln($migration->getExecutedQueries(), OutputInterface::VERBOSITY_DEBUG);
}
<?php
use Phoenix\Config\Config;
use Phoenix\Database\Adapter\AdapterFactory;
use Phoenix\Migration\Init\Init;
use Phoenix\Migration\Manager;
require_once __DIR__ . '/../vendor/autoload.php';
$configuration = ['migration_dirs' => [__DIR__ . '/phoenix'], 'environments' => ['mysql' => ['adapter' => 'mysql', 'db_name' => 'libs', 'host' => 'localhost', 'username' => 'root', 'password' => '123', 'charset' => 'utf8'], 'sqlite_file' => ['adapter' => 'sqlite', 'dsn' => 'sqlite:' . __DIR__ . '/phoenix.sqlite'], 'sqlite' => ['adapter' => 'sqlite', 'dsn' => 'sqlite::memory:'], 'pgsql' => ['adapter' => 'pgsql', 'db_name' => 'libs', 'host' => 'localhost', 'username' => 'postgres', 'password' => '123', 'charset' => 'utf8']]];
foreach (array_keys($configuration['environments']) as $environment) {
echo "Adapter: {$environment}\n";
$config = new Config($configuration);
$adapter = AdapterFactory::instance($config->getEnvironmentConfig($environment));
$initMigration = new Init($adapter, $config->getLogTableName());
$initMigration->migrate();
$manager = new Manager($config, $adapter);
$migrations = $manager->findMigrationsToExecute();
foreach ($migrations as $migration) {
$migration->migrate();
$manager->logExecution($migration);
$migration->rollback();
$manager->removeExecution($migration);
$migration->migrate();
$manager->logExecution($migration);
// print_R($migration->getExecutedQueries());
}
echo "All OK\n\n";
}