ilDatabaseAtomRunTest Class Reference

TestCase for the ilDatabaseAtomBaseTest. More...

Inheritance diagram for ilDatabaseAtomRunTest:

Collaboration diagram for ilDatabaseAtomRunTest:

Public Member Functions
	tearDown ()
	testConnection ()
	setupTable ()
	testTableExists ()
	testWriteWithTransactions ()
	testWriteWithLocks ()
	testWriteWithLocksAndAlias ()
	testWriteWithMultipleLocksAndAlias ()
	testWriteWithMultipleLocksWithAndWithoutAlias ()
	testNoTables ()
	testNoQueries ()
	testUpdateDuringTransaction ()
	testUpdateDuringLock ()

Protected Member Functions
	setUp ()
	getInsertQueryCallable ()
	getTableLocksForDbInterface ()
	getResultFromDB ()
	getExpectedResult ()

Protected Attributes
	$backupGlobals = false
	$ilDBInterfaceGalera
	$ilDBInterfaceGaleraSecond
	$ilDBInterfaceInnoDB
	$ilDBInterfaceInnoDBSecond

Detailed Description

TestCase for the ilDatabaseAtomBaseTest.

Author

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

Version

1.0.0

needsInstalledILIAS

Definition at line 34 of file ilDatabaseAtomRunTest.php.

Member Function Documentation

getExpectedResult()

ilDatabaseAtomRunTest::getExpectedResult ( )

protected

Returns

array

Definition at line 328 of file ilDatabaseAtomRunTest.php.

Referenced by testWriteWithLocks(), testWriteWithLocksAndAlias(), testWriteWithMultipleLocksAndAlias(), testWriteWithMultipleLocksWithAndWithoutAlias(), and testWriteWithTransactions().

    {
        return array(
            0 => array(
                'id' => '1',
                'is_online' => '1',
            ),
            1 => array(
                'id' => '2',
                'is_online' => '0',
            ),
        );
    }

Here is the caller graph for this function:

getInsertQueryCallable()

ilDatabaseAtomRunTest::getInsertQueryCallable ( )

protected

Returns

Definition at line 276 of file ilDatabaseAtomRunTest.php.

References $ilDB, and $query.

Referenced by testNoTables(), testWriteWithLocks(), testWriteWithLocksAndAlias(), testWriteWithMultipleLocksAndAlias(), testWriteWithMultipleLocksWithAndWithoutAlias(), and testWriteWithTransactions().

    {
        $query = function (ilDBInterface $ilDB) {
            $ilDB->insert('il_db_tests_atom', array(
                'id' => array( 'integer', $ilDB->nextId('il_db_tests_atom') ),
                'is_online' => array( 'integer', 1 ),
            ));
            $ilDB->insert('il_db_tests_atom', array(
                'id' => array( 'integer', $ilDB->nextId('il_db_tests_atom') ),
                'is_online' => array( 'integer', 0 ),
            ));
        };

        return $query;
    }

Here is the caller graph for this function:

getResultFromDB()

ilDatabaseAtomRunTest::getResultFromDB ( )

protected

Returns

array

Definition at line 313 of file ilDatabaseAtomRunTest.php.

References $d, $res, and $results.

Referenced by testWriteWithLocks(), testWriteWithLocksAndAlias(), testWriteWithMultipleLocksAndAlias(), testWriteWithMultipleLocksWithAndWithoutAlias(), and testWriteWithTransactions().

    {
        $res = $this->ilDBInterfaceGalera->query('SELECT * FROM il_db_tests_atom');
        $results = array();
        while ($d = $this->ilDBInterfaceGalera->fetchAssoc($res)) {
            $results[] = $d;
        }

        return $results;
    }

Here is the caller graph for this function:

getTableLocksForDbInterface()

ilDatabaseAtomRunTest::getTableLocksForDbInterface ( )

protected

Returns

array

Definition at line 296 of file ilDatabaseAtomRunTest.php.

References ilAtomQuery\LOCK_WRITE.

    {
        $tables = array(
            array(
                'name' => 'il_db_tests_atom',
                'type' => ilAtomQuery::LOCK_WRITE,
                'sequence' => true,
            ),
        );

        return $tables;
    }

setUp()

ilDatabaseAtomRunTest::setUp ( )

protected

