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 ()
	testConnection More...

	testInsertNative ()
	testConnection More...

	testQueryUtils ()

	testUpdateNative ()
	testConnection More...

	testInsertSQL ()
	testConnection More...

	testSelectUsrData ()

	testIndices ()
	testConnection More...

	testTableColums ()
	testConnection More...

	testSequences ()
	testConnection More...

	testDBAnalyser ()
	testConnection More...

	testDropSequence ()
	testConnection More...

	testConstraints ()

	testChangeTableName ()
	testConnection More...

	testRenameTableColumn ()
	testConnection More...

	testModifyTableColumn ()
	testConnection More...

	testLockTables ()
	testConnection More...

	testTransactions ()
	testConnection More...

	testDropTable ()
	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.

References $ilDB, and $ildb_backup.

Referenced by testModifyTableColumn(), and testRenameTableColumn().

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

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.

References $ilDB.

Referenced by testModifyTableColumn(), and testRenameTableColumn().

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

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.

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

Referenced by setUp(), and testConnection().

                                                                                              {
                 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;
         }

Here is the call graph for this function:

Here is the caller graph for this function:

◆ getDBInstance()

ilDatabaseImplementationBaseTest::getDBInstance ( )

abstractprotected

Returns

Exceptions

Referenced by setUp(), tearDown(), and testConnection().

Here is the caller graph for this function:

◆ getIniFile()

ilDatabaseImplementationBaseTest::getIniFile ( )

protected

Returns: string

Definition at line 117 of file ilDatabaseImplementationBaseTest.php.

References $ini_file.

Referenced by connect().

                                         {
                 return $this->ini_file;
         }

Here is the caller graph for this function:

◆ getTableName()

ilDatabaseImplementationBaseTest::getTableName ( )

protected

Returns: string

Definition at line 145 of file ilDatabaseImplementationBaseTest.php.

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

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

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.

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

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

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.

References getTableName().

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

Here is the call graph for this function:

◆ setUp()

ilDatabaseImplementationBaseTest::setUp ( )

protected

Definition at line 73 of file ilDatabaseImplementationBaseTest.php.

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

                                    {
                 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;
         }

Here is the call graph for this function:

◆ tearDown()

ilDatabaseImplementationBaseTest::tearDown ( )

protected

Definition at line 150 of file ilDatabaseImplementationBaseTest.php.

References getDBInstance().

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

Here is the call graph for this function:

◆ testChangeTableName()

ilDatabaseImplementationBaseTest::testChangeTableName ( )

testConnection

Definition at line 484 of file ilDatabaseImplementationBaseTest.php.

References getTableName().

                                               {
                 $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());
         }

Here is the call graph for this function:

◆ testConnection()

ilDatabaseImplementationBaseTest::testConnection ( )

Definition at line 175 of file ilDatabaseImplementationBaseTest.php.

References $query, array, connect(), getDBInstance(), getTableName(), ilDBConstants\MODULE_MANAGER, and normalizeSQL().

                                          {
                 //              $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());
                 }
         }

Here is the call graph for this function:

◆ testConstraints()

ilDatabaseImplementationBaseTest::testConstraints ( )

Definition at line 476 of file ilDatabaseImplementationBaseTest.php.

                                           {
 
         }

◆ testCreateDatabase()

ilDatabaseImplementationBaseTest::testCreateDatabase ( )

testConnection

Definition at line 197 of file ilDatabaseImplementationBaseTest.php.

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

                                              {
                 $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);
         }

Here is the call graph for this function:

◆ testDBAnalyser()

ilDatabaseImplementationBaseTest::testDBAnalyser ( )

testConnection

Definition at line 432 of file ilDatabaseImplementationBaseTest.php.

References array, getTableName(), and ilDBConstants\MODULE_REVERSE.

                                          {
                 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()));
         }

Here is the call graph for this function:

◆ testDropSequence()

ilDatabaseImplementationBaseTest::testDropSequence ( )

testConnection

Definition at line 467 of file ilDatabaseImplementationBaseTest.php.

References getTableName().

                                            {
                 $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()));
         }

Here is the call graph for this function:

◆ testDropTable()

ilDatabaseImplementationBaseTest::testDropTable ( )

testConnection

Definition at line 571 of file ilDatabaseImplementationBaseTest.php.

References getTableName().

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

Here is the call graph for this function:

◆ testIndices()

ilDatabaseImplementationBaseTest::testIndices ( )

testConnection

Definition at line 320 of file ilDatabaseImplementationBaseTest.php.

References array, and getTableName().

                                       {
                 // 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' )));
         }

Here is the call graph for this function:

◆ testInsertNative()

ilDatabaseImplementationBaseTest::testInsertNative ( )

testConnection

Definition at line 222 of file ilDatabaseImplementationBaseTest.php.

References ilDatabaseCommonTestsDataOutputs\$output_after_native_input, and getTableName().

                                            {
                 $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);
         }

Here is the call graph for this function:

◆ testInsertSQL()

ilDatabaseImplementationBaseTest::testInsertSQL ( )

testConnection

Definition at line 275 of file ilDatabaseImplementationBaseTest.php.

References ilDatabaseCommonTestsDataOutputs\$insert_sql_output, and getTableName().

                                         {
                 // 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);
         }

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 ( )

testConnection

Definition at line 543 of file ilDatabaseImplementationBaseTest.php.

References array, and ilDBConstants\LOCK_WRITE.

                                          {
                 $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();
         }

◆ testModifyTableColumn()

ilDatabaseImplementationBaseTest::testModifyTableColumn ( )

testConnection

Definition at line 515 of file ilDatabaseImplementationBaseTest.php.

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

                                                 {
                 $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]));
         }

Here is the call graph for this function:

◆ testQueryUtils()

ilDatabaseImplementationBaseTest::testQueryUtils ( )

Definition at line 235 of file ilDatabaseImplementationBaseTest.php.

References array.

                                          {
                 $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 ( )

testConnection

Definition at line 495 of file ilDatabaseImplementationBaseTest.php.

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

                                                 {
                 $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();
         }

Here is the call graph for this function:

◆ testSelectUsrData()

ilDatabaseImplementationBaseTest::testSelectUsrData ( )

Exceptions

Definition at line 290 of file ilDatabaseImplementationBaseTest.php.

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

                                             {
                 $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));
         }

◆ testSequences()

ilDatabaseImplementationBaseTest::testSequences ( )

testConnection

Definition at line 363 of file ilDatabaseImplementationBaseTest.php.

References ilDatabaseCommonTestsDataOutputs\$table_constraint_definition_output, ilDatabaseCommonTestsDataOutputs\$table_index_definition_output, array, getTableName(), ilDBConstants\MODULE_MANAGER, and ilDBConstants\MODULE_REVERSE.

                                         {
                 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()));
         }

Here is the call graph for this function:

◆ testTableColums()

ilDatabaseImplementationBaseTest::testTableColums ( )

testConnection

Definition at line 349 of file ilDatabaseImplementationBaseTest.php.

References array, and getTableName().

                                           {
                 $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'));
         }

Here is the call graph for this function:

◆ testTransactions()

ilDatabaseImplementationBaseTest::testTransactions ( )

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 ( )

testConnection

Definition at line 251 of file ilDatabaseImplementationBaseTest.php.

References ilDatabaseCommonTestsDataOutputs\$output_after_native_update, array, and getTableName().

                                            {
                 // 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);
         }

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