public function testVersionString()
{
$mock = $this->getMockBuilder(\stdClass::class)->setMethods(['fetchColumn'])->disableOriginalConstructor()->getMock();
$mock->expects($this->once())->method('fetchColumn')->will($this->returnValue("3.0.2"));
$this->adapter->expects($this->once())->method('query')->with("show variables like 'version'")->will($this->returnValue($mock));
$this->assertEquals("3.0.2", $this->helper->versionString());
}
public function test()
{
$this->adapter->expects($this->atLeastOnce())->method('hasTable')->will($this->returnValueMap([['users', true], ['users_new', true]]));
$this->adapter->expects($this->atLeastOnce())->method('quoteTableName')->will($this->returnCallback(function ($name) {
return "`{$name}`";
}));
$this->adapter->expects($this->once())->method('query')->with('RENAME TABLE `users` TO `users_archive`, `users_new` TO `users`');
$this->origin->expects($this->atLeastOnce())->method('getName')->will($this->returnValue('users'));
$this->destination->expects($this->atLeastOnce())->method('getName')->will($this->returnValue('users_new'));
$this->switcher->run();
}
public function testRun()
{
/** @var Column[] $originColumns */
$originColumns = [new Column(), new Column(), new Column()];
$originColumns[0]->setName('id');
$originColumns[1]->setName('name');
$originColumns[2]->setName('something');
/** @var Column[] $destinationColumns */
$destinationColumns = [new Column(), new Column(), new Column()];
$destinationColumns[0]->setName('id');
$destinationColumns[1]->setName('name');
$destinationColumns[2]->setName('something_else');
$this->origin->expects($this->atLeastOnce())->method('getName')->will($this->returnValue('users'));
$this->origin->expects($this->atLeastOnce())->method('getColumns')->will($this->returnValue($originColumns));
$this->destination->expects($this->atLeastOnce())->method('getName')->will($this->returnValue('users_new'));
$this->destination->expects($this->atLeastOnce())->method('getColumns')->will($this->returnValue($destinationColumns));
$this->destination->expects($this->atLeastOnce())->method('getRenamedColumns')->will($this->returnValue([]));
$matcher = $this->atLeastOnce();
$this->adapter->expects($matcher)->method('fetchRow')->will($this->returnCallback(function ($query) use($matcher) {
switch ($matcher->getInvocationCount()) {
case 1:
$this->assertEquals("SELECT MIN(id) FROM 'users'", $query);
return [1];
case 2:
$this->assertEquals("SELECT MAX(id) FROM 'users'", $query);
return [500];
default:
return null;
break;
}
}));
$matcher = $this->atLeastOnce();
$this->adapter->expects($matcher)->method('query')->will($this->returnCallback(function ($query) use($matcher) {
switch ($matcher->getInvocationCount()) {
case 1:
$this->assertEquals("SELECT `COLUMN_NAME` FROM `information_schema`.`COLUMNS` WHERE (`TABLE_SCHEMA` = '') AND (`TABLE_NAME` = 'users') AND (`COLUMN_KEY` = 'PRI');", $query);
return 'id';
case 2:
$this->assertEquals("INSERT IGNORE INTO 'users_new' (`id`,`name`) SELECT 'users'.`id`,'users'.`name` FROM 'users' WHERE 'users'.`id` BETWEEN 1 AND 200", $query);
break;
case 3:
$this->assertEquals("INSERT IGNORE INTO 'users_new' (`id`,`name`) SELECT 'users'.`id`,'users'.`name` FROM 'users' WHERE 'users'.`id` BETWEEN 201 AND 400", $query);
break;
case 4:
$this->assertEquals("INSERT IGNORE INTO 'users_new' (`id`,`name`) SELECT 'users'.`id`,'users'.`name` FROM 'users' WHERE 'users'.`id` BETWEEN 401 AND 500", $query);
break;
default:
$this->fail('Unexpected query: ' . $query);
break;
}
}));
$chunker = new Chunker($this->adapter, $this->origin, $this->destination, $this->sqlHelper, ['stride' => 200]);
$chunker->run();
}
public function test()
{
$this->adapter->expects($this->atLeastOnce())->method('hasTable')->will($this->returnValueMap([['users', true], ['users_new', true]]));
$this->adapter->expects($this->atLeastOnce())->method('quoteTableName')->will($this->returnCallback(function ($name) {
return "`{$name}`";
}));
$expected = ["set @lhm_auto_commit = @@session.autocommit /* large hadron migration (php) */", "set session autocommit = 0 /* large hadron migration (php) */", "LOCK TABLE `users` write, `users_new` write /* large hadron migration (php) */", "ALTER TABLE `users` rename `users_archive` /* large hadron migration (php) */", "ALTER TABLE `users_new` rename `users` /* large hadron migration (php) */", "COMMIT /* large hadron migration (php) */", "UNLOCK TABLES /* large hadron migration (php) */", "set session autocommit = @lhm_auto_commit /* large hadron migration (php) */"];
$matcher = $this->any();
$this->adapter->expects($matcher)->method('query')->will($this->returnCallback(function ($query) use($matcher, $expected) {
$this->assertEquals($expected[$matcher->getInvocationCount() - 1], $query);
}));
$this->origin->expects($this->atLeastOnce())->method('getName')->will($this->returnValue('users'));
$this->destination->expects($this->atLeastOnce())->method('getName')->will($this->returnValue('users_new'));
$this->switcher->run();
}
public function testCreateDeleteTrigger()
{
$this->origin->expects($this->atLeastOnce())->method('getName')->will($this->returnValue('users'));
$this->destination->expects($this->atLeastOnce())->method('getName')->will($this->returnValue('users_new'));
$this->adapter->expects($this->once())->method('query')->will($this->returnValue("id"));
$this->assertEquals(implode("\n ", ['CREATE TRIGGER lhmt_delete_users', "AFTER DELETE ON 'users' FOR EACH ROW", "DELETE IGNORE FROM 'users_new' /* large hadron migration (php) */", "WHERE 'users_new'.`id` = OLD.`id`"]), $this->entangler->createDeleteTrigger());
}
public function testInsertData()
{
$row = array('column1' => 'value3');
$this->mock->expects($this->once())->method('insert')->with($this->callback(function ($table) {
return $table->getName() == 'pre_table_suf';
}, $this->equalTo($row)));
$table = new Table('table', array(), $this->adapter);
$table->insert($row)->save();
}
public function testAddTableWithForeignKey()
{
$this->mock->expects($this->any())->method('isValidColumnType')->with($this->callback(function ($column) {
return in_array($column->getType(), array('string', 'integer'));
}))->will($this->returnValue(true));
$table = new Table('table', array(), $this->adapter);
$table->addColumn('bar', 'string')->addColumn('relation', 'integer')->addForeignKey('relation', 'target_table', array('id'));
$this->mock->expects($this->once())->method('createTable')->with($this->callback(function ($table) {
if ($table->getName() !== 'pre_table_suf') {
throw new \Exception(sprintf('Table::getName was not prefixed/suffixed properly: "%s"', $table->getName()));
}
$fks = $table->getForeignKeys();
if (count($fks) !== 1) {
throw new \Exception(sprintf('Table::getForeignKeys count was incorrect: %d', count($fks)));
}
foreach ($fks as $fk) {
if ($fk->getReferencedTable()->getName() !== 'pre_target_table_suf') {
throw new \Exception(sprintf('ForeignKey::getReferencedTable was not prefixed/suffixed properly: "%s"', $fk->getReferencedTable->getName()));
}
}
return true;
}));
$table->create();
}