Definition at line 59 of file ilDatabaseAtomRunTest.php.

References ilDBWrapperFactory\getWrapper(), setupTable(), ilDBConstants\TYPE_GALERA, and ilDBConstants\TYPE_PDO_MYSQL_INNODB.

                               : void
    {
        ilUnitUtil::performInitialisation();

        global $ilClientIniFile;
        $this->ilDBInterfaceGalera = ilDBWrapperFactory::getWrapper(ilDBConstants::TYPE_GALERA);
        $this->ilDBInterfaceGalera->initFromIniFile($ilClientIniFile);
        $this->ilDBInterfaceGalera->connect();

        $this->ilDBInterfaceGaleraSecond = ilDBWrapperFactory::getWrapper(ilDBConstants::TYPE_GALERA);
        $this->ilDBInterfaceGaleraSecond->initFromIniFile($ilClientIniFile);
        $this->ilDBInterfaceGaleraSecond->connect();

        $this->ilDBInterfaceInnoDB = ilDBWrapperFactory::getWrapper(ilDBConstants::TYPE_PDO_MYSQL_INNODB);
        $this->ilDBInterfaceInnoDB->initFromIniFile($ilClientIniFile);
        $this->ilDBInterfaceInnoDB->connect();

        $this->ilDBInterfaceInnoDBSecond = ilDBWrapperFactory::getWrapper(ilDBConstants::TYPE_PDO_MYSQL_INNODB);
        $this->ilDBInterfaceInnoDBSecond->initFromIniFile($ilClientIniFile);
        $this->ilDBInterfaceInnoDBSecond->connect();

        $this->setupTable();
    }

Here is the call graph for this function:

setupTable()

ilDatabaseAtomRunTest::setupTable

(

)

Definition at line 99 of file ilDatabaseAtomRunTest.php.

Referenced by setUp().

    {
        if ($this->ilDBInterfaceGalera->sequenceExists('il_db_tests_atom')) {
            $this->ilDBInterfaceGalera->dropSequence('il_db_tests_atom');
        }
        $this->ilDBInterfaceGalera->createTable('il_db_tests_atom', $fields = array(
            'id' => array(
                'type' => 'integer',
                'length' => 4,
                'notnull' => true,
            ),
            'is_online' => array(
                'type' => 'integer',
                'length' => 1,
                'notnull' => false,
            ),
        ), true);
        $this->ilDBInterfaceGalera->addPrimaryKey('il_db_tests_atom', array( 'id' ));
        $this->ilDBInterfaceGalera->createSequence('il_db_tests_atom');
    }

Here is the caller graph for this function:

tearDown()

ilDatabaseAtomRunTest::tearDown

(

)

Definition at line 84 of file ilDatabaseAtomRunTest.php.

                               : void
    {
        $this->ilDBInterfaceGalera->dropSequence('il_db_tests_atom');
        $this->ilDBInterfaceGalera->dropTable('il_db_tests_atom');
    }

testConnection()

ilDatabaseAtomRunTest::testConnection

(

)

Definition at line 91 of file ilDatabaseAtomRunTest.php.

    {
        $this->assertTrue($this->ilDBInterfaceGalera->connect(true));
        $this->assertTrue($this->ilDBInterfaceGaleraSecond->connect(true));
        $this->assertTrue($this->ilDBInterfaceInnoDB->connect(true));
    }

testNoQueries()

ilDatabaseAtomRunTest::testNoQueries

(

)

Definition at line 199 of file ilDatabaseAtomRunTest.php.

    {
        $this->setExpectedException('ilDatabaseException');
        $ilAtomQuery = $this->ilDBInterfaceInnoDB->buildAtomQuery();
        $ilAtomQuery->addTableLock('il_db_tests_atom');

        $ilAtomQuery->run();
    }

testNoTables()

ilDatabaseAtomRunTest::testNoTables

(

)

Definition at line 189 of file ilDatabaseAtomRunTest.php.

References getInsertQueryCallable().

    {
        $this->setExpectedException('ilDatabaseException');
        $ilAtomQuery = $this->ilDBInterfaceInnoDB->buildAtomQuery();
        $ilAtomQuery->addQueryCallable($this->getInsertQueryCallable());

        $ilAtomQuery->run();
    }

Here is the call graph for this function:

testTableExists()

ilDatabaseAtomRunTest::testTableExists

(

)

Definition at line 121 of file ilDatabaseAtomRunTest.php.

    {
        $this->assertTrue($this->ilDBInterfaceGalera->tableExists('il_db_tests_atom'));
    }

testUpdateDuringLock()

ilDatabaseAtomRunTest::testUpdateDuringLock

(

)

Definition at line 239 of file ilDatabaseAtomRunTest.php.

References $d, $query, $res, and ilAtomQuery\LOCK_WRITE.

    {
        $this->ilDBInterfaceInnoDB->insert('il_db_tests_atom', array(
            'id' => array( 'integer', $this->ilDBInterfaceInnoDB->nextId('il_db_tests_atom') ),
            'is_online' => array( 'integer', 1 ),
        ));
        // Start a Transaction with one instance and update the same entry as another instance
        $this->ilDBInterfaceInnoDB->lockTables(array( array( 'name' => 'il_db_tests_atom', 'type' => ilAtomQuery::LOCK_WRITE ) ));
        $this->ilDBInterfaceInnoDB->update('il_db_tests_atom', array(
            'is_online' => array( 'integer', 5 ),
        ), array( 'id' => array( 'integer', 1 ) ));

        // Update the same entry with another instance (which currently fails due to missing multi-thread in PHP)
        //              $this->ilDBInterfaceInnoDBSecond->update('il_db_tests_atom', array(
        //                      'is_online' => array( 'integer', 6 ),
        //              ), array( 'id' => array( 'integer', 1 ) ), true);

        // Unlock Tables
        $this->ilDBInterfaceInnoDB->unlockTables();

        // Check
        $query = 'SELECT is_online FROM il_db_tests_atom WHERE id = ' . $this->ilDBInterfaceInnoDB->quote(1, 'integer');
        $res = $this->ilDBInterfaceInnoDB->query($query);
        $d = $this->ilDBInterfaceInnoDB->fetchAssoc($res);

        $this->assertEquals(5, $d['is_online']);
    }

testUpdateDuringTransaction()

ilDatabaseAtomRunTest::testUpdateDuringTransaction

(

)

Definition at line 209 of file ilDatabaseAtomRunTest.php.

References $d, $query, and $res.

    {
        $this->ilDBInterfaceGalera->insert('il_db_tests_atom', array(
            'id' => array( 'integer', $this->ilDBInterfaceGalera->nextId('il_db_tests_atom') ),
            'is_online' => array( 'integer', 1 ),
        ));

        // Start a Transaction with one instance and update the same entry as another instance
        $this->ilDBInterfaceGalera->beginTransaction();
        $this->ilDBInterfaceGalera->update('il_db_tests_atom', array(
            'is_online' => array( 'integer', 5 ),
        ), array( 'id' => array( 'integer', 1 ) ));

        // Update the same entry with another instance (which currently fails due to missing multi-thread in PHP)
        //              $this->ilDBInterfaceGaleraSecond->update('il_db_tests_atom', array(
        //                      'is_online' => array( 'integer', 6 ),
        //              ), array( 'id' => array( 'integer', 1 ) ), true);

        // Commit the other
        $this->ilDBInterfaceGalera->commit();

        // Check
        $query = 'SELECT is_online FROM il_db_tests_atom WHERE id = ' . $this->ilDBInterfaceGalera->quote(1, 'integer');
        $res = $this->ilDBInterfaceGalera->query($query);
        $d = $this->ilDBInterfaceGalera->fetchAssoc($res);

        $this->assertEquals(5, $d['is_online']);
    }

testWriteWithLocks()

ilDatabaseAtomRunTest::testWriteWithLocks

(

)

Definition at line 139 of file ilDatabaseAtomRunTest.php.

References getExpectedResult(), getInsertQueryCallable(), and getResultFromDB().

    {
        $ilAtomQuery = $this->ilDBInterfaceInnoDB->buildAtomQuery();
        $ilAtomQuery->addTableLock('il_db_tests_atom')->lockSequence(true);
        $ilAtomQuery->addQueryCallable($this->getInsertQueryCallable());

        $ilAtomQuery->run();

        $this->assertEquals($this->getExpectedResult(), $this->getResultFromDB());
    }

Here is the call graph for this function:

