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 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],
        ];
    }
}