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 __construct(BaseDriver $driver, PDO $connection)
{
$c = ServiceContainer::getInstance();
$this->driver = $driver;
$this->connection = $connection;
$this->logger = $c['logger'] ?: Console::getInstance()->getLogger();
$this->builder = SqlBuilder::create($driver);
}
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();
$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 __construct()
{
$this['config_loader'] = function ($c) {
$config = ConfigLoader::getInstance();
$config->loadFromSymbol(true);
// force loading
if ($config->isLoaded()) {
$config->initForBuild();
}
return $config;
};
$this['logger'] = function ($c) {
return Console::getInstance()->getLogger();
};
$this['schema_finder'] = function ($c) {
$finder = new SchemaFinder();
$finder->paths = $c['config_loader']->getSchemaPaths() ?: [];
return $finder;
};
}
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');
}
