ilDatabaseAtomBaseTest Class Reference

TestCase for the ilDatabaseAtomBaseTest. More...

Inheritance diagram for ilDatabaseAtomBaseTest:

Collaboration diagram for ilDatabaseAtomBaseTest:

Public Member Functions
	testGetInstance ()
	testReadUncommited ()
	testReadCommited ()
	testReadRepeatedRead ()
	testAnomalies ()
	testLevel ()
	testRisks ()
	testCallables ()
	testWrongIsolationLevel ()
	testQueryWithFiveException ()
	testQueryWithTenException ()
	testWithOutLocks ()
	testWithOutClosures ()
	testMultipleClosures ()
	testLockSameTable ()
	testLockSameTableWithAlias ()

Protected Member Functions
	setUp ()

Protected Attributes
	$backupGlobals = false
	$ilDBInterfaceGalera
	$ilDBInterfaceInnoDB

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

@group needsInstalledILIAS

@runInSeparateProcess @preserveGlobalState disabled @backupGlobals disabled @backupStaticAttributes disabled

Definition at line 37 of file ilDatabaseAtomBaseTest.php.

Member Function Documentation

setUp()

ilDatabaseAtomBaseTest::setUp ( )

protected

Definition at line 53 of file ilDatabaseAtomBaseTest.php.

                                   {
                require_once("./Services/PHPUnit/classes/class.ilUnitUtil.php");
                ilUnitUtil::performInitialisation();
                require_once('./Services/Database/classes/Atom/class.ilAtomQueryBase.php');
                require_once('./Services/Database/classes/Atom/class.ilAtomQueryTransaction.php');
                require_once('./Services/Database/classes/Atom/class.ilAtomQueryLock.php');
                require_once('./Services/Database/classes/class.ilDBWrapperFactory.php');
 
                global $ilClientIniFile;
                $this->ilDBInterfaceGalera = ilDBWrapperFactory::getWrapper(ilDBConstants::TYPE_GALERA);
                $this->ilDBInterfaceGalera->initFromIniFile($ilClientIniFile);
                $this->ilDBInterfaceGalera->connect();
 
                $this->ilDBInterfaceInnoDB = ilDBWrapperFactory::getWrapper(ilDBConstants::TYPE_PDO_MYSQL_INNODB);
                $this->ilDBInterfaceInnoDB->initFromIniFile($ilClientIniFile);
                $this->ilDBInterfaceInnoDB->connect();
        }

References ilDBConstants\TYPE_GALERA, and ilDBConstants\TYPE_PDO_MYSQL_INNODB.

testAnomalies()

ilDatabaseAtomBaseTest::testAnomalies

(

)

Definition at line 104 of file ilDatabaseAtomBaseTest.php.

                                        {
                $this->setExpectedException('ilAtomQueryException', ilAtomQueryException::DB_ATOM_ANO_NOT_AVAILABLE);
                ilAtomQueryTransaction::checkAnomaly('lorem');
        }

References ilAtomQueryBase\checkAnomaly(), and ilAtomQueryException\DB_ATOM_ANO_NOT_AVAILABLE.

Here is the call graph for this function:

testCallables()

ilDatabaseAtomBaseTest::testCallables

(

)

Definition at line 123 of file ilDatabaseAtomBaseTest.php.

                                        {
                require_once('./Services/Database/classes/PDO/class.ilDBPdoMySQL.php');
                require_once('./Services/Database/test/Atom/data/class.ilAtomQueryTestHelper.php');
 
                $ilAtomQuery = $this->ilDBInterfaceGalera->buildAtomQuery();
                // Working
                $this->assertTrue($ilAtomQuery->checkCallable(function (ilDBInterface $ilDBInterface) { })); // ilDBInterface as first Parameter
                $this->assertTrue($ilAtomQuery->checkCallable(new ilAtomQueryTestHelper())); // Class with implemented __invoke
 
                // Non working
                $this->assertFalse($ilAtomQuery->checkCallable(function () { })); // No Parameter
                $this->assertFalse($ilAtomQuery->checkCallable(function (ilDBInterface $ilDBInterface, $someOtherParameter) { })); // More than one parameter
                $this->assertFalse($ilAtomQuery->checkCallable(function ($someOtherParameter, ilDBInterface $ilDBInterface) { })); // ilDBInterface not first parameter
                $this->assertFalse($ilAtomQuery->checkCallable(function (ilDBPdoMySQL $ilDBInterface) { })); // not ilDBInterface
                $this->assertFalse($ilAtomQuery->checkCallable(function ($ilDBInterface) { })); // not ilDBInterface
                function noClosure() { }
 
                $this->assertFalse($ilAtomQuery->checkCallable('noClosure')); // Not a Closure
 
        }

testGetInstance()

ilDatabaseAtomBaseTest::testGetInstance

(

)

