Doctrine\Tests\DBAL\Functional\Platform\ColumnTest

Complexity

Total Complexity

6

Size/Duplication

Total Lines	57
Duplicated Lines	0 %

Importance

Changes

0

5 Methods

Rating	Name	Duplication	Size	Complexity
A	requirePlatform()	0	7	2
A	testFixedLengthStringWithLength()	0	6	1
A	stringProvider()	0	5	1
A	testVariableLengthStringWithLength()	0	3	1
A	assertColumn()	0	13	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
{
    /**
     * @dataProvider stringProvider
     */
    public function testVariableLengthStringWithLength(string $value) : void
    {
        $this->assertColumn(Types::STRING, ['length' => 8], $value, ParameterType::STRING);
    }

    /**
     * @dataProvider stringProvider
     */
    public function testFixedLengthStringWithLength(string $value) : void
    {
        $this->assertColumn(Types::STRING, [
            'fixed' => true,
            'length' => 8,
        ], $value, ParameterType::STRING);
    }

    /**
     * @return iterable<string, array<int, mixed>>
     */
    public static function stringProvider() : iterable
    {
        return [
            'ansi' => ['Doctrine'],
            'unicode' => ['Доктрина'],
        ];
    }

    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()
        ));
    }
}