TestCase for the ilDatabaseCommonTest. More...

Inheritance diagram for ilDatabaseImplementationBaseTest:

Collaboration diagram for ilDatabaseImplementationBaseTest:

Public Member Functions
	testInstance ()
	Test instance implements ilDBInterface and is ilDBInnoDB. More...

	testConnection ()

	testCreateDatabase ()
	@depends testConnection More...

	testInsertNative ()
	@depends testConnection More...

	testQueryUtils ()

	testUpdateNative ()
	@depends testConnection More...

	testInsertSQL ()
	@depends testConnection More...

	testSelectUsrData ()

	testIndices ()
	@depends testConnection More...

	testTableColums ()
	@depends testConnection More...

	testSequences ()
	@depends testConnection More...

	testDBAnalyser ()
	@depends testConnection More...

	testDropSequence ()
	@depends testConnection More...

	testConstraints ()

	testChangeTableName ()
	@depends testConnection More...

	testRenameTableColumn ()
	@depends testConnection More...

	testModifyTableColumn ()
	@depends testConnection More...

	testLockTables ()
	@depends testConnection More...

	testTransactions ()
	@depends testConnection More...

	testDropTable ()
	@depends testConnection More...

Data Fields
const	INDEX_NAME = 'i1'

const	TABLE_NAME = 'il_ut_en'

const	CREATE_TABLE_ARRAY_KEY = 'create table'

Protected Member Functions
	setUp ()

	getIniFile ()

	connect (ilDBInterface $ilDBInterface, $missing_ini=false)

	getTableName ()

	tearDown ()

	getDBInstance ()

	changeGlobal (ilDBInterface $ilDBInterface)

	changeBack ()

	normalizeSQL ($sql)

	normalizetableName ($sql)

Protected Attributes
	$error_reporting_backup = 0

	$backupGlobals = false

	$db

	$mock

	$outputs

	$ildb_backup

	$type = ''

	$ini_file = '/var/www/ilias/data/trunk/client.ini.php'

	$set_up = false

Detailed Description

TestCase for the ilDatabaseCommonTest.

Author: Fabian Schmid fs@st.nosp@m.uder.nosp@m.-raim.nosp@m.ann..nosp@m.ch

Version: 1.0.0

Definition at line 30 of file ilDatabaseImplementationBaseTest.php.

Member Function Documentation

◆ changeBack()

ilDatabaseImplementationBaseTest::changeBack ( )

protected

Definition at line 590 of file ilDatabaseImplementationBaseTest.php.

                                        {
                global $ilDB;
                $ilDB = $this->ildb_backup;
        }

References $ilDB, and $ildb_backup.

Referenced by testModifyTableColumn(), and testRenameTableColumn().

Here is the caller graph for this function:

◆ changeGlobal()

ilDatabaseImplementationBaseTest::changeGlobal ( ilDBInterface $ilDBInterface )

protected

Parameters

\ilDBInterface $ilDBInterface

Definition at line 583 of file ilDatabaseImplementationBaseTest.php.

                                                                      {
                global $ilDB;
                $this->ildb_backup = $ilDB;
                $ilDB = $ilDBInterface;
        }

References $ilDB.

Referenced by testModifyTableColumn(), and testRenameTableColumn().

Here is the caller graph for this function:

◆ connect()

ilDatabaseImplementationBaseTest::connect	(	ilDBInterface	$ilDBInterface,
			$missing_ini = `false`
	)

finalprotected

Parameters

\ilDBInterface $ilDBInterface

Returns: bool

Definition at line 126 of file ilDatabaseImplementationBaseTest.php.

                                                                                             {
                require_once('./Services/Init/classes/class.ilIniFile.php');
                require_once('./Services/Init/classes/class.ilErrorHandling.php');
                $ilClientIniFile = new ilIniFile($this->getIniFile());
                $ilClientIniFile->read();
                $this->type = $ilClientIniFile->readVariable("db", "type");
                if ($missing_ini) {
                        $ilClientIniFile = new ilIniFile('');
                }
                $ilDBInterface->initFromIniFile($ilClientIniFile);
                $return = $ilDBInterface->connect($missing_ini);
 
                return $return;
        }

