Doctrine\Tests\DBAL\Functional\Platform\DefaultExpressionTest

Complexity

Total Complexity

5

Size/Duplication

Total Lines	63
Duplicated Lines	0 %

Importance

Changes

0

2 Methods

Rating	Name	Duplication	Size	Complexity
A	expressionProvider()	0	32	4
A	testDefaultExpression()	0	21	1

<?php

declare(strict_types=1);

namespace Doctrine\Tests\DBAL\Functional\Platform;

use Doctrine\DBAL\FetchMode;
use Doctrine\DBAL\Platforms\AbstractPlatform;
use Doctrine\DBAL\Platforms\MySqlPlatform;
use Doctrine\DBAL\Platforms\OraclePlatform;
use Doctrine\DBAL\Schema\Table;
use Doctrine\DBAL\Types\Types;
use Doctrine\Tests\DbalFunctionalTestCase;
use function sprintf;

class DefaultExpressionTest extends DbalFunctionalTestCase
{
    /**
     * @dataProvider expressionProvider
     */
    public function testDefaultExpression(string $type, callable $expression) : void
    {
        $platform   = $this->connection->getDatabasePlatform();
        $defaultSql = $expression($platform, $this);

        $table = new Table('default_expr_test');
        $table->addColumn('actual_value', $type);
        $table->addColumn('default_value', $type, ['default' => $defaultSql]);
        $this->connection->getSchemaManager()->dropAndCreateTable($table);

        $query = sprintf(
            'INSERT INTO default_expr_test (actual_value) VALUES (%s)',
            $defaultSql
        );

        $this->connection->exec($query);

        $query                        = sprintf('SELECT default_value, actual_value FROM default_expr_test');
        [$actualValue, $defaultValue] = $this->connection->query($query)->fetch(FetchMode::NUMERIC);

        self::assertEquals($actualValue, $defaultValue);
    }

    /**
     * @return mixed[][]
     */
    public static function expressionProvider() : iterable
    {
        yield 'current-date' => [

The expression yield 'current-date' => array(Doctrine\DBAL\Types\Types::DATE_MUTABLE, function(...) { /* ... */ }) returns the type Generator which is incompatible with the documented return type array<mixed,array<mixed,mixed>>.

            Types::DATE_MUTABLE,
            static function (AbstractPlatform $platform) : string {
                if ($platform instanceof MySqlPlatform) {
                    self::markTestSkipped('Not supported on MySQL');
                }

                return $platform->getCurrentDateSQL();
            },
        ];

        yield 'current-time' => [
            Types::TIME_MUTABLE,
            static function (AbstractPlatform $platform) : string {
                if ($platform instanceof MySqlPlatform) {
                    self::markTestSkipped('Not supported on MySQL');
                }

                if ($platform instanceof OraclePlatform) {
                    self::markTestSkipped('Not supported on Oracle');
                }

                return $platform->getCurrentTimeSQL();
            },
        ];

        yield 'current-timestamp' => [
            Types::DATETIME_MUTABLE,
            static function (AbstractPlatform $platform) : string {
                return $platform->getCurrentTimestampSQL();
            },
        ];
    }
}