| public generateWithDiff ( $taskName, $dataSourceId, array $schemas, $time = null ) | ||
| $schemas | array | |
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();
$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');
}