Definition at line 72 of file ilDatabaseAtomBaseTest.php.

                                          {
                $ilAtomQueryTransaction = $this->ilDBInterfaceGalera->buildAtomQuery();
                $this->assertEquals($ilAtomQueryTransaction->getIsolationLevel(), ilAtomQuery::ISOLATION_SERIALIZABLE);
                $this->assertTrue($ilAtomQueryTransaction instanceof ilAtomQueryTransaction);
 
                $ilAtomQuery = $this->ilDBInterfaceInnoDB->buildAtomQuery();
                $this->assertEquals($ilAtomQuery->getIsolationLevel(), ilAtomQuery::ISOLATION_SERIALIZABLE);
                $this->assertTrue($ilAtomQuery instanceof ilAtomQueryLock);
        }

References ilAtomQuery\ISOLATION_SERIALIZABLE.

testLevel()

ilDatabaseAtomBaseTest::testLevel

(

)

Definition at line 110 of file ilDatabaseAtomBaseTest.php.

                                    {
                $this->setExpectedException('ilAtomQueryException', ilAtomQueryException::DB_ATOM_ISO_WRONG_LEVEL);
                ilAtomQueryTransaction::checkIsolationLevel('lorem');
        }

References ilAtomQueryBase\checkIsolationLevel(), and ilAtomQueryException\DB_ATOM_ISO_WRONG_LEVEL.

Here is the call graph for this function:

testLockSameTable()

ilDatabaseAtomBaseTest::testLockSameTable

(

)

Definition at line 223 of file ilDatabaseAtomBaseTest.php.

                                            {
                $this->setExpectedException('ilAtomQueryException', ilAtomQueryException::DB_ATOM_IDENTICAL_TABLES);
                $ilAtomQuery = $this->ilDBInterfaceInnoDB->buildAtomQuery();
                $ilAtomQuery->addTableLock('il_db_tests_atom');
                $ilAtomQuery->addTableLock('il_db_tests_atom');
                $ilAtomQuery->addQueryCallable(function (ilDBInterface $ilDBInterface) { });
                $ilAtomQuery->run();
        }

References ilAtomQueryException\DB_ATOM_IDENTICAL_TABLES.

testLockSameTableWithAlias()

ilDatabaseAtomBaseTest::testLockSameTableWithAlias

(

)

Definition at line 233 of file ilDatabaseAtomBaseTest.php.

                                                     {
                $this->setExpectedException('ilAtomQueryException', ilAtomQueryException::DB_ATOM_IDENTICAL_TABLES);
                $ilAtomQuery = $this->ilDBInterfaceInnoDB->buildAtomQuery();
                $ilAtomQuery->addTableLock('il_db_tests_atom')->aliasName('alias_one');
                $ilAtomQuery->addTableLock('il_db_tests_atom')->aliasName('alias_one');
                $ilAtomQuery->addQueryCallable(function (ilDBInterface $ilDBInterface) { });
                $ilAtomQuery->run();
        }

References ilAtomQueryException\DB_ATOM_IDENTICAL_TABLES.

testMultipleClosures()

ilDatabaseAtomBaseTest::testMultipleClosures

(

)

Definition at line 214 of file ilDatabaseAtomBaseTest.php.

                                               {
                $this->setExpectedException('ilAtomQueryException', ilAtomQueryException::DB_ATOM_CLOSURE_ALREADY_SET);
                $ilAtomQuery = $this->ilDBInterfaceGalera->buildAtomQuery();
                $ilAtomQuery->addTableLock('object_data');
                $ilAtomQuery->addQueryCallable(function (ilDBInterface $ilDBInterface) { });
                $ilAtomQuery->addQueryCallable(function (ilDBInterface $ilDBInterface) { });
        }

References ilAtomQueryException\DB_ATOM_CLOSURE_ALREADY_SET.

testQueryWithFiveException()

ilDatabaseAtomBaseTest::testQueryWithFiveException

(

)

Definition at line 156 of file ilDatabaseAtomBaseTest.php.

                                                     {
                $counter = 0;
                $max = 5;
                $result = null;
                $query = function (ilDBInterface $ilDBInterface) use (&$counter, &$max, &$result) {
                        if ($counter < $max) {
                                $counter ++;
                                throw new ilDatabaseException('', ilDatabaseException::DB_GENERAL);
                        }
                        $result = $ilDBInterface->listTables();
                };
 
                $ilAtomQuery = $this->ilDBInterfaceGalera->buildAtomQuery();
                $ilAtomQuery->addQueryCallable($query);
                $ilAtomQuery->addTableLock('object_data');
                $ilAtomQuery->run();
                $this->assertTrue(is_array($result));
        }

References $counter, $query, $result, and ilDatabaseException\DB_GENERAL.

testQueryWithTenException()

ilDatabaseAtomBaseTest::testQueryWithTenException

(

)

Definition at line 176 of file ilDatabaseAtomBaseTest.php.

                                                    {
                $this->setExpectedException('ilDatabaseException', ilDatabaseException::DB_GENERAL);
                $counter = 0;
                $max = 10;
                $result = null;
                $query = function (ilDBInterface $ilDBInterface) use (&$counter, &$max, &$result) {
                        if ($counter < $max) {
                                $counter ++;
                                throw new ilDatabaseException('', ilDatabaseException::DB_GENERAL);
                        }
                        $result = $ilDBInterface->listTables();
                };
 
                $ilAtomQuery = $this->ilDBInterfaceGalera->buildAtomQuery();
                $ilAtomQuery->addQueryCallable($query);
                $ilAtomQuery->addTableLock('object_data');
 
                $ilAtomQuery->run();
 
                $this->assertTrue(is_null($result));
        }