References ilDBInterface\connect(), getIniFile(), and ilDBInterface\initFromIniFile().

Referenced by setUp(), and testConnection().

Here is the call graph for this function:

Here is the caller graph for this function:

◆ getDBInstance()

ilDatabaseImplementationBaseTest::getDBInstance ( )

abstractprotected

Returns: \ilDBPdoMySQLInnoDB

Exceptions

ilDatabaseException

Reimplemented in ilDatabaseMDB2InnodbTest, ilDatabaseMDB2MyISAMTest, ilDatabaseMDB2PostgresTest, ilDatabasePDOGaleraTest, ilDatabasePDOInnodbTest, ilDatabasePDOMyISAMTest, and ilDatabasePDOPostgresTest.

Referenced by setUp(), and testConnection().

Here is the caller graph for this function:

◆ getIniFile()

ilDatabaseImplementationBaseTest::getIniFile ( )

protected

Returns: string

Definition at line 117 of file ilDatabaseImplementationBaseTest.php.

                                        {
                return $this->ini_file;
        }

References $ini_file.

Referenced by connect().

Here is the caller graph for this function:

◆ getTableName()

ilDatabaseImplementationBaseTest::getTableName ( )

protected

Returns: string

Reimplemented in ilDatabaseMDB2InnodbTest, ilDatabaseMDB2MyISAMTest, ilDatabaseMDB2PostgresTest, ilDatabasePDOGaleraTest, ilDatabasePDOInnodbTest, ilDatabasePDOMyISAMTest, and ilDatabasePDOPostgresTest.

Definition at line 145 of file ilDatabaseImplementationBaseTest.php.

                                          {
                return strtolower(self::TABLE_NAME . '_' . $this->db->getDBType());
        }

Referenced by normalizetableName(), testChangeTableName(), testCreateDatabase(), testDBAnalyser(), testDropSequence(), testDropTable(), testIndices(), testInsertNative(), testInsertSQL(), testModifyTableColumn(), testRenameTableColumn(), testSequences(), testTableColums(), and testUpdateNative().

Here is the caller graph for this function:

◆ normalizeSQL()

ilDatabaseImplementationBaseTest::normalizeSQL ( $sql )

protected

Parameters

$sql

Returns: string

Definition at line 600 of file ilDatabaseImplementationBaseTest.php.

                                              {
                return preg_replace('/[ \t]+/', ' ', preg_replace('/\s*$^\s*/m', " ", preg_replace("/\n/", "", preg_replace("/`/", "", $sql))));
        }

Referenced by testCreateDatabase(), testModifyTableColumn(), and testRenameTableColumn().

Here is the caller graph for this function:

◆ normalizetableName()

ilDatabaseImplementationBaseTest::normalizetableName ( $sql )

protected

Parameters

$sql

Returns: string

Definition at line 609 of file ilDatabaseImplementationBaseTest.php.

                                                    {
                return preg_replace("/" . $this->getTableName() . "|" . $this->getTableName() . "/", "table_name_replaced", $sql);
        }

References getTableName().

Here is the call graph for this function:

◆ setUp()

ilDatabaseImplementationBaseTest::setUp ( )

protected

