1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
<?php
namespace Doctrine\Tests\DBAL\Schema\Visitor;
use Doctrine\DBAL\Schema\Visitor\DropSchemaSqlCollector;
/**
* @covers Doctrine\DBAL\Schema\Visitor\DropSchemaSqlCollector
*/
class DropSchemaSqlCollectorTest extends \PHPUnit\Framework\TestCase
{
public function testGetQueriesUsesAcceptedForeignKeys()
{
$tableOne = $this->getTableMock();
$tableTwo = $this->getTableMock();
$keyConstraintOne = $this->getStubKeyConstraint('first');
$keyConstraintTwo = $this->getStubKeyConstraint('second');
$platform = $this->getMockBuilder('Doctrine\DBAL\Platforms\AbstractPlatform')
->setMethods(array('getDropForeignKeySQL'))
->getMockForAbstractClass();
$collector = new DropSchemaSqlCollector($platform);
$platform->expects($this->exactly(2))
->method('getDropForeignKeySQL');
$platform->expects($this->at(0))
->method('getDropForeignKeySQL')
->with($keyConstraintOne, $tableOne);
$platform->expects($this->at(1))
->method('getDropForeignKeySQL')
->with($keyConstraintTwo, $tableTwo);
$collector->acceptForeignKey($tableOne, $keyConstraintOne);
$collector->acceptForeignKey($tableTwo, $keyConstraintTwo);
$collector->getQueries();
}
private function getTableMock()
{
return $this->getMockWithoutArguments('Doctrine\DBAL\Schema\Table');
}
private function getMockWithoutArguments($className)
{
return $this->getMockBuilder($className)->disableOriginalConstructor()->getMock();
}
private function getStubKeyConstraint($name)
{
$constraint = $this->getMockWithoutArguments('Doctrine\DBAL\Schema\ForeignKeyConstraint');
$constraint->expects($this->any())
->method('getName')
->will($this->returnValue($name));
$constraint->expects($this->any())
->method('getForeignColumns')
->will($this->returnValue(array()));
$constraint->expects($this->any())
->method('getColumns')
->will($this->returnValue(array()));
return $constraint;
}
public function testGivenForeignKeyWithZeroLength_acceptForeignKeyThrowsException()
{
$collector = new DropSchemaSqlCollector(
$this->getMockForAbstractClass('Doctrine\DBAL\Platforms\AbstractPlatform')
);
$this->expectException( 'Doctrine\DBAL\Schema\SchemaException' );
$collector->acceptForeignKey($this->getTableMock(), $this->getStubKeyConstraint(''));
}
}