ilDatabaseImplementationBaseTest Class Reference

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 613 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 605 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 127 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 147 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 624 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 634 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(), getDBInstance(), ilDBConstants\TYPE_PDO_POSTGRE, and ilDBConstants\TYPE_POSTGRES.

    {
        if ($this->set_up) {
            return;
        }
        //              echo phpversion() . "\n";
        $this->error_reporting_backup = error_reporting();

        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 153 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 500 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 180 of file ilDatabaseImplementationBaseTest.php.

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

    {
        $this->assertTrue($this->connect($this->getDBInstance()));
    }

Here is the call graph for this function:

testConstraints()

ilDatabaseImplementationBaseTest::testConstraints

(

)

Definition at line 492 of file ilDatabaseImplementationBaseTest.php.

    {
    }

testCreateDatabase()

ilDatabaseImplementationBaseTest::testCreateDatabase

(

)

testConnection

Definition at line 200 of file ilDatabaseImplementationBaseTest.php.

References $data, $res, 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 446 of file ilDatabaseImplementationBaseTest.php.

References $def, 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 482 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 592 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 329 of file ilDatabaseImplementationBaseTest.php.

References 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 226 of file ilDatabaseImplementationBaseTest.php.

References $id, ilDatabaseCommonTestsDataOutputs\$output_after_native_input, $values, 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 282 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 174 of file ilDatabaseImplementationBaseTest.php.

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

testLockTables()

ilDatabaseImplementationBaseTest::testLockTables

(

)

testConnection

Definition at line 562 of file ilDatabaseImplementationBaseTest.php.

References 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 533 of file ilDatabaseImplementationBaseTest.php.

References $data, $res, 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 240 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

(

)

testConnection

Definition at line 512 of file ilDatabaseImplementationBaseTest.php.

References $data, $res, 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 298 of file ilDatabaseImplementationBaseTest.php.

References $data, Sabre\VObject\$output, $query, $result, ilDatabaseCommonTestsDataOutputs\$select_usr_data_2_output, ilDatabaseCommonTestsDataOutputs\$select_usr_data_output, 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 374 of file ilDatabaseImplementationBaseTest.php.

References ilDatabaseCommonTestsDataOutputs\$table_constraint_definition_output, ilDatabaseCommonTestsDataOutputs\$table_index_definition_output, 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 359 of file ilDatabaseImplementationBaseTest.php.

References 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 578 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 257 of file ilDatabaseImplementationBaseTest.php.

References $id, ilDatabaseCommonTestsDataOutputs\$output_after_native_update, 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