DatabaseConnectionTest.php

Go to the documentation of this file.

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

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

    // Write/Read tests for charsets and binaries

    public function storedFullAsciiRangeCallsLinkObjectWithGivenData() {
        $binaryString = '';
        for ($i = 0; $i < 256; $i++) {
            $binaryString .= chr($i);
        }

        $subject = $this->getAccessibleMock('TYPO3\\CMS\\Core\\Database\\DatabaseConnection', array('fullQuoteStr'), array(), '', FALSE);
        $subject->_set('isConnected', TRUE);
        $subject
            ->expects($this->any())
            ->method('fullQuoteStr')
            ->will($this->returnCallback(function ($data) {
                return $data;
            }));
        $mysqliMock = $this->getMock('mysqli');
        $mysqliMock
            ->expects($this->once())
            ->method('query')
            ->with('INSERT INTO aTable (fieldblob) VALUES (' . $binaryString . ')');
        $subject->_set('link', $mysqliMock);

        $subject->exec_INSERTquery('aTable', array('fieldblob' => $binaryString));
    }

    public function storedGzipCompressedDataReturnsSameData() {
        $testStringWithBinary = @gzcompress('sdfkljer4587');

        $subject = $this->getAccessibleMock('TYPO3\\CMS\\Core\\Database\\DatabaseConnection', array('fullQuoteStr'), array(), '', FALSE);
        $subject->_set('isConnected', TRUE);
        $subject
            ->expects($this->any())
            ->method('fullQuoteStr')
            ->will($this->returnCallback(function ($data) {
                return $data;
            }));
        $mysqliMock = $this->getMock('mysqli');
        $mysqliMock
            ->expects($this->once())
            ->method('query')
            ->with('INSERT INTO aTable (fieldblob) VALUES (' . $testStringWithBinary . ')');
        $subject->_set('link', $mysqliMock);

        $subject->exec_INSERTquery('aTable', array('fieldblob' => $testStringWithBinary));
    }


    // Tests concerning listQuery

    public function listQueryWithIntegerCommaAsValue() {
        $subject = $this->getAccessibleMock('TYPO3\\CMS\\Core\\Database\\DatabaseConnection', array('quoteStr'), array(), '', FALSE);
        $subject->_set('isConnected', TRUE);
        $subject
            ->expects($this->any())
            ->method('quoteStr')
            ->will($this->returnCallback(function ($data) {
                return $data;
            }));
        // Note: 44 = ord(',')
        $this->assertEquals($subject->listQuery('dummy', 44, 'table'), $subject->listQuery('dummy', '44', 'table'));
    }

    public function listQueryThrowsExceptionIfValueContainsComma() {
        $subject = $this->getAccessibleMock('TYPO3\\CMS\\Core\\Database\\DatabaseConnection', array('quoteStr'), array(), '', FALSE);
        $subject->_set('isConnected', TRUE);
        $subject->listQuery('aField', 'foo,bar', 'aTable');
    }


    // Tests concerning searchQuery

    public function searchQueryDataProvider() {
        return array(
            'One search word in one field' => array(
                '(pages.title LIKE \'%TYPO3%\')',
                array('TYPO3'),
                array('title'),
                'pages',
                'AND'
            ),

            'One search word in multiple fields' => array(
                '(pages.title LIKE \'%TYPO3%\' OR pages.keyword LIKE \'%TYPO3%\' OR pages.description LIKE \'%TYPO3%\')',
                array('TYPO3'),
                array('title', 'keyword', 'description'),
                'pages',
                'AND'
            ),

            'Multiple search words in one field with AND constraint' => array(
                '(pages.title LIKE \'%TYPO3%\') AND (pages.title LIKE \'%is%\') AND (pages.title LIKE \'%great%\')',
                array('TYPO3', 'is', 'great'),
                array('title'),
                'pages',
                'AND'
            ),

            'Multiple search words in one field with OR constraint' => array(
                '(pages.title LIKE \'%TYPO3%\') OR (pages.title LIKE \'%is%\') OR (pages.title LIKE \'%great%\')',
                array('TYPO3', 'is', 'great'),
                array('title'),
                'pages',
                'OR'
            ),

            'Multiple search words in multiple fields with AND constraint' => array(
                '(pages.title LIKE \'%TYPO3%\' OR pages.keywords LIKE \'%TYPO3%\' OR pages.description LIKE \'%TYPO3%\') AND ' .
                    '(pages.title LIKE \'%is%\' OR pages.keywords LIKE \'%is%\' OR pages.description LIKE \'%is%\') AND ' .
                    '(pages.title LIKE \'%great%\' OR pages.keywords LIKE \'%great%\' OR pages.description LIKE \'%great%\')',
                array('TYPO3', 'is', 'great'),
                array('title', 'keywords', 'description'),
                'pages',
                'AND'
            ),

            'Multiple search words in multiple fields with OR constraint' => array(
                '(pages.title LIKE \'%TYPO3%\' OR pages.keywords LIKE \'%TYPO3%\' OR pages.description LIKE \'%TYPO3%\') OR ' .
                    '(pages.title LIKE \'%is%\' OR pages.keywords LIKE \'%is%\' OR pages.description LIKE \'%is%\') OR ' .
                    '(pages.title LIKE \'%great%\' OR pages.keywords LIKE \'%great%\' OR pages.description LIKE \'%great%\')',
                array('TYPO3', 'is', 'great'),
                array('title', 'keywords', 'description'),
                'pages',
                'OR'
            ),
        );
    }

    public function searchQueryCreatesQuery($expectedResult, $searchWords, $fields, $table, $constraint) {
        $subject = $this->getMock('TYPO3\\CMS\\Core\\Database\\DatabaseConnection', array('quoteStr'), array(), '', FALSE);
        $subject
            ->expects($this->any())
            ->method('quoteStr')
            ->will($this->returnCallback(function ($data) {
                return $data;
            }));

        $this->assertSame($expectedResult, $subject->searchQuery($searchWords, $fields, $table, $constraint));
    }


    // Tests concerning escapeStringForLikeComparison

    public function escapeStringForLikeComparison() {
        $subject = $this->getMock('TYPO3\\CMS\\Core\\Database\\DatabaseConnection', array('dummy'), array(), '', FALSE);
        $this->assertEquals('foo\\_bar\\%', $subject->escapeStrForLike('foo_bar%', 'table'));
    }


    // Tests concerning stripOrderByForOrderByKeyword

    public function stripOrderByForOrderByKeywordDataProvider() {
        return array(
            'single ORDER BY' => array('ORDER BY name, tstamp', 'name, tstamp'),
            'single ORDER BY in lower case' => array('order by name, tstamp', 'name, tstamp'),
            'ORDER BY with additional space behind' => array('ORDER BY  name, tstamp', 'name, tstamp'),
            'ORDER BY without space between the words' => array('ORDERBY name, tstamp', 'name, tstamp'),
            'ORDER BY added twice' => array('ORDER BY ORDER BY name, tstamp', 'name, tstamp'),
            'ORDER BY added twice without spaces in the first occurrence' => array('ORDERBY ORDER BY  name, tstamp', 'name, tstamp'),
            'ORDER BY added twice without spaces in the second occurrence' => array('ORDER BYORDERBY name, tstamp', 'name, tstamp'),
            'ORDER BY added twice without spaces' => array('ORDERBYORDERBY name, tstamp', 'name, tstamp'),
            'ORDER BY added twice without spaces afterwards' => array('ORDERBYORDERBYname, tstamp', 'name, tstamp'),
        );
    }

    public function stripOrderByForOrderByKeyword($orderByClause, $expectedResult) {
        $subject = $this->getMock('TYPO3\\CMS\\Core\\Database\\DatabaseConnection', array('dummy'), array(), '', FALSE);
        $strippedQuery = $subject->stripOrderBy($orderByClause);
        $this->assertEquals($expectedResult, $strippedQuery);
    }


    // Tests concerning stripGroupByForGroupByKeyword

    public function stripGroupByForGroupByKeywordDataProvider() {
        return array(
            'single GROUP BY' => array('GROUP BY name, tstamp', 'name, tstamp'),
            'single GROUP BY in lower case' => array('group by name, tstamp', 'name, tstamp'),
            'GROUP BY with additional space behind' => array('GROUP BY  name, tstamp', 'name, tstamp'),
            'GROUP BY without space between the words' => array('GROUPBY name, tstamp', 'name, tstamp'),
            'GROUP BY added twice' => array('GROUP BY GROUP BY name, tstamp', 'name, tstamp'),
            'GROUP BY added twice without spaces in the first occurrence' => array('GROUPBY GROUP BY  name, tstamp', 'name, tstamp'),
            'GROUP BY added twice without spaces in the second occurrence' => array('GROUP BYGROUPBY name, tstamp', 'name, tstamp'),
            'GROUP BY added twice without spaces' => array('GROUPBYGROUPBY name, tstamp', 'name, tstamp'),
            'GROUP BY added twice without spaces afterwards' => array('GROUPBYGROUPBYname, tstamp', 'name, tstamp'),
        );
    }

    public function stripGroupByForGroupByKeyword($groupByClause, $expectedResult) {
        $subject = $this->getMock('TYPO3\\CMS\\Core\\Database\\DatabaseConnection', array('dummy'), array(), '', FALSE);
        $strippedQuery = $subject->stripGroupBy($groupByClause);
        $this->assertEquals($expectedResult, $strippedQuery);
    }


    // Tests concerning stripOrderByForOrderByKeyword

    public function cleanIntArrayDataProvider() {
        return array(
            'simple array' => array(
                array(1, 2, 3),
                array(1, 2, 3)
            ),
            'string array' => array(
                array('2', '4', '8'),
                array(2, 4, 8)
            ),
            'string array with letters #1' => array(
                array('3', '6letters', '12'),
                array(3, 6, 12)
            ),
            'string array with letters #2' => array(
                array('3', 'letters6', '12'),
                array(3, 0, 12)
            ),
            'string array with letters #3' => array(
                array('3', '6letters4', '12'),
                array(3, 6, 12)
            ),
            'associative array' => array(
                array('apples' => 3, 'bananas' => 4, 'kiwis' => 9),
                array('apples' => 3, 'bananas' => 4, 'kiwis' => 9)
            ),
            'associative string array' => array(
                array('apples' => '1', 'bananas' => '5', 'kiwis' => '7'),
                array('apples' => 1, 'bananas' => 5, 'kiwis' => 7)
            ),
            'associative string array with letters #1' => array(
                array('apples' => '1', 'bananas' => 'no5', 'kiwis' => '7'),
                array('apples' => 1, 'bananas' => 0, 'kiwis' => 7)
            ),
            'associative string array with letters #2' => array(
                array('apples' => '1', 'bananas' => '5yes', 'kiwis' => '7'),
                array('apples' => 1, 'bananas' => 5, 'kiwis' => 7)
            ),
            'associative string array with letters #3' => array(
                array('apples' => '1', 'bananas' => '5yes9', 'kiwis' => '7'),
                array('apples' => 1, 'bananas' => 5, 'kiwis' => 7)
            ),
            'multidimensional associative array' => array(
                array('apples' => '1', 'bananas' => array(3, 4), 'kiwis' => '7'),
                // intval(array(...)) is 1
                // But by specification "cleanIntArray" should only get used on one-dimensional arrays
                array('apples' => 1, 'bananas' => 1, 'kiwis' => 7)
            ),
        );
    }

    public function cleanIntArray($exampleData, $expectedResult) {
        $subject = new \TYPO3\CMS\Core\Database\DatabaseConnection();
        $sanitizedArray = $subject->cleanIntArray($exampleData);
        $this->assertEquals($expectedResult, $sanitizedArray);
    }

}