DatabaseConnectionPostgresqlTest.php

Go to the documentation of this file.

<?php
namespace TYPO3\CMS\Dbal\Tests\Unit\Database;

class DatabaseConnectionPostgresqlTest extends AbstractTestCase {

    protected $subject;

    public function setUp() {
        $configuration = array(
            'handlerCfg' => array(
                '_DEFAULT' => array(
                    'type' => 'adodb',
                    'config' => array(
                        'driver' => 'postgres',
                    ),
                ),
            ),
            'mapping' => array(
                'tx_templavoila_tmplobj' => array(
                    'mapFieldNames' => array(
                        'datastructure' => 'ds',
                    ),
                ),
                'Members' => array(
                    'mapFieldNames' => array(
                        'pid' => '0',
                        'cruser_id' => '1',
                        'uid' => 'MemberID',
                    ),
                ),
            ),
        );
        $this->subject = $this->prepareSubject('postgres7', $configuration);
    }

    public function runningADOdbDriverReturnsTrueWithPostgresForPostgres8DefaultDriverConfiguration() {
        $this->assertTrue($this->subject->runningADOdbDriver('postgres'));
    }

    public function limitIsProperlyRemapped() {
        $result = $this->subject->SELECTquery('*', 'be_users', '1=1', '', '', '20');
        $expected = 'SELECT * FROM "be_users" WHERE 1 = 1 LIMIT 20';
        $this->assertEquals($expected, $this->cleanSql($result));
    }

    public function limitWithSkipIsProperlyRemapped() {
        $result = $this->subject->SELECTquery('*', 'be_users', '1=1', '', '', '20,40');
        $expected = 'SELECT * FROM "be_users" WHERE 1 = 1 LIMIT 40 OFFSET 20';
        $this->assertEquals($expected, $this->cleanSql($result));
    }

    public function findInSetIsProperlyRemapped() {
        $result = $this->subject->SELECTquery('*', 'fe_users', 'FIND_IN_SET(10, usergroup)');
        $expected = 'SELECT * FROM "fe_users" WHERE FIND_IN_SET(10, CAST("usergroup" AS CHAR)) != 0';
        $this->assertEquals($expected, $this->cleanSql($result));
    }

    public function likeBinaryOperatorIsRemappedToLike() {
        $result = $this->subject->SELECTquery('*', 'tt_content', 'bodytext LIKE BINARY \'test\'');
        $expected = 'SELECT * FROM "tt_content" WHERE "bodytext" LIKE \'test\'';
        $this->assertEquals($expected, $this->cleanSql($result));
    }

    public function notLikeBinaryOperatorIsRemappedToNotLike() {
        $result = $this->subject->SELECTquery('*', 'tt_content', 'bodytext NOT LIKE BINARY \'test\'');
        $expected = 'SELECT * FROM "tt_content" WHERE "bodytext" NOT LIKE \'test\'';
        $this->assertEquals($expected, $this->cleanSql($result));
    }

    public function likeOperatorIsRemappedToIlike() {
        $result = $this->subject->SELECTquery('*', 'tt_content', 'bodytext LIKE \'test\'');
        $expected = 'SELECT * FROM "tt_content" WHERE "bodytext" ILIKE \'test\'';
        $this->assertEquals($expected, $this->cleanSql($result));
    }

    public function notLikeOperatorIsRemappedToNotIlike() {
        $result = $this->subject->SELECTquery('*', 'tt_content', 'bodytext NOT LIKE \'test\'');
        $expected = 'SELECT * FROM "tt_content" WHERE "bodytext" NOT ILIKE \'test\'';
        $this->assertEquals($expected, $this->cleanSql($result));
    }

    public function notEqualAnsiOperatorCanBeParsed() {
        $result = $this->subject->SELECTquery('*', 'pages', 'pid<>3');
        $expected = 'SELECT * FROM "pages" WHERE "pid" <> 3';
        $this->assertEquals($expected, $this->cleanSql($result));
    }

    public function alterTableAddFieldWithAutoIncrementIsRemappedToSerialType() {
        $parseString = 'ALTER TABLE sys_file ADD uid INT(11) NOT NULL AUTO_INCREMENT';
        $components = $this->subject->SQLparser->_callRef('parseALTERTABLE', $parseString);
        $this->assertInternalType('array', $components);

        $result = $this->subject->SQLparser->compileSQL($components);
        $expected = array('ALTER TABLE "sys_file" ADD COLUMN "uid" SERIAL');
        $this->assertSame($expected, $this->cleanSql($result));
    }

}