PostgreSQL100PlatformTest.php 943 Bytes
Newer Older
1 2 3 4
<?php

declare(strict_types=1);

5
namespace Doctrine\DBAL\Tests\Platforms;
6

7
use Doctrine\DBAL\Platforms\AbstractPlatform;
8 9
use Doctrine\DBAL\Platforms\PostgreSQL100Platform;

10
class PostgreSQL100PlatformTest extends PostgreSQL94PlatformTest
11
{
12
    public function createPlatform() : AbstractPlatform
13 14 15 16 17 18 19 20 21 22 23 24 25 26 27
    {
        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
28
            $this->platform->getListSequencesSQL('test_db')
29 30 31
        );
    }
}