Doctrine\Tests\DBAL\Schema\PostgreSQLSchemaManagerTest

Complexity

Total Complexity

3

Size/Duplication

Total Lines	79
Duplicated Lines	0 %

Coupling/Cohesion

Components	1
Dependencies	5

Importance

Changes	1
Bugs	0	Features	0

3 Methods

Rating	Name	Duplication	Size	Complexity
A	setupConnectionAndManager()	0	11	1
B	testFiltersSequences()	0	42	1
A	filtersSequencesDataProvider()	0	7	1

<?php

namespace Doctrine\Tests\DBAL\Schema;

use Doctrine\DBAL\Configuration;
use Doctrine\DBAL\Schema\PostgreSqlSchemaManager;
use Doctrine\DBAL\Schema\Sequence;

class PostgreSQLSchemaManagerTest extends \PHPUnit\Framework\TestCase
{
    /**
     * @var \Doctrine\DBAL\Schema\PostgreSQLSchemaManager
     */
    private $schemaManager;

    /**
     * @var \Doctrine\DBAL\Connection|\PHPUnit_Framework_MockObject_MockObject
     */
    private $connection;

    private function setupConnectionAndManager($platformClass)
    {
        $driverMock = $this->createMock('Doctrine\DBAL\Driver');
        $platform = $this->createMock($platformClass);

        $this->connection = $this->getMockBuilder('Doctrine\DBAL\Connection')
            ->setConstructorArgs([['platform' => $platform], $driverMock])
            ->getMock();

        $this->schemaManager = new PostgreSqlSchemaManager($this->connection, $platform);
    }

    /**
     * @group DBAL-474
     * @dataProvider filtersSequencesDataProvider
     */
    public function testFiltersSequences(string $platformClass)
    {
        $this->setupConnectionAndManager($platformClass);

        $configuration = new Configuration();
        $configuration->setFilterSchemaAssetsExpression('/^schema/');

        $sequences = [
            ['relname' => 'foo', 'schemaname' => 'schema'],
            ['relname' => 'bar', 'schemaname' => 'schema'],
            ['relname' => 'baz', 'schemaname' => ''],
            ['relname' => 'bloo', 'schemaname' => 'bloo_schema'],
        ];


        $this->connection->expects($this->any())

The method expects does only exist in PHPUnit_Framework_MockObject_MockObject, but not in Doctrine\DBAL\Connection.

            ->method('getConfiguration')
            ->will($this->returnValue($configuration));

        $this->connection->expects($this->at(0))
            ->method('fetchAll')
            ->will($this->returnValue($sequences));

        $this->connection->expects($this->at(2))
            ->method('fetchAll')
            ->will($this->returnValue([['min_value' => 1, 'increment_by' => 1]]));

        $this->connection->expects($this->at(3))
            ->method('fetchAll')
            ->will($this->returnValue([['min_value' => 2, 'increment_by' => 2]]));

        $this->connection->expects($this->exactly(3))
            ->method('fetchAll');

        self::assertEquals(
            [
                new Sequence('schema.foo', 1, 1),
                new Sequence('schema.bar', 2, 2),
            ],
            $this->schemaManager->listSequences('database')
        );
    }

    public function filtersSequencesDataProvider()
    {
        return [
            ['Doctrine\DBAL\Platforms\PostgreSqlPlatform'],
            ['Doctrine\DBAL\Platforms\PostgreSQL100Platform']
        ];
    }
}