Definition at line 73 of file ilDatabaseImplementationBaseTest.php.

                                   {
                if ($this->set_up) {
                        return;
                }
                //              echo phpversion() . "\n";
                $this->error_reporting_backup = error_reporting();
                error_reporting(E_ALL & ~E_NOTICE & ~E_DEPRECATED & ~E_WARNING & ~E_STRICT); // Due to PEAR Lib MDB2
 
                PHPUnit_Framework_Error_Notice::$enabled = false;
                PHPUnit_Framework_Error_Deprecated::$enabled = false;
 
                require_once('./libs/composer/vendor/autoload.php');
                if (!defined('DEVMODE')) {
                        define('DEVMODE', true);
                }
                require_once('./Services/Database/classes/class.ilDBWrapperFactory.php');
                $this->db = $this->getDBInstance();
                global $DIC, $ilDB;
                $DIC['ilDB'] = $this->db;
                $ilDB = $this->db;
                $this->connect($this->db);
 
                switch ($this->type) {
                        default:
                                require_once('./Services/Database/test/Implementations/data/MySQL/class.ilDatabaseMySQLTestMockData.php');
                                require_once('./Services/Database/test/Implementations/data/MySQL/class.ilDatabaseMySQLTestsDataOutputs.php');
                                $this->mock = new ilDatabaseMySQLTestMockData();
                                $this->outputs = new ilDatabaseMySQLTestsDataOutputs();
                                break;
                        case ilDBConstants::TYPE_POSTGRES:
                        case ilDBConstants::TYPE_PDO_POSTGRE:
                                require_once('./Services/Database/test/Implementations/data/Postgres/class.ilDatabasePostgresTestMockData.php');
                                require_once('./Services/Database/test/Implementations/data/Postgres/class.ilDatabasePostgresTestsDataOutputs.php');
                                $this->mock = new ilDatabasePostgresTestMockData();
                                $this->outputs = new ilDatabasePostgresTestsDataOutputs();
                                break;
                }
                $this->set_up = true;
        }

References $db, $DIC, $ilDB, connect(), defined, getDBInstance(), ilDBConstants\TYPE_PDO_POSTGRE, and ilDBConstants\TYPE_POSTGRES.

Here is the call graph for this function:

◆ tearDown()

ilDatabaseImplementationBaseTest::tearDown ( )

protected

Definition at line 150 of file ilDatabaseImplementationBaseTest.php.

                                      {
                $this->db = null;
                $this->mock = null;
                $this->outputs = null;
                $this->type = null;
                $this->set_up = false;
                error_reporting($this->error_reporting_backup);
        }

◆ testChangeTableName()

ilDatabaseImplementationBaseTest::testChangeTableName ( )

@depends testConnection

Definition at line 484 of file ilDatabaseImplementationBaseTest.php.

                                              {
                $this->db->dropTable($this->getTableName() . '_a', false);
                $this->db->renameTable($this->getTableName(), $this->getTableName() . '_a');
                $this->assertTrue($this->db->tableExists($this->getTableName() . '_a'));
                $this->db->renameTable($this->getTableName() . '_a', $this->getTableName());
        }

References getTableName().

Here is the call graph for this function:

◆ testConnection()

ilDatabaseImplementationBaseTest::testConnection ( )

Definition at line 175 of file ilDatabaseImplementationBaseTest.php.

                                         {
                //              $this->assertFalse($this->connect($this->getDBInstance(), true)); // Currently MDB2 Postgres doesn't check if connections possible
                $this->assertTrue($this->connect($this->getDBInstance()));
                if ($this->db->supportsEngineMigration()) {
                        //                      $this->db->migrateAllTablesToEngine($this->db->getStorageEngine());
                }
        }

References connect(), and getDBInstance().

Here is the call graph for this function:

◆ testConstraints()

ilDatabaseImplementationBaseTest::testConstraints ( )

Definition at line 476 of file ilDatabaseImplementationBaseTest.php.

                                          {
 
        }

◆ testCreateDatabase()

ilDatabaseImplementationBaseTest::testCreateDatabase ( )

@depends testConnection

Definition at line 197 of file ilDatabaseImplementationBaseTest.php.

                                             {
                $fields = $this->mock->getDBFields();
                $this->db->createTable($this->getTableName(), $fields, true);
                $this->db->addPrimaryKey($this->getTableName(), array( 'id' ));
                $this->assertTrue($this->db->tableExists($this->getTableName()));
 
                if (in_array($this->type, array( ilDBConstants::TYPE_PDO_POSTGRE, ilDBConstants::TYPE_POSTGRES ))) {
                        return; // SHOW CREATE TABLE CURRENTLY NOT SUPPORTED IN POSTGRES
                }
 
                $res = $this->db->query('SHOW CREATE TABLE ' . $this->getTableName());
                $data = $this->db->fetchAssoc($res);
 
                $data = array_change_key_case($data, CASE_LOWER);
 
                $create_table = $this->normalizeSQL($data[self::CREATE_TABLE_ARRAY_KEY]);
                $create_table_mock = $this->normalizeSQL($this->mock->getTableCreateSQL($this->getTableName(), $this->db->getStorageEngine()));
 
                $this->assertEquals($create_table_mock, $create_table);
        }

