ilDatabaseReservedWordsTest.php

Go to the documentation of this file.

<?php

class ilDatabaseReservedWordsTest extends PHPUnit_Framework_TestCase
{
    protected function setUp()
    {
        PHPUnit_Framework_Error_Notice::$enabled = false;
        PHPUnit_Framework_Error_Deprecated::$enabled = false;
        parent::setUp();
        require_once('./Services/Database/classes/class.ilDBConstants.php');
        global $ilDB, $DIC;
        require_once('./Services/Database/classes/PDO/class.ilDBPdoMySQLInnoDB.php');
        $ilDB = new ilDBPdoMySQLInnoDB();
        $DIC['ilDB'] = $ilDB;
    }


    public function testReservedMDB2($word, $is_reserved)
    {
        require_once('./Services/Database/classes/MDB2/class.ilDBMySQL.php');
        $this->assertEquals($is_reserved, ilDBMySQL::isReservedWord($word));
    }


    public function testReservedPDO($word, $is_reserved)
    {
        require_once('./Services/Database/classes/PDO/class.ilDBPdoMySQLInnoDB.php');
        $this->assertEquals($is_reserved, ilDBPdoMySQLInnoDB::isReservedWord($word));
    }


    public function reservedData()
    {
        return [
            [ 'order', true ],
            [ 'myfield', false ],
            [ 'number', true ],
            [ 'null', true ],
            [ 'sensitive', true ],
            [ 'usage', true ],
            [ 'analyze', true ],
        ];
    }
}