Doctrine\Tests\DBAL\Functional\Platform\ColumnTest

Complexity

Total Complexity

11

Size/Duplication

Total Lines	73
Duplicated Lines	0 %

Importance

Changes

0

10 Methods

Rating	Name	Duplication	Size	Complexity
A	requirePlatform()	0	7	2
A	testVariableLengthStringNoLength()	0	3	1
A	testFixedLengthBinaryWithLength()	0	6	1
A	testFixedLengthStringWithLength()	0	6	1
A	testVariableLengthBinaryWithLength()	0	3	1
A	testVariableLengthStringWithLength()	0	3	1
A	assertColumn()	0	13	1
A	testVariableLengthBinaryNoLength()	0	3	1
A	testFixedLengthBinaryNoLength()	0	3	1
A	testFixedLengthStringNoLength()	0	3	1

<?php

declare(strict_types=1);

namespace Doctrine\Tests\DBAL\Functional\Platform;

use Doctrine\DBAL\ParameterType;
use Doctrine\DBAL\Schema\Table;
use Doctrine\DBAL\Types\Type;
use Doctrine\DBAL\Types\Types;
use Doctrine\Tests\DbalFunctionalTestCase;
use function sprintf;

abstract class ColumnTest extends DbalFunctionalTestCase
{
    public function testVariableLengthStringNoLength() : void
    {
        $this->assertColumn(Types::STRING, [], 'Test', ParameterType::STRING);
    }

    public function testVariableLengthStringWithLength() : void
    {
        $this->assertColumn(Types::STRING, ['length' => 8], 'Doctrine', ParameterType::STRING);
    }

    public function testFixedLengthStringNoLength() : void
    {
        $this->assertColumn(Types::STRING, ['fixed' => true], 'Z', ParameterType::STRING);
    }

    public function testFixedLengthStringWithLength() : void
    {
        $this->assertColumn(Types::STRING, [
            'fixed' => true,
            'length' => 8,
        ], 'Doctrine', ParameterType::STRING);
    }

    public function testVariableLengthBinaryNoLength() : void
    {
        $this->assertColumn(Types::BINARY, [], "\x00\x01\x02\x03", ParameterType::BINARY);
    }

    public function testVariableLengthBinaryWithLength() : void
    {
        $this->assertColumn(Types::BINARY, ['length' => 8], "\xCE\xC6\x6B\xDD\x9F\xD8\x07\xB4", ParameterType::BINARY);
    }

    public function testFixedLengthBinaryNoLength() : void
    {
        $this->assertColumn(Types::BINARY, ['fixed' => true], "\xFF", ParameterType::BINARY);
    }

    public function testFixedLengthBinaryWithLength() : void
    {
        $this->assertColumn(Types::BINARY, [
            'fixed' => true,
            'length' => 8,
        ], "\xA0\x0A\x7B\x0E\xA4\x60\x78\xD8", ParameterType::BINARY);
    }

    protected function requirePlatform(string $class) : void
    {
        if ($this->connection->getDatabasePlatform() instanceof $class) {
            return;
        }

        self::markTestSkipped(sprintf('The test requires %s', $class));
    }

    /**
     * @param array<string, mixed> $column
     */
    protected function assertColumn(string $type, array $column, string $value, int $bindType) : void
    {
        $table = new Table('column_test');
        $table->addColumn('val', $type, $column);

        $sm = $this->connection->getSchemaManager();
        $sm->dropAndCreateTable($table);

        self::assertSame(1, $this->connection->insert('column_test', ['val' => $value], [$bindType]));

        self::assertSame($value, Type::getType($type)->convertToPHPValue(
            $this->connection->fetchColumn('SELECT val FROM column_test'),
            $this->connection->getDatabasePlatform()
        ));
    }
}