Inheritance diagram for ILIAS\Setup\ilMysqlMyIsamToInnoDbMigration:

Collaboration diagram for ILIAS\Setup\ilMysqlMyIsamToInnoDbMigration:

Public Member Functions
	getLabel ()
	@inheritDoc More...

	getDefaultAmountOfStepsPerRun ()
	@inheritDoc More...

	getPreconditions (Environment $environment)
	@inheritDoc More...

	step (Environment $environment)
	@inheritDoc More...

	getRemainingAmountOfSteps ()
	@inheritDoc More...

Public Member Functions inherited from ILIAS\Setup\Migration
	getLabel ()

	getDefaultAmountOfStepsPerRun ()
	Tell the default amount of steps to be executed for one run of the migration. More...

	getPreconditions (Environment $environment)
	Objectives the migration depend on. More...

	prepare (Environment $environment)
	Prepare the migration by means of some environment. More...

	step (Environment $environment)
	Run one step of the migration. More...

	getRemainingAmountOfSteps ()
	Count up how many "things" need to be migrated. 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 27 of file class.ilMysqlMyIsamToInnoDbMigration.php.

Member Function Documentation

◆ getDefaultAmountOfStepsPerRun()

ILIAS\Setup\ilMysqlMyIsamToInnoDbMigration::getDefaultAmountOfStepsPerRun ( )

@inheritDoc

Implements ILIAS\Setup\Migration.

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

◆ getLabel()

ILIAS\Setup\ilMysqlMyIsamToInnoDbMigration::getLabel ( )

@inheritDoc

Implements ILIAS\Setup\Migration.

Definition at line 35 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 106 of file class.ilMysqlMyIsamToInnoDbMigration.php.

                                           : 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;
    }

References ILIAS\Repository\database(), and ilDBConstants\MYSQL_ENGINE_INNODB.

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

Here is the call graph for this function:

Here is the caller graph for this function:

◆ getPreconditions()

ILIAS\Setup\ilMysqlMyIsamToInnoDbMigration::getPreconditions ( Environment $environment )

@inheritDoc

Implements ILIAS\Setup\Migration.

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

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

◆ getRemainingAmountOfSteps()

ILIAS\Setup\ilMysqlMyIsamToInnoDbMigration::getRemainingAmountOfSteps ( )

@inheritDoc

Implements ILIAS\Setup\Migration.

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

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

References ILIAS\Setup\ilMysqlMyIsamToInnoDbMigration\getNonInnoDBTables().

Here is the call graph for this function:

◆ step()

ILIAS\Setup\ilMysqlMyIsamToInnoDbMigration::step ( Environment $environment )

@inheritDoc

Exceptions

ilException

Implements ILIAS\Setup\Migration.

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

                                                  : 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()
                );
            }
        }
    }