RDV\Bundle\MigrationBundle\Tests\Unit\Migration\SqlMigrationQueryTest

Complexity

Total Complexity

6

Size/Duplication

Total Lines	117
Duplicated Lines	7.69 %

Coupling/Cohesion

Components	1
Dependencies	7

6 Methods

Rating	Name	Duplication	Size	Complexity
A	setUp()	9	9	1
A	testConstructorWithString()	0	12	1
A	testConstructorWithArray()	0	18	1
A	testGetDescriptionWithoutSql()	0	7	1
A	testGetDescription()	0	23	1
B	testExecute()	0	37	1

<?php

namespace RDV\Bundle\MigrationBundle\Tests\Unit\Migration;

use Doctrine\DBAL\Platforms\MySqlPlatform;
use RDV\Bundle\MigrationBundle\Migration\ArrayLogger;
use RDV\Bundle\MigrationBundle\Migration\SqlMigrationQuery;

class SqlMigrationQueryTest extends \PHPUnit_Framework_TestCase
{
    /** @var \PHPUnit_Framework_MockObject_MockObject */
    protected $connection;

    protected function setUp()

This method seems to be duplicated in your project.

    {
        $this->connection = $this->getMockBuilder('Doctrine\DBAL\Connection')
            ->disableOriginalConstructor()
            ->getMock();
        $this->connection->expects($this->any())
            ->method('getDatabasePlatform')
            ->will($this->returnValue(new MySqlPlatform()));
    }

    public function testConstructorWithString()
    {
        $query = new SqlMigrationQuery(
            'INSERT INTO test_table (name) VALUES (:name)'
        );
        $query->setConnection($this->connection);

        $this->assertEquals(
            'INSERT INTO test_table (name) VALUES (:name)',
            $query->getDescription()
        );
    }

    public function testConstructorWithArray()
    {
        $query = new SqlMigrationQuery(
            [
                'INSERT INTO test_table (name) VALUES (:name)',
                'INSERT INTO test_table (test) VALUES (1)'
            ]
        );
        $query->setConnection($this->connection);

        $this->assertEquals(
            [
                'INSERT INTO test_table (name) VALUES (:name)',
                'INSERT INTO test_table (test) VALUES (1)'
            ],
            $query->getDescription()
        );
    }

    public function testGetDescriptionWithoutSql()
    {
        $query = new SqlMigrationQuery();
        $query->setConnection($this->connection);

        $this->assertEquals('', $query->getDescription());
    }

    public function testGetDescription()
    {
        $query = new SqlMigrationQuery();
        $query->setConnection($this->connection);

        $this->connection->expects($this->never())
            ->method('executeUpdate');

        $query->addSql('INSERT INTO test_table (name) VALUES (\'name\')');
        $this->assertEquals(
            'INSERT INTO test_table (name) VALUES (\'name\')',
            $query->getDescription()
        );

        $query->addSql('INSERT INTO test_table (test) VALUES (1)');
        $this->assertEquals(
            [
                'INSERT INTO test_table (name) VALUES (\'name\')',
                'INSERT INTO test_table (test) VALUES (1)',
            ],
            $query->getDescription()
        );
    }

    public function testExecute()
    {
        $query = new SqlMigrationQuery();
        $query->setConnection($this->connection);

        $logger = new ArrayLogger();

        $this->connection->expects($this->at(0))
            ->method('executeUpdate')
            ->with('INSERT INTO test_table (name) VALUES (\'name\')');
        $this->connection->expects($this->at(1))
            ->method('executeUpdate')
            ->with('INSERT INTO test_table (name) VALUES (\'name\')');
        $this->connection->expects($this->at(2))
            ->method('executeUpdate')
            ->with('INSERT INTO test_table (test) VALUES (1)');

        $query->addSql('INSERT INTO test_table (name) VALUES (\'name\')');
        $query->execute($logger);
        $this->assertEquals(
            [
                'INSERT INTO test_table (name) VALUES (\'name\')'
            ],
            $logger->getMessages()
        );

        $query->addSql('INSERT INTO test_table (test) VALUES (1)');
        $query->execute($logger);
        $this->assertEquals(
            [
                'INSERT INTO test_table (name) VALUES (\'name\')',
                'INSERT INTO test_table (name) VALUES (\'name\')',
                'INSERT INTO test_table (test) VALUES (1)',
            ],
            $logger->getMessages()
        );
    }
}