References $data, $res, getTableName(), normalizeSQL(), ilDBConstants\TYPE_PDO_POSTGRE, and ilDBConstants\TYPE_POSTGRES.

Here is the call graph for this function:

◆ testDBAnalyser()

ilDatabaseImplementationBaseTest::testDBAnalyser ( )

@depends testConnection

Definition at line 432 of file ilDatabaseImplementationBaseTest.php.

                                         {
                require_once('./Services/Database/classes/class.ilDBAnalyzer.php');
                $analyzer = new ilDBAnalyzer($this->db);
 
                // Field info
                //              $this->assertEquals(ilDatabaseCommonTestsDataOutputs::$analyzer_field_info, $analyzer_pdo->getFieldInformation($this->getTableName())); // FSX
 
                // getBestDefinitionAlternative
                $def = $this->db->loadModule(ilDBConstants::MODULE_REVERSE)->getTableFieldDefinition($this->getTableName(), 'comment_mob_id');
                $this->assertEquals(0, $analyzer->getBestDefinitionAlternative($def)); // FSX
 
                // getAutoIncrementField
                $this->assertEquals(false, $analyzer->getAutoIncrementField($this->getTableName()));
 
                // getPrimaryKeyInformation
                $this->assertEquals($this->outputs->getPrimaryInfo($this->getTableName()), $analyzer->getPrimaryKeyInformation($this->getTableName()));
 
                // getIndicesInformation
                if ($this->db->supportsFulltext()) {
                        $this->assertEquals($this->outputs->getIndexInfo(true, $this->getTableName()), $analyzer->getIndicesInformation($this->getTableName()));
                } else {
                        $this->assertEquals($this->outputs->getIndexInfo(false, $this->getTableName()), $analyzer->getIndicesInformation($this->getTableName()));
                }
 
                // getConstraintsInformation
                $this->assertEquals(array(), $analyzer->getConstraintsInformation($this->getTableName())); // TODO
 
                // hasSequence
                $this->assertEquals(59, $analyzer->hasSequence($this->getTableName()));
        }

References getTableName(), and ilDBConstants\MODULE_REVERSE.

Here is the call graph for this function:

◆ testDropSequence()

ilDatabaseImplementationBaseTest::testDropSequence ( )

@depends testConnection

Definition at line 467 of file ilDatabaseImplementationBaseTest.php.

                                           {
                $this->assertTrue($this->db->sequenceExists($this->getTableName()));
                if ($this->db->sequenceExists($this->getTableName())) {
                        $this->db->dropSequence($this->getTableName());
                }
                $this->assertFalse($this->db->sequenceExists($this->getTableName()));
        }

References getTableName().

Here is the call graph for this function:

◆ testDropTable()

ilDatabaseImplementationBaseTest::testDropTable ( )

@depends testConnection

Definition at line 571 of file ilDatabaseImplementationBaseTest.php.

                                        {
                $this->db->dropTable($this->getTableName());
                $this->assertTrue(!$this->db->tableExists($this->getTableName()));
        }

References getTableName().

Here is the call graph for this function:

◆ testIndices()

ilDatabaseImplementationBaseTest::testIndices ( )

@depends testConnection

