ILIAS\Setup\ilMysqlMyIsamToInnoDbMigration Class Reference

Inheritance diagram for ILIAS\Setup\ilMysqlMyIsamToInnoDbMigration:

Collaboration diagram for ILIAS\Setup\ilMysqlMyIsamToInnoDbMigration:

Public Member Functions
	getLabel ()
	getDefaultAmountOfStepsPerRun ()
	getPreconditions (Environment $environment)
	step (Environment $environment)
	getRemainingAmountOfSteps ()
Public Member Functions inherited from ILIAS\Setup\Migration
	prepare (Environment $environment)
	Prepare the migration by means of some environment. More...

Protected Member Functions
	getNonInnoDBTables ()

Protected Attributes
string	$db_name = null
ilDBInterface	$database = null

Additional Inherited Members
Data Fields inherited from ILIAS\Setup\Migration
const	INFINITE = -1

Detailed Description

Definition at line 28 of file class.ilMysqlMyIsamToInnoDbMigration.php.

Member Function Documentation

getDefaultAmountOfStepsPerRun()

ILIAS\Setup\ilMysqlMyIsamToInnoDbMigration::getDefaultAmountOfStepsPerRun

(

)

Implements ILIAS\Setup\Migration.

Definition at line 44 of file class.ilMysqlMyIsamToInnoDbMigration.php.

                                                   : int
    {
        return 20;
    }

getLabel()

ILIAS\Setup\ilMysqlMyIsamToInnoDbMigration::getLabel

(

)

Implements ILIAS\Setup\Migration.

Definition at line 36 of file class.ilMysqlMyIsamToInnoDbMigration.php.

                              : string
    {
        return "Migration to convert tables from MyISAM to Innodb service";
    }

getNonInnoDBTables()

ILIAS\Setup\ilMysqlMyIsamToInnoDbMigration::getNonInnoDBTables ( )

protected

Definition at line 107 of file class.ilMysqlMyIsamToInnoDbMigration.php.

References ilDBConstants\MYSQL_ENGINE_INNODB.

Referenced by ILIAS\Setup\ilMysqlMyIsamToInnoDbMigration\getRemainingAmountOfSteps(), and ILIAS\Setup\ilMysqlMyIsamToInnoDbMigration\step().

                                           : array
    {
        $tables = [];
        $set = $this->database->queryF("SELECT table_name
                FROM INFORMATION_SCHEMA.TABLES
                WHERE ENGINE != %s AND table_schema = %s;", ['text', 'text'], [
            ilDBConstants::MYSQL_ENGINE_INNODB,
            $this->db_name
        ]);
        while ($row = $this->database->fetchAssoc($set)) {
            $tables[] = $row['table_name'];
        }
        return $tables;
    }

Here is the caller graph for this function:

getPreconditions()

ILIAS\Setup\ilMysqlMyIsamToInnoDbMigration::getPreconditions

(

Environment

$environment

)

Implements ILIAS\Setup\Migration.

Definition at line 52 of file class.ilMysqlMyIsamToInnoDbMigration.php.

References ILIAS\Setup\Environment\getResource(), ILIAS\Setup\Migration\prepare(), ILIAS\Setup\Environment\RESOURCE_CLIENT_INI, and ILIAS\Setup\Environment\RESOURCE_DATABASE.

                                                              : array
    {
        return [
            new ilIniFilesLoadedObjective(),
            new ilDatabaseInitializedObjective(),
            new ilDatabaseUpdatedObjective()
        ];
    }

Here is the call graph for this function:

getRemainingAmountOfSteps()

ILIAS\Setup\ilMysqlMyIsamToInnoDbMigration::getRemainingAmountOfSteps

(

)

Implements ILIAS\Setup\Migration.

Definition at line 98 of file class.ilMysqlMyIsamToInnoDbMigration.php.

References $rows, and ILIAS\Setup\ilMysqlMyIsamToInnoDbMigration\getNonInnoDBTables().

                                               : int
    {
        if ($this->db_name !== null) {
            $rows = $this->getNonInnoDBTables();
            return count($rows);
        }
        return 0;
    }

Here is the call graph for this function:

step()

ILIAS\Setup\ilMysqlMyIsamToInnoDbMigration::step

(

Environment

$environment

)

Exceptions

ilException

Implements ILIAS\Setup\Migration.

Definition at line 78 of file class.ilMysqlMyIsamToInnoDbMigration.php.

References Vendor\Package\$e, $rows, and ILIAS\Setup\ilMysqlMyIsamToInnoDbMigration\getNonInnoDBTables().

                                                  : void
    {
        $rows = $this->getNonInnoDBTables();
        $table_name = array_pop($rows);

        if (is_string($table_name) && $table_name !== '') {
            try {
                $this->database->migrateTableToEngine($table_name);
            } catch (\ilDatabaseException $e) {
                throw new UnachievableException(
                    "The migration of the following tables did throw errors, " .
                    "please resolve the problem before you continue: \n" . $table_name . " -> " . $e->getMessage()
                );
            }
        }
    }

Here is the call graph for this function:

Field Documentation

$database

ilDBInterface ILIAS\Setup\ilMysqlMyIsamToInnoDbMigration::$database = null

protected

Definition at line 31 of file class.ilMysqlMyIsamToInnoDbMigration.php.

$db_name

string ILIAS\Setup\ilMysqlMyIsamToInnoDbMigration::$db_name = null

protected

Definition at line 30 of file class.ilMysqlMyIsamToInnoDbMigration.php.

---

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

• Services/Database/classes/Setup/class.ilMysqlMyIsamToInnoDbMigration.php