PostgreSQL100PlatformTest.php 980 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 13 14
{
    /**
     * {@inheritdoc}
     */
15
    public function createPlatform() : AbstractPlatform
16 17 18 19 20 21 22 23 24 25 26 27 28 29 30
    {
        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
31
            $this->platform->getListSequencesSQL('test_db')
32 33 34
        );
    }
}