References $counter, $query, $result, and ilDatabaseException\DB_GENERAL.

testReadCommited()

ilDatabaseAtomBaseTest::testReadCommited

(

)

Definition at line 90 of file ilDatabaseAtomBaseTest.php.

                                           {
                $this->setExpectedException('ilAtomQueryException', ilAtomQueryException::DB_ATOM_ISO_WRONG_LEVEL);
                $other = new ilAtomQueryTransaction($this->ilDBInterfaceGalera, ilAtomQuery::ISOLATION_READ_COMMITED);
                $other->run();
        }

References ilAtomQueryException\DB_ATOM_ISO_WRONG_LEVEL, and ilAtomQuery\ISOLATION_READ_COMMITED.

testReadRepeatedRead()

ilDatabaseAtomBaseTest::testReadRepeatedRead

(

)

Definition at line 97 of file ilDatabaseAtomBaseTest.php.

                                               {
                $this->setExpectedException('ilAtomQueryException', ilAtomQueryException::DB_ATOM_ISO_WRONG_LEVEL);
                $other = new ilAtomQueryTransaction($this->ilDBInterfaceGalera, ilAtomQuery::ISOLATION_REPEATED_READ);
                $other->run();
        }

References ilAtomQueryException\DB_ATOM_ISO_WRONG_LEVEL, and ilAtomQuery\ISOLATION_REPEATED_READ.

testReadUncommited()

ilDatabaseAtomBaseTest::testReadUncommited

(

)

Definition at line 83 of file ilDatabaseAtomBaseTest.php.

                                             {
                $this->setExpectedException('ilAtomQueryException', ilAtomQueryException::DB_ATOM_ISO_WRONG_LEVEL);
                $other = new ilAtomQueryTransaction($this->ilDBInterfaceGalera, ilAtomQuery::ISOLATION_READ_UNCOMMITED);
                $other->run();
        }

References ilAtomQueryException\DB_ATOM_ISO_WRONG_LEVEL, and ilAtomQuery\ISOLATION_READ_UNCOMMITED.

testRisks()

ilDatabaseAtomBaseTest::testRisks

(

)

Definition at line 116 of file ilDatabaseAtomBaseTest.php.

                                    {
                $ilAtomQuery = $this->ilDBInterfaceGalera->buildAtomQuery();
                $ilAtomQuery->addTableLock('object_data');
                $this->assertEquals(array(), $ilAtomQuery->getRisks());
        }

testWithOutClosures()

ilDatabaseAtomBaseTest::testWithOutClosures

(

)

Definition at line 206 of file ilDatabaseAtomBaseTest.php.

                                              {
                $this->setExpectedException('ilAtomQueryException', ilAtomQueryException::DB_ATOM_CLOSURE_NONE);
                $ilAtomQuery = $this->ilDBInterfaceInnoDB->buildAtomQuery();
                $ilAtomQuery->addTableLock('object_data');
                $ilAtomQuery->run();
        }

References ilAtomQueryException\DB_ATOM_CLOSURE_NONE.

testWithOutLocks()

ilDatabaseAtomBaseTest::testWithOutLocks

(

)

Definition at line 199 of file ilDatabaseAtomBaseTest.php.

                                           {
                $this->setExpectedException('ilAtomQueryException', ilAtomQueryException::DB_ATOM_LOCK_NO_TABLE);
                $ilAtomQuery = $this->ilDBInterfaceInnoDB->buildAtomQuery();
                $ilAtomQuery->run();
        }

References ilAtomQueryException\DB_ATOM_LOCK_NO_TABLE.

testWrongIsolationLevel()

ilDatabaseAtomBaseTest::testWrongIsolationLevel

(

)

Definition at line 145 of file ilDatabaseAtomBaseTest.php.

                                                  {
                $this->setExpectedException('ilDatabaseException');
                $ilAtomQuery = new ilAtomQueryTransaction($this->ilDBInterfaceGalera, 'non_existing');
                $ilAtomQuery->addTableLock('il_db_tests_atom');
                $ilAtomQuery->addQueryCallable(function (ilDBInterface $ilDB) {
                        $ilDB->getDBType();
                });
                $ilAtomQuery->run();
        }

References $ilDB.

Field Documentation

$backupGlobals

ilDatabaseAtomBaseTest::$backupGlobals = false

protected

Definition at line 42 of file ilDatabaseAtomBaseTest.php.

$ilDBInterfaceGalera

ilDatabaseAtomBaseTest::$ilDBInterfaceGalera

protected

Definition at line 46 of file ilDatabaseAtomBaseTest.php.

$ilDBInterfaceInnoDB

ilDatabaseAtomBaseTest::$ilDBInterfaceInnoDB

protected

Definition at line 50 of file ilDatabaseAtomBaseTest.php.

---

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

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