PostgreSQL100PlatformTest.php 939 Bytes
Newer Older
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29
<?php

declare(strict_types=1);

namespace Doctrine\Tests\DBAL\Platforms;

use Doctrine\DBAL\Platforms\PostgreSQL100Platform;

class PostgreSQL100PlatformTest extends PostgreSQL94PlatformTest
{
    /**
     * {@inheritdoc}
     */
    public function createPlatform() : PostgreSQL100Platform
    {
        return new PostgreSQL100Platform();
    }

    public function testGetListSequencesSQL() : void
    {
        self::assertSame(
            "SELECT sequence_name AS relname,
                       sequence_schema AS schemaname,
                       minimum_value AS min_value, 
                       increment AS increment_by
                FROM   information_schema.sequences
                WHERE  sequence_catalog = 'test_db'
                AND    sequence_schema NOT LIKE 'pg\_%'
                AND    sequence_schema != 'information_schema'",
Sergei Morozov's avatar
Sergei Morozov committed
30
            $this->platform->getListSequencesSQL('test_db')
31 32 33
        );
    }
}