Definition at line 320 of file ilDatabaseImplementationBaseTest.php.

                                      {
                // Add index
                $this->db->addIndex($this->getTableName(), array( 'init_mob_id' ), self::INDEX_NAME);
                $this->assertTrue($this->db->indexExistsByFields($this->getTableName(), array( 'init_mob_id' )));
 
                // Drop index
                $this->db->dropIndex($this->getTableName(), self::INDEX_NAME);
                $this->assertFalse($this->db->indexExistsByFields($this->getTableName(), array( 'init_mob_id' )));
 
                // FullText
                $this->db->addIndex($this->getTableName(), array( 'address' ), 'i2', true);
                if ($this->db->supportsFulltext()) {
                        $this->assertTrue($this->db->indexExistsByFields($this->getTableName(), array( 'address' )));
                } else {
                        $this->assertFalse($this->db->indexExistsByFields($this->getTableName(), array( 'address' )));
                }
 
                // Drop By Fields
                $this->db->addIndex($this->getTableName(), array( 'elevation' ), 'i3');
                $this->assertTrue($this->db->indexExistsByFields($this->getTableName(), array( 'elevation' )));
 
                $this->db->dropIndexByFields($this->getTableName(), array( 'elevation' ));
                $this->assertFalse($this->db->indexExistsByFields($this->getTableName(), array( 'elevation' )));
        }

References getTableName().

Here is the call graph for this function:

◆ testInsertNative()

ilDatabaseImplementationBaseTest::testInsertNative ( )

@depends testConnection

Definition at line 222 of file ilDatabaseImplementationBaseTest.php.

                                           {
                $values = $this->mock->getInputArray(false, false);
                $id = $values['id'][1];
 
                // PDO
                $this->db->insert($this->getTableName(), $values);
                $this->db->setLimit(1);
                $res_pdo = $this->db->query("SELECT * FROM " . $this->getTableName() . " WHERE id = $id");
                $data_pdo = $this->db->fetchAssoc($res_pdo);
                $this->assertEquals(ilDatabaseCommonTestsDataOutputs::$output_after_native_input, $data_pdo);
        }

References ilDatabaseCommonTestsDataOutputs\$output_after_native_input, and getTableName().

Here is the call graph for this function:

◆ testInsertSQL()

ilDatabaseImplementationBaseTest::testInsertSQL ( )

@depends testConnection

Definition at line 275 of file ilDatabaseImplementationBaseTest.php.

                                        {
                // PDO
                $this->db->manipulate($this->mock->getInsertQuery($this->getTableName()));
                $this->db->setLimit(1, 0);
                $res_pdo = $this->db->query("SELECT * FROM " . $this->getTableName() . " WHERE id = 58");
                $data_pdo = $this->db->fetchObject($res_pdo);
 
                $this->assertEquals((object)ilDatabaseCommonTestsDataOutputs::$insert_sql_output, $data_pdo);
        }

References ilDatabaseCommonTestsDataOutputs\$insert_sql_output, and getTableName().

Here is the call graph for this function:

◆ testInstance()

ilDatabaseImplementationBaseTest::testInstance ( )

Test instance implements ilDBInterface and is ilDBInnoDB.

Definition at line 170 of file ilDatabaseImplementationBaseTest.php.

                                       {
                $this->assertTrue($this->db instanceof ilDBInterface);
        }

◆ testLockTables()

ilDatabaseImplementationBaseTest::testLockTables ( )

@depends testConnection

Definition at line 543 of file ilDatabaseImplementationBaseTest.php.

                                         {
                $locks = array(
                        0 => array( 'name' => 'usr_data', 'type' => ilDBConstants::LOCK_WRITE ),
                        //                      1 => array( 'name' => 'object_data', 'type' => ilDBConstants::LOCK_READ ),
                );
 
                $this->db->lockTables($locks);
                $this->db->manipulate('DELETE FROM usr_data WHERE usr_id = -1');
                $this->db->unlockTables();
        }

References ilDBConstants\LOCK_WRITE.

◆ testModifyTableColumn()

ilDatabaseImplementationBaseTest::testModifyTableColumn ( )

@depends testConnection

