PHP Phoenix\Migration\Init Init Examples

Example #1

File: CleanupCommand.php Project: lulco/phoenix

 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('');
 }

Example #2

File: InitCommand.php Project: lulco/phoenix

 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);
 }

Example #3

File: run.php Project: lulco/phoenix

<?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";
}