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