public function testMigrationByDiff() { $this->conn->query('DROP TABLE IF EXISTS users'); $this->conn->query('DROP TABLE IF EXISTS test'); $this->conn->query('CREATE TABLE users (account VARCHAR(128) UNIQUE)'); if (!file_exists('tests/migrations_testing')) { mkdir('tests/migrations_testing'); } $generator = new MigrationGenerator(Console::getInstance()->getLogger(), 'tests/migrations_testing'); ok(class_exists('TestApp\\Model\\UserSchema', true)); $finder = new SchemaFinder(); $finder->find(); list($class, $path) = $generator->generateWithDiff('DiffMigration', $this->getDriverType(), ["users" => new TestApp\Model\UserSchema()], '20120101'); require_once $path; ok($class::getId()); /* $userSchema = new TestApp\Model\UserSchema; $column = $userSchema->getColumn('account'); */ // run migration $runner = new MigrationRunner($this->logger, $this->getDriverType()); $runner->resetMigrationId($this->conn, $this->queryDriver); $runner->load('tests/migrations_testing'); // XXX: PHPUnit can't run this test in separated unit test since // there is a bug of serializing the global array, this assertion will get 5 instead of the expected 1. $scripts = $runner->loadMigrationScripts(); $this->assertNotEmpty($scripts); // $this->assertCount(1, $scripts); // $this->expectOutputRegex('#DiffMigration_1325347200#'); $runner->runUpgrade($this->conn, $this->queryDriver, [$class]); # echo file_get_contents($path); unlink($path); $this->conn->query('DROP TABLE IF EXISTS users'); }
public function execute($taskName) { $dsId = $this->getCurrentDataSourceId(); $generator = new MigrationGenerator(Console::getInstance()->getLogger(), 'db/migrations'); $this->logger->info("Creating migration script for '" . $taskName . "'"); list($class, $path) = $generator->generate($taskName); $this->logger->info("Migration script is generated: {$path}"); }
public function execute($taskName) { $dsId = $this->getCurrentDataSourceId(); $config = $this->getConfigLoader(true); $this->logger->info('Loading schema objects...'); $finder = new SchemaFinder(); $finder->setPaths($config->getSchemaPaths() ?: array()); $finder->find(); $generator = new MigrationGenerator($this->logger, 'db/migrations'); $this->logger->info('Creating migration script from diff'); $schemaMap = SchemaLoader::loadSchemaTableMap(); list($class, $path) = $generator->generateWithDiff($taskName, $dsId, $schemaMap); $this->logger->info("Migration script is generated: {$path}"); }
public function execute($taskName) { $dsId = $this->getCurrentDataSourceId(); $this->logger->info("Loading schema objects..."); $finder = new SchemaFinder(); $finder->paths = $this->config->getSchemaPaths() ?: array(); $finder->find(); $schemas = $finder->getSchemas(); $this->logger->info('Found ' . count($schemas) == 0 . ' schemas'); $generator = new MigrationGenerator(Console::getInstance()->getLogger(), 'db/migrations'); $this->logger->info("Creating migration script from diff"); list($class, $path) = $generator->generateWithDiff($taskName, $dsId, $schemas); $this->logger->info("Migration script is generated: {$path}"); }
public function testMigrationByDiff() { $connectionManager = ConnectionManager::getInstance(); $connectionManager->addDataSource('default', array('driver' => 'mysql', 'dsn' => @$_ENV['DB_MYSQL_DSN'], 'user' => @$_ENV['DB_MYSQL_USER'], 'pass' => @$_ENV['DB_MYSQL_PASS'])); $pdo = $connectionManager->getConnection('default'); $pdo->query('DROP TABLE IF EXISTS users'); $pdo->query('DROP TABLE IF EXISTS test'); $pdo->query('CREATE TABLE users (account VARCHAR(128) UNIQUE)'); if (!file_exists('tests/migrations_testing')) { mkdir('tests/migrations_testing'); } $generator = new MigrationGenerator(Console::getInstance()->getLogger(), 'tests/migrations_testing'); ok(class_exists('TestApp\\Model\\UserSchema', true)); $finder = new SchemaFinder(); $finder->find(); list($class, $path) = $generator->generateWithDiff('DiffMigration', 'default', [new TestApp\Model\UserSchema()], '20120101'); require_once $path; ok($class::getId()); /* $userSchema = new TestApp\Model\UserSchema; $column = $userSchema->getColumn('account'); */ /* */ // run migration $runner = new MigrationRunner('default'); $runner->resetMigrationId('default'); $runner->load('tests/migrations_testing'); // XXX: PHPUnit can't run this test in separated unit test since // there is a bug of serializing the global array, this assertion will get 5 instead of the expected 1. $scripts = $runner->getMigrationScripts(); $this->assertNotEmpty($scripts); // $this->assertCount(1, $scripts); // $this->expectOutputRegex('#DiffMigration_1325347200#'); $runner->runUpgrade([$class]); # echo file_get_contents($path); unlink($path); $pdo->query('DROP TABLE IF EXISTS users'); $connectionManager->removeDataSource('default'); $connectionManager->close('default'); }