Doctrine\Tests\DBAL\Platforms\MariaDb102PlatformTest

Complexity

Total Complexity

7

Size/Duplication

Total Lines	85
Duplicated Lines	0 %

Coupling/Cohesion

Components	1
Dependencies	5

Importance

Changes

0

7 Methods

Rating	Name	Duplication	Size	Complexity
A	createPlatform()	0	4	1
A	testHasNativeJsonType()	0	4	1
A	testReturnsJsonTypeDeclarationSQL()	0	4	1
A	testInitializesJsonTypeMapping()	0	5	1
A	testDoesNotPropagateDefaultValuesForUnsupportedColumnTypes()	0	4	1
A	testPropagateDefaultValuesForTextAndBlobColumnTypes()	0	21	1
A	testPropagateDefaultValuesForJsonColumnType()	0	21	1

<?php

namespace Doctrine\Tests\DBAL\Platforms;

use Doctrine\DBAL\Platforms\MariaDb102Platform;
use Doctrine\DBAL\Schema\Comparator;
use Doctrine\DBAL\Schema\Table;
use Doctrine\DBAL\Types\Type;

class MariaDb102PlatformTest extends AbstractMySQLPlatformTestCase
{
    /**
     * {@inheritdoc}
     */
    public function createPlatform()
    {
        return new MariaDb102Platform();
    }

    public function testHasNativeJsonType()
    {
        self::assertTrue($this->_platform->hasNativeJsonType());
    }

    public function testReturnsJsonTypeDeclarationSQL()
    {
        self::assertSame('JSON', $this->_platform->getJsonTypeDeclarationSQL([]));
    }

    public function testInitializesJsonTypeMapping()
    {
        self::assertTrue($this->_platform->hasDoctrineTypeMappingFor('json'));
        self::assertSame(Type::JSON, $this->_platform->getDoctrineTypeMapping('json'));
    }

    /**
     * Overrides and skips AbstractMySQLPlatformTestCase test regarding propagation
     * of unsupported default values for Blob and Text columns.
     *
     * @see AbstractMySQLPlatformTestCase::testDoesNotPropagateDefaultValuesForUnsupportedColumnTypes()
     */
    public function testDoesNotPropagateDefaultValuesForUnsupportedColumnTypes()
    {
        $this->markTestSkipped('MariaDB102Platform support propagation of default values for BLOB and TEXT columns');
    }

    /**
     * Since MariaDB 10.2, Text and Blob can have a default value.
     */
    public function testPropagateDefaultValuesForTextAndBlobColumnTypes()
    {
        $table = new Table("text_blob_default_value");

        $table->addColumn('def_text', 'text', array('default' => "d''ef"));
        $table->addColumn('def_blob', 'blob', array('default' => 'def'));

        self::assertSame(
            ["CREATE TABLE text_blob_default_value (def_text LONGTEXT DEFAULT 'd''''ef' NOT NULL, def_blob LONGBLOB DEFAULT 'def' NOT NULL) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB"],
            $this->_platform->getCreateTableSQL($table)
        );

        $diffTable = clone $table;

        $diffTable->changeColumn('def_text', ['default' => "d''ef"]);
        $diffTable->changeColumn('def_blob', ['default' => 'def']);

        $comparator = new Comparator();

        self::assertFalse($comparator->diffTable($table, $diffTable));

It seems like $comparator->diffTable($table, $diffTable) targeting Doctrine\DBAL\Schema\Comparator::diffTable() can also be of type object<Doctrine\DBAL\Schema\TableDiff>; however, PHPUnit\Framework\Assert::assertFalse() does only seem to accept boolean, maybe add an additional type check?

    }

    public function testPropagateDefaultValuesForJsonColumnType()
    {
        $table = new Table("text_json_default_value");

        $json = json_encode(['prop1' => "O'Connor", 'prop2' => 10]);

        $table->addColumn('def_json', 'text', ['default' => $json]);

        self::assertSame(
            ["CREATE TABLE text_json_default_value (def_json LONGTEXT DEFAULT '{\"prop1\":\"O''Connor\",\"prop2\":10}' NOT NULL) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB"],
            $this->_platform->getCreateTableSQL($table)
        );

        $diffTable = clone $table;

        $diffTable->changeColumn('def_json', ['default' => $json]);

        $comparator = new Comparator();

        self::assertFalse($comparator->diffTable($table, $diffTable));

It seems like $comparator->diffTable($table, $diffTable) targeting Doctrine\DBAL\Schema\Comparator::diffTable() can also be of type object<Doctrine\DBAL\Schema\TableDiff>; however, PHPUnit\Framework\Assert::assertFalse() does only seem to accept boolean, maybe add an additional type check?

    }

}