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

    {
    }

testCreateDatabase()

ilDatabaseImplementationBaseTest::testCreateDatabase

(

)

testConnection

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

References $def, 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 487 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 597 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 334 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 231 of file ilDatabaseImplementationBaseTest.php.

References $id, 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 287 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 175 of file ilDatabaseImplementationBaseTest.php.

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

testLockTables()

ilDatabaseImplementationBaseTest::testLockTables

(

)

testConnection

Definition at line 567 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 538 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 245 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 517 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 303 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 379 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 364 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 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

(

)

testConnection

Definition at line 262 of file ilDatabaseImplementationBaseTest.php.

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