|
<?php
|
|
|
|
namespace Doctrine\Tests\DBAL\Schema;
|
|
|
|
require_once __DIR__ . '/../../TestInit.php';
|
|
|
|
use Doctrine\DBAL\Schema\Schema,
|
|
Doctrine\DBAL\Schema\Table,
|
|
Doctrine\DBAL\Schema\Column,
|
|
Doctrine\DBAL\Schema\Index,
|
|
Doctrine\DBAL\Schema\Sequence,
|
|
Doctrine\DBAL\Schema\SchemaDiff,
|
|
Doctrine\DBAL\Schema\TableDiff,
|
|
Doctrine\DBAL\Schema\Comparator,
|
|
Doctrine\DBAL\Types\Type;
|
|
|
|
class SchemaDiffTest extends \PHPUnit_Framework_TestCase
|
|
{
|
|
public function testSchemaDiffToSql()
|
|
{
|
|
$diff = $this->createSchemaDiff();
|
|
$platform = $this->createPlatform();
|
|
|
|
$sql = $diff->toSql($platform);
|
|
|
|
$expected = array('drop_orphan_fk', 'drop_seq', 'create_seq', 'drop_seq', 'create_seq', 'create_table', 'create_foreign_key', 'drop_table', 'alter_table');
|
|
|
|
$this->assertEquals($expected, $sql);
|
|
}
|
|
|
|
public function testSchemaDiffToSaveSql()
|
|
{
|
|
$diff = $this->createSchemaDiff();
|
|
$platform = $this->createPlatform(1, 0, 0);
|
|
|
|
$sql = $diff->toSaveSql($platform);
|
|
|
|
$expected = array('drop_seq', 'create_seq', 'create_seq', 'create_table', 'create_foreign_key', 'alter_table');
|
|
|
|
$this->assertEquals($expected, $sql);
|
|
}
|
|
|
|
public function createPlatform($dropSequenceCount=2, $dropTableCount=1, $dropOrphanedFkCount=1)
|
|
{
|
|
$platform = $this->getMock('Doctrine\Tests\DBAL\Mocks\MockPlatform');
|
|
$platform->expects($this->exactly($dropSequenceCount))
|
|
->method('getDropSequenceSql')
|
|
->with($this->isInstanceOf('Doctrine\DBAL\Schema\Sequence'))
|
|
->will($this->returnValue('drop_seq'));
|
|
$platform->expects($this->exactly(2))
|
|
->method('getCreateSequenceSql')
|
|
->with($this->isInstanceOf('Doctrine\DBAL\Schema\Sequence'))
|
|
->will($this->returnValue('create_seq'));
|
|
if ($dropTableCount > 0) {
|
|
$platform->expects($this->exactly($dropTableCount))
|
|
->method('getDropTableSql')
|
|
->with($this->isInstanceof('Doctrine\DBAL\Schema\Table'))
|
|
->will($this->returnValue('drop_table'));
|
|
}
|
|
$platform->expects($this->exactly(1))
|
|
->method('getCreateTableSql')
|
|
->with($this->isInstanceof('Doctrine\DBAL\Schema\Table'))
|
|
->will($this->returnValue(array('create_table')));
|
|
$platform->expects($this->exactly(1))
|
|
->method('getCreateForeignKeySQL')
|
|
->with($this->isInstanceOf('Doctrine\DBAL\Schema\ForeignKeyConstraint'))
|
|
->will($this->returnValue('create_foreign_key'));
|
|
$platform->expects($this->exactly(1))
|
|
->method('getAlterTableSql')
|
|
->with($this->isInstanceOf('Doctrine\DBAL\Schema\TableDiff'))
|
|
->will($this->returnValue(array('alter_table')));
|
|
if ($dropOrphanedFkCount > 0) {
|
|
$platform->expects($this->exactly($dropOrphanedFkCount))
|
|
->method('getDropForeignKeySql')
|
|
->with($this->isInstanceof('Doctrine\DBAL\Schema\ForeignKeyConstraint'), $this->equalTo('local_table'))
|
|
->will($this->returnValue('drop_orphan_fk'));
|
|
}
|
|
$platform->expects($this->exactly(1))
|
|
->method('supportsSequences')
|
|
->will($this->returnValue(true));
|
|
$platform->expects($this->exactly(2))
|
|
->method('supportsForeignKeyConstraints')
|
|
->will($this->returnValue(true));
|
|
return $platform;
|
|
}
|
|
|
|
public function createSchemaDiff()
|
|
{
|
|
$diff = new SchemaDiff();
|
|
$diff->changedSequences['foo_seq'] = new Sequence('foo_seq');
|
|
$diff->newSequences['bar_seq'] = new Sequence('bar_seq');
|
|
$diff->removedSequences['baz_seq'] = new Sequence('baz_seq');
|
|
$diff->newTables['foo_table'] = new Table('foo_table');
|
|
$diff->removedTables['bar_table'] = new Table('bar_table');
|
|
$diff->changedTables['baz_table'] = new TableDiff('baz_table');
|
|
$diff->newTables['foo_table']->addColumn('foreign_id', 'integer');
|
|
$diff->newTables['foo_table']->addForeignKeyConstraint('foreign_table', array('foreign_id'), array('id'));
|
|
$fk = new \Doctrine\DBAL\Schema\ForeignKeyConstraint(array('id'), 'foreign_table', array('id'));
|
|
$fk->setLocalTable(new Table('local_table'));
|
|
$diff->orphanedForeignKeys[] = $fk;
|
|
return $diff;
|
|
}
|
|
}
|