testWriteWithLocksAndAlias()

ilDatabaseAtomRunTest::testWriteWithLocksAndAlias

(

)

Definition at line 151 of file ilDatabaseAtomRunTest.php.

References getExpectedResult(), getInsertQueryCallable(), and getResultFromDB().

    {
        $ilAtomQuery = $this->ilDBInterfaceInnoDB->buildAtomQuery();
        $ilAtomQuery->addTableLock('il_db_tests_atom')->lockSequence(true)->aliasName('my_alias');
        $ilAtomQuery->addQueryCallable($this->getInsertQueryCallable());

        $ilAtomQuery->run();

        $this->assertEquals($this->getExpectedResult(), $this->getResultFromDB());
    }

Here is the call graph for this function:

testWriteWithMultipleLocksAndAlias()

ilDatabaseAtomRunTest::testWriteWithMultipleLocksAndAlias

(

)

Definition at line 163 of file ilDatabaseAtomRunTest.php.

References getExpectedResult(), getInsertQueryCallable(), and getResultFromDB().

    {
        $ilAtomQuery = $this->ilDBInterfaceInnoDB->buildAtomQuery();
        $ilAtomQuery->addTableLock('il_db_tests_atom')->lockSequence(true)->aliasName('my_alias');
        $ilAtomQuery->addTableLock('il_db_tests_atom')->lockSequence(true)->aliasName('my_second_alias');
        $ilAtomQuery->addQueryCallable($this->getInsertQueryCallable());

        $ilAtomQuery->run();

        $this->assertEquals($this->getExpectedResult(), $this->getResultFromDB());
    }

Here is the call graph for this function:

testWriteWithMultipleLocksWithAndWithoutAlias()

ilDatabaseAtomRunTest::testWriteWithMultipleLocksWithAndWithoutAlias

(

)

Definition at line 176 of file ilDatabaseAtomRunTest.php.

References getExpectedResult(), getInsertQueryCallable(), and getResultFromDB().

    {
        $ilAtomQuery = $this->ilDBInterfaceInnoDB->buildAtomQuery();
        $ilAtomQuery->addTableLock('il_db_tests_atom')->lockSequence(true);
        $ilAtomQuery->addTableLock('il_db_tests_atom')->lockSequence(true)->aliasName('my_alias');
        $ilAtomQuery->addQueryCallable($this->getInsertQueryCallable());

        $ilAtomQuery->run();

        $this->assertEquals($this->getExpectedResult(), $this->getResultFromDB());
    }

Here is the call graph for this function:

testWriteWithTransactions()

ilDatabaseAtomRunTest::testWriteWithTransactions

(

)

Definition at line 127 of file ilDatabaseAtomRunTest.php.

References getExpectedResult(), getInsertQueryCallable(), and getResultFromDB().

    {
        $ilAtomQuery = $this->ilDBInterfaceGalera->buildAtomQuery();
        $ilAtomQuery->addTableLock('il_db_tests_atom')->lockSequence(true);
        $ilAtomQuery->addQueryCallable($this->getInsertQueryCallable());

        $ilAtomQuery->run();

        $this->assertEquals($this->getExpectedResult(), $this->getResultFromDB());
    }

Here is the call graph for this function:

Field Documentation

$backupGlobals

ilDatabaseAtomRunTest::$backupGlobals = false

protected

Definition at line 40 of file ilDatabaseAtomRunTest.php.

$ilDBInterfaceGalera

ilDatabaseAtomRunTest::$ilDBInterfaceGalera

protected

Definition at line 44 of file ilDatabaseAtomRunTest.php.

$ilDBInterfaceGaleraSecond

ilDatabaseAtomRunTest::$ilDBInterfaceGaleraSecond

protected

Definition at line 48 of file ilDatabaseAtomRunTest.php.

$ilDBInterfaceInnoDB

ilDatabaseAtomRunTest::$ilDBInterfaceInnoDB

protected

Definition at line 52 of file ilDatabaseAtomRunTest.php.

$ilDBInterfaceInnoDBSecond

ilDatabaseAtomRunTest::$ilDBInterfaceInnoDBSecond

protected

Definition at line 56 of file ilDatabaseAtomRunTest.php.

---

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

• Services/Database/test/Atom/ilDatabaseAtomRunTest.php