Definition at line 515 of file ilDatabaseImplementationBaseTest.php.

                                                {
                $changes = array(
                        "type"    => "text",
                        "length"  => 250,
                        "notnull" => false,
                        'fixed'   => false,
                );
 
                $this->changeGlobal($this->db);
 
                $this->db->modifyTableColumn($this->getTableName(), 'comment_mob_id_altered', $changes);
                if (in_array($this->type, array( ilDBConstants::TYPE_PDO_POSTGRE, ilDBConstants::TYPE_POSTGRES ))) {
                        return; // SHOW CREATE TABLE CURRENTLY NOT SUPPORTED IN POSTGRES
                }
                $res = $this->db->query('SHOW CREATE TABLE ' . $this->getTableName());
                $data = $this->db->fetchAssoc($res);
 
                $data = array_change_key_case($data, CASE_LOWER);
 
                $this->changeBack();
 
                $this->assertEquals($this->normalizeSQL($this->mock->getTableCreateSQLAfterAlter($this->getTableName(), $this->db->getStorageEngine(), $this->db->supportsFulltext())), $this->normalizeSQL($data[self::CREATE_TABLE_ARRAY_KEY]));
        }

References $data, $res, changeBack(), changeGlobal(), getTableName(), normalizeSQL(), ilDBConstants\TYPE_PDO_POSTGRE, and ilDBConstants\TYPE_POSTGRES.

Here is the call graph for this function:

◆ testQueryUtils()

ilDatabaseImplementationBaseTest::testQueryUtils ( )

Definition at line 235 of file ilDatabaseImplementationBaseTest.php.

                                         {
                $this->assertEquals($this->mock->getLike(), $this->db->like('column', 'text', 22));
 
                $this->assertEquals($this->mock->getNow(), $this->db->now());
 
                $this->assertEquals($this->mock->getLocate(), $this->db->locate('needle', 'mystring', 5));
 
                $this->assertEquals($this->mock->getConcat(false), $this->db->concat(array( 'one', 'two', 'three' ), false));
 
                $this->assertEquals($this->mock->getConcat(true), $this->db->concat(array( 'one', 'two', 'three' ), true));
        }

◆ testRenameTableColumn()

ilDatabaseImplementationBaseTest::testRenameTableColumn ( )

@depends testConnection

Definition at line 495 of file ilDatabaseImplementationBaseTest.php.

                                                {
                $this->changeGlobal($this->db);
 
                $this->db->renameTableColumn($this->getTableName(), 'comment_mob_id', 'comment_mob_id_altered');
                if (in_array($this->type, array( ilDBConstants::TYPE_PDO_POSTGRE, ilDBConstants::TYPE_POSTGRES ))) {
                        return; // SHOW CREATE TABLE CURRENTLY NOT SUPPORTED IN POSTGRES
                }
                $res = $this->db->query('SHOW CREATE TABLE ' . $this->getTableName());
                $data = $this->db->fetchAssoc($res);
                $data = array_change_key_case($data, CASE_LOWER);
 
                $this->assertEquals($this->normalizeSQL($this->mock->getTableCreateSQLAfterRename($this->getTableName(), $this->db->getStorageEngine(), $this->db->supportsFulltext())), $this->normalizeSQL($data[self::CREATE_TABLE_ARRAY_KEY]));
 
                $this->changeBack();
        }

References $data, $res, changeBack(), changeGlobal(), getTableName(), normalizeSQL(), ilDBConstants\TYPE_PDO_POSTGRE, and ilDBConstants\TYPE_POSTGRES.

Here is the call graph for this function:

◆ testSelectUsrData()

ilDatabaseImplementationBaseTest::testSelectUsrData ( )

Exceptions

ilDatabaseException @depends testConnection

