SqlParserTest.php

Go to the documentation of this file.

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

class SqlParserTest extends \TYPO3\CMS\Core\Tests\UnitTestCase {

    protected $fixture;

    public function setUp() {
        $this->fixture = $this->getAccessibleMock('\\TYPO3\\CMS\\Core\\Database\\SqlParser', array('dummy'));
    }

    public function compileWhereClauseDoesNotDropClauses() {
        $clauses = array(
            0 => array(
                'modifier' => '',
                'table' => 'pages',
                'field' => 'fe_group',
                'calc' => '',
                'comparator' => '=',
                'value' => array(
                    0 => '',
                    1 => '\''
                )
            ),
            1 => array(
                'operator' => 'OR',
                'modifier' => '',
                'func' => array(
                    'type' => 'IFNULL',
                    'default' => array(
                        0 => '1',
                        1 => '\''
                    ),
                    'table' => 'pages',
                    'field' => 'fe_group'
                )
            ),
            2 => array(
                'operator' => 'OR',
                'modifier' => '',
                'table' => 'pages',
                'field' => 'fe_group',
                'calc' => '',
                'comparator' => '=',
                'value' => array(
                    0 => '0',
                    1 => '\''
                )
            ),
            3 => array(
                'operator' => 'OR',
                'modifier' => '',
                'func' => array(
                    'type' => 'FIND_IN_SET',
                    'str' => array(
                        0 => '0',
                        1 => '\''
                    ),
                    'table' => 'pages',
                    'field' => 'fe_group'
                ),
                'comparator' => ''
            ),
            4 => array(
                'operator' => 'OR',
                'modifier' => '',
                'func' => array(
                    'type' => 'FIND_IN_SET',
                    'str' => array(
                        0 => '-1',
                        1 => '\''
                    ),
                    'table' => 'pages',
                    'field' => 'fe_group'
                ),
                'comparator' => ''
            ),
            5 => array(
                'operator' => 'OR',
                'modifier' => '',
                'func' => array(
                    'type' => 'CAST',
                    'table' => 'pages',
                    'field' => 'fe_group',
                    'datatype' => 'CHAR'
                ),
                'comparator' => '=',
                'value' => array(
                    0 => '',
                    1 => '\''
                )
            )
        );
        $output = $this->fixture->compileWhereClause($clauses);
        $parts = explode(' OR ', $output);
        $this->assertSame(count($clauses), count($parts));
        $this->assertContains('IFNULL', $output);
    }

    public function trimSqlReallyTrimsAllWhitespaceDataProvider() {
        return array(
            'Nothing to trim' => array('SELECT * FROM test WHERE 1=1;', 'SELECT * FROM test WHERE 1=1 '),
            'Space after ;' => array('SELECT * FROM test WHERE 1=1; ', 'SELECT * FROM test WHERE 1=1 '),
            'Space before ;' => array('SELECT * FROM test WHERE 1=1 ;', 'SELECT * FROM test WHERE 1=1 '),
            'Space before and after ;' => array('SELECT * FROM test WHERE 1=1 ; ', 'SELECT * FROM test WHERE 1=1 '),
            'Linefeed after ;' => array('SELECT * FROM test WHERE 1=1' . LF . ';', 'SELECT * FROM test WHERE 1=1 '),
            'Linefeed before ;' => array('SELECT * FROM test WHERE 1=1;' . LF, 'SELECT * FROM test WHERE 1=1 '),
            'Linefeed before and after ;' => array('SELECT * FROM test WHERE 1=1' . LF . ';' . LF, 'SELECT * FROM test WHERE 1=1 '),
            'Tab after ;' => array('SELECT * FROM test WHERE 1=1' . TAB . ';', 'SELECT * FROM test WHERE 1=1 '),
            'Tab before ;' => array('SELECT * FROM test WHERE 1=1;' . TAB, 'SELECT * FROM test WHERE 1=1 '),
            'Tab before and after ;' => array('SELECT * FROM test WHERE 1=1' . TAB . ';' . TAB, 'SELECT * FROM test WHERE 1=1 '),
        );
    }

    public function trimSqlReallyTrimsAllWhitespace($sql, $expected) {
        $result = $this->fixture->_call('trimSQL', $sql);
        $this->assertSame($expected, $result);
    }

}