/** * @param InputInterface $input * @param OutputInterface $output */ protected final function execute(InputInterface $input, OutputInterface $output) { $this->loadConfig($input); $environment = $input->getOption('environment') ?: $this->config->getDefaultEnvironment(); $this->adapter = AdapterFactory::instance($this->config->getEnvironmentConfig($environment)); $this->manager = new Manager($this->config, $this->adapter); $this->check($input, $output); $start = microtime(true); $this->runCommand($input, $output); $output->writeln(''); $output->write('<comment>All done. Took ' . sprintf('%.4fs', microtime(true) - $start) . '</comment>'); $output->writeln(''); }
<?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"; }
public function testUnknown() { $config = new EnvironmentConfig(['adapter' => 'unknown', 'dsn' => 'sqlite::memory:']); $this->setExpectedException('\\Phoenix\\Exception\\InvalidArgumentValueException', 'Unknown adapter "unknown". Use one of value: "mysql", "pgsql", "sqlite".'); AdapterFactory::instance($config); }