Definition at line 290 of file ilDatabaseImplementationBaseTest.php.

                                            {
                $output = (object)ilDatabaseCommonTestsDataOutputs::$select_usr_data_output;
 
                $query = 'SELECT usr_id, login, is_self_registered FROM usr_data WHERE usr_id = 6';
                // PDO
                $this->db->setLimit(1, 0);
                $result = $this->db->query($query);
                $data = $this->db->fetchObject($result);
                $this->assertEquals($output, $data);
 
                $result = $this->db->queryF('SELECT usr_id, login, is_self_registered FROM usr_data WHERE usr_id = %s', array( ilDBPdoFieldDefinition::T_INTEGER ), array( 6 ));
                $this->db->setLimit(1, 0);
                $data = $this->db->fetchObject($result);
                $this->assertEquals($output, $data);
 
                $query = 'SELECT usr_id, login, is_self_registered FROM usr_data WHERE ' . $this->db->in('usr_id', array( 6, 13 ), false, 'integer');
                $this->db->setLimit(2, 0);
                $result = $this->db->query($query);
                $data = $this->db->fetchAll($result);
                foreach (ilDatabaseCommonTestsDataOutputs::$select_usr_data_2_output as $item) {
                        $this->assertTrue(in_array($item, $data));
                }
 
                $this->assertEquals(2, $this->db->numRows($result));
        }

References $data, $output, $query, $result, ilDatabaseCommonTestsDataOutputs\$select_usr_data_2_output, ilDatabaseCommonTestsDataOutputs\$select_usr_data_output, and ilDBPdoFieldDefinition\T_INTEGER.

◆ testSequences()

ilDatabaseImplementationBaseTest::testSequences ( )

@depends testConnection

Definition at line 363 of file ilDatabaseImplementationBaseTest.php.

                                        {
                if ($this->db->sequenceExists($this->getTableName())) {
                        $this->db->dropSequence($this->getTableName());
                }
                $this->db->createSequence($this->getTableName(), 10);
                $this->assertEquals(10, $this->db->nextId($this->getTableName()));
                $this->assertEquals(11, $this->db->nextId($this->getTableName()));
        }

References getTableName().

Here is the call graph for this function:

◆ testTableColums()

ilDatabaseImplementationBaseTest::testTableColums ( )

@depends testConnection

Definition at line 349 of file ilDatabaseImplementationBaseTest.php.

                                          {
                $this->assertTrue($this->db->tableColumnExists($this->getTableName(), 'init_mob_id'));
 
                $this->db->addTableColumn($this->getTableName(), "export", array( "type" => "text", "length" => 1024 ));
                $this->assertTrue($this->db->tableColumnExists($this->getTableName(), 'export'));
 
                $this->db->dropTableColumn($this->getTableName(), "export");
                $this->assertFalse($this->db->tableColumnExists($this->getTableName(), 'export'));
        }

References getTableName().

Here is the call graph for this function:

◆ testTransactions()

ilDatabaseImplementationBaseTest::testTransactions ( )

@depends testConnection

Definition at line 558 of file ilDatabaseImplementationBaseTest.php.

                                           {
                // PDO
                //              $this->db->beginTransaction();
                //              $this->db->insert($this->getTableName(), $this->mock->getInputArrayForTransaction());
                //              $this->db->rollback();
                //              $st = $this->db->query('SELECT * FROM ' . $this->getTableName() . ' WHERE id = ' . $this->db->quote(123456, 'integer'));
                //              $this->assertEquals(0, $this->db->numRows($st));
        }

◆ testUpdateNative()

ilDatabaseImplementationBaseTest::testUpdateNative ( )

@depends testConnection

Definition at line 251 of file ilDatabaseImplementationBaseTest.php.

                                           {
                // With / without clob
                $with_clob = $this->mock->getInputArray(2222, true);
                $without_clob = $this->mock->getInputArray(2222, true, false);
                $id = $with_clob['id'][1];
 
                // PDO
                $this->db->update($this->getTableName(), $with_clob, array( 'id' => array( 'integer', $id ) ));
                $this->db->setLimit(1, 0);
                $res_pdo = $this->db->query("SELECT * FROM " . $this->getTableName() . " WHERE id = $id ");
                $data_pdo = $this->db->fetchAssoc($res_pdo);
                $this->assertEquals(ilDatabaseCommonTestsDataOutputs::$output_after_native_update, $data_pdo);
 
                $this->db->update($this->getTableName(), $without_clob, array( 'id' => array( 'integer', $id ) ));
                $this->db->setLimit(1, 0);
                $res_pdo = $this->db->query("SELECT * FROM " . $this->getTableName() . " WHERE id = $id ");
                $data_pdo = $this->db->fetchAssoc($res_pdo);
                $this->assertEquals(ilDatabaseCommonTestsDataOutputs::$output_after_native_update, $data_pdo);
        }

References ilDatabaseCommonTestsDataOutputs\$output_after_native_update, and getTableName().

Here is the call graph for this function:

Field Documentation

◆ $backupGlobals

ilDatabaseImplementationBaseTest::$backupGlobals = false

protected

Definition at line 42 of file ilDatabaseImplementationBaseTest.php.

◆ $db

ilDatabaseImplementationBaseTest::$db

protected

Definition at line 46 of file ilDatabaseImplementationBaseTest.php.

Referenced by setUp().

◆ $error_reporting_backup

ilDatabaseImplementationBaseTest::$error_reporting_backup = 0

protected

Definition at line 38 of file ilDatabaseImplementationBaseTest.php.

◆ $ildb_backup

ilDatabaseImplementationBaseTest::$ildb_backup

protected

Definition at line 58 of file ilDatabaseImplementationBaseTest.php.

Referenced by changeBack().

◆ $ini_file

ilDatabaseImplementationBaseTest::$ini_file = '/var/www/ilias/data/trunk/client.ini.php'

protected

Definition at line 66 of file ilDatabaseImplementationBaseTest.php.

Referenced by getIniFile().

◆ $mock

ilDatabaseImplementationBaseTest::$mock

protected

Definition at line 50 of file ilDatabaseImplementationBaseTest.php.

◆ $outputs

ilDatabaseImplementationBaseTest::$outputs

protected

Definition at line 54 of file ilDatabaseImplementationBaseTest.php.

◆ $set_up

ilDatabaseImplementationBaseTest::$set_up = false

protected

Definition at line 70 of file ilDatabaseImplementationBaseTest.php.

◆ $type

ilDatabaseImplementationBaseTest::$type = ''

protected

Definition at line 62 of file ilDatabaseImplementationBaseTest.php.

◆ CREATE_TABLE_ARRAY_KEY

const ilDatabaseImplementationBaseTest::CREATE_TABLE_ARRAY_KEY = 'create table'

Definition at line 34 of file ilDatabaseImplementationBaseTest.php.

◆ INDEX_NAME

const ilDatabaseImplementationBaseTest::INDEX_NAME = 'i1'

Definition at line 32 of file ilDatabaseImplementationBaseTest.php.

◆ TABLE_NAME

const ilDatabaseImplementationBaseTest::TABLE_NAME = 'il_ut_en'

Definition at line 33 of file ilDatabaseImplementationBaseTest.php.

The documentation for this class was generated from the following file:

Services/Database/test/Implementations/ilDatabaseImplementationBaseTest.php

Public Member Functions

Data Fields

Protected Member Functions

Protected Attributes

Detailed Description

Member Function Documentation

◆ changeBack()

◆ changeGlobal()

◆ connect()

◆ getDBInstance()

◆ getIniFile()

◆ getTableName()

◆ normalizeSQL()

◆ normalizetableName()

◆ setUp()

◆ tearDown()

◆ testChangeTableName()

◆ testConnection()

◆ testConstraints()

◆ testCreateDatabase()

◆ testDBAnalyser()

◆ testDropSequence()

◆ testDropTable()

◆ testIndices()

◆ testInsertNative()

◆ testInsertSQL()

◆ testInstance()

◆ testLockTables()

◆ testModifyTableColumn()

◆ testQueryUtils()

◆ testRenameTableColumn()

◆ testSelectUsrData()

◆ testSequences()

◆ testTableColums()

◆ testTransactions()

◆ testUpdateNative()

Field Documentation

◆ $backupGlobals

◆ $db

◆ $error_reporting_backup

◆ $ildb_backup

◆ $ini_file

◆ $mock

◆ $outputs

◆ $set_up

◆ $type

◆ CREATE_TABLE_ARRAY_KEY

◆ INDEX_NAME

◆ TABLE_NAME