Doctrine\Tests\DBAL\Schema\MySqlSchemaManagerTest

Complexity

Total Complexity

8

Size/Duplication

Total Lines	135
Duplicated Lines	0 %

Coupling/Cohesion

Components	1
Dependencies	10

Importance

Changes	2
Bugs	0	Features	0

5 Methods

Rating	Name	Duplication	Size	Complexity
A	setUp()	0	11	1
A	testCompositeForeignKeys()	0	10	1
B	testPortableTableColumnDefinition()	0	32	2
B	getColumnDefinition()	0	39	3
B	getFKDefinition()	0	29	1

<?php

namespace Doctrine\Tests\DBAL\Schema;

use Doctrine\Common\EventManager;
use Doctrine\DBAL\Configuration;
use Doctrine\DBAL\Platforms\MariaDb102Platform;
use Doctrine\DBAL\Schema\MySqlSchemaManager;

class MySqlSchemaManagerTest extends \PHPUnit_Framework_TestCase
{
    /**
     *
     * @var \Doctrine\DBAL\Schema\AbstractSchemaManager
     */
    private $manager;

    protected function setUp()
    {
        $eventManager = new EventManager();
        $driverMock = $this->createMock('Doctrine\DBAL\Driver');
        $platform = $this->createMock('Doctrine\DBAL\Platforms\MySqlPlatform');
        $this->conn = $this->getMockBuilder('Doctrine\DBAL\Connection')

The property conn does not exist. Did you maybe forget to declare it?

            ->setMethods(array('fetchAll'))
            ->setConstructorArgs(array(array('platform' => $platform), $driverMock, new Configuration(), $eventManager))
            ->getMock();
        $this->manager = new MySqlSchemaManager($this->conn);
    }

    public function testCompositeForeignKeys()
    {
        $this->conn->expects($this->once())->method('fetchAll')->will($this->returnValue($this->getFKDefinition()));
        $fkeys = $this->manager->listTableForeignKeys('dummy');
        $this->assertEquals(1, count($fkeys), "Table has to have one foreign key.");

        $this->assertInstanceOf('Doctrine\DBAL\Schema\ForeignKeyConstraint', $fkeys[0]);
        $this->assertEquals(array('column_1', 'column_2', 'column_3'), array_map('strtolower', $fkeys[0]->getLocalColumns()));
        $this->assertEquals(array('column_1', 'column_2', 'column_3'), array_map('strtolower', $fkeys[0]->getForeignColumns()));
    }

    public function testPortableTableColumnDefinition()
    {
        $eventManager = new EventManager();
        $driverMock = $this->createMock('Doctrine\DBAL\Driver');

        $platforms = [
            'mysql' => new \Doctrine\DBAL\Platforms\MySqlPlatform(),
            'mariadb10.2' => new \Doctrine\DBAL\Platforms\MariaDb102Platform()
        ];

        foreach ($platforms as $platformName => $platform) {


            $conn = $this->getMockBuilder('Doctrine\DBAL\Connection')
                ->setMethods(array('fetchAll'))
                ->setConstructorArgs(array(array('platform' => $platform), $driverMock, new Configuration(), $eventManager))
                ->getMock();
            $this->manager = new MySqlSchemaManager($conn);

            $conn->expects($this->once())->method('fetchAll')->will($this->returnValue($this->getColumnDefinition($platform)));
            $columns = $this->manager->listTableColumns('dummy');

            $this->assertFalse($columns['id']->getNotnull());
            $this->assertNull($columns['id']->getDefault());

            $this->assertTrue($columns['created_by']->getNotnull());
            $this->assertNull($columns['created_by']->getDefault());

            $this->assertFalse($columns['text_1']->getNotnull());
            $this->assertEquals('NULL', $columns['text_1']->getDefault());
        }
    }

    public function getColumnDefinition($platform)
    {
        $mariaDb102 = ($platform instanceof MariaDb102Platform);
        return [
            [
                'Field'   => 'id',
                'Type'    => 'int(10) unsigned',
                'Null'    => 'YES',
                'Key'     => '',
                'Default' => $mariaDb102 ? 'NULL' : null,
                'Extra'   => 'auto_increment',
                'Comment' => '',
                'CharacterSet' => null,
                'Collation' => null
            ],[
                'Field'=> 'created_by',
                'Type'=> 'varchar(40)',
                'Null'=> 'NO',
                'Key'=>  '',
                'Default'=> null, // both mysql and mariadb will return null (not null column)
                'Extra' => '',
                'Comment' => 'Creator name',
                'CharacterSet' => 'utf8',
                'Collation'=> 'utf8_unicode_ci'
            ],
            [
                'Field'   => 'text_1',
                'Type'    => 'varchar(50)',
                'Null'    => 'YES',
                'Key'     => '',
                'Default' => $mariaDb102 ? "'NULL'" : 'NULL',
                'Extra'   => '',
                'Comment' => '',
                'CharacterSet' => 'utf8',
                'Collation'=> 'utf8_unicode_ci'
            ]
        ];

    }


    public function getFKDefinition()
    {
        return array(
            array(
                "CONSTRAINT_NAME" => "FK_C1B1712387FE737264DE5A5511B8B3E",
                "COLUMN_NAME" => "column_1",
                "REFERENCED_TABLE_NAME" => "dummy",
                "REFERENCED_COLUMN_NAME" => "column_1",
                "update_rule" => "RESTRICT",
                "delete_rule" => "RESTRICT",
            ),
            array(
                "CONSTRAINT_NAME" => "FK_C1B1712387FE737264DE5A5511B8B3E",
                "COLUMN_NAME" => "column_2",
                "REFERENCED_TABLE_NAME" => "dummy",
                "REFERENCED_COLUMN_NAME" => "column_2",
                "update_rule" => "RESTRICT",
                "delete_rule" => "RESTRICT",
            ),
            array(
                "CONSTRAINT_NAME" => "FK_C1B1712387FE737264DE5A5511B8B3E",
                "COLUMN_NAME" => "column_3",
                "REFERENCED_TABLE_NAME" => "dummy",
                "REFERENCED_COLUMN_NAME" => "column_3",
                "update_rule" => "RESTRICT",
                "delete_rule" => "RESTRICT",
            )
        );
    }
}