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 618 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 610 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 128 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 118 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 148 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 629 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 639 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 154 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 505 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 181 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 497 of file ilDatabaseImplementationBaseTest.php.

498 {

499 }

◆ testCreateDatabase()

ilDatabaseImplementationBaseTest::testCreateDatabase ( )

@depends testConnection

Definition at line 205 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 451 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 $def, getTableName(), and ilDBConstants\MODULE_REVERSE.

Here is the call graph for this function:

◆ testDropSequence()

ilDatabaseImplementationBaseTest::testDropSequence ( )

@depends testConnection

Definition at line 487 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 597 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 334 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 231 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 $id, ilDatabaseCommonTestsDataOutputs\$output_after_native_input, and getTableName().

Here is the call graph for this function:

◆ testInsertSQL()

ilDatabaseImplementationBaseTest::testInsertSQL ( )

@depends testConnection

Definition at line 287 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 175 of file ilDatabaseImplementationBaseTest.php.

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

◆ testLockTables()

ilDatabaseImplementationBaseTest::testLockTables ( )

@depends testConnection

Definition at line 567 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 538 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 245 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 517 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 303 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 379 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 364 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 583 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 262 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 $id, 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