ilDatabasePopulatedObjective Class Reference

Inheritance diagram for ilDatabasePopulatedObjective:

Collaboration diagram for ilDatabasePopulatedObjective:

Public Member Functions
	getHash ()
	getLabel ()
	isNotable ()
	getPreconditions (Setup\Environment $environment)
	isApplicable (Setup\Environment $environment)
	@inheritDoc More...
Public Member Functions inherited from ilDatabaseObjective
	__construct (\ilDatabaseSetupConfig $config)

Data Fields
const	MIN_NUMBER_OF_ILIAS_TABLES = 200

Protected Member Functions
	isDatabasePopulated (ilDBInterface $db)

Private Member Functions
	readDumpFile (ilDBInterface $db)
	queryReader (string $path_to_db_dump)
	setDefaultEngine (ilDBInterface $db)
	getDefaultEngine (ilDBInterface $db)

Additional Inherited Members
Protected Attributes inherited from ilDatabaseObjective
	$config

Detailed Description

Definition at line 7 of file class.ilDatabasePopulatedObjective.php.

Member Function Documentation

getDefaultEngine()

ilDatabasePopulatedObjective::getDefaultEngine ( ilDBInterface  $db )

private

Parameters

ilDBInterface

$db

Returns

string

Definition at line 167 of file class.ilDatabasePopulatedObjective.php.

                                                         : string
    {
        try {
            $r = $db->query('SHOW ENGINES ');
 
            $default = '';
            while ($d = $db->fetchObject($r)) {
                if ($d->Support === 'DEFAULT') {
                    $default = $d->Engine;
                }
            }
            return strtolower($default);
        } catch (Throwable $e) {
            return 'unknown';
        }
    }

References $d, Vendor\Package\$e, ilDBInterface\fetchObject(), and ilDBInterface\query().

Here is the call graph for this function:

getHash()

ilDatabasePopulatedObjective::getHash

(

)

Definition at line 11 of file class.ilDatabasePopulatedObjective.php.

                              : string
    {
        return hash("sha256", implode("-", [
            self::class,
            $this->config->getHost(),
            $this->config->getPort(),
            $this->config->getDatabase()
        ]));
    }

getLabel()

ilDatabasePopulatedObjective::getLabel

(

)

Definition at line 21 of file class.ilDatabasePopulatedObjective.php.

                               : string
    {
        return "The database is populated with ILIAS-tables.";
    }

getPreconditions()

ilDatabasePopulatedObjective::getPreconditions

(

Setup\Environment

$environment

)

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

                                                                     : array
    {
        if ($environment->getResource(Setup\Environment::RESOURCE_DATABASE)) {
            return [];
        }
        return [
            new \ilDatabaseExistsObjective($this->config)
        ];
    }

isApplicable()

ilDatabasePopulatedObjective::isApplicable

(

Setup\Environment

$environment

)

@inheritDoc

Definition at line 74 of file class.ilDatabasePopulatedObjective.php.

                                                                 : bool
    {
        $db = $environment->getResource(Setup\Environment::RESOURCE_DATABASE);
 
        return !$this->isDatabasePopulated($db);
    }

References isDatabasePopulated().

Here is the call graph for this function:

isDatabasePopulated()

ilDatabasePopulatedObjective::isDatabasePopulated ( ilDBInterface  $db )

protected

Definition at line 81 of file class.ilDatabasePopulatedObjective.php.

                                                              : bool
    {
        $probe_tables = ['usr_data', 'object_data', 'object_reference'];
        $number_of_probe_tables = count($probe_tables);
        $tables = $db->listTables();
        $number_of_tables = count($tables);
 
        return
            $number_of_tables > self::MIN_NUMBER_OF_ILIAS_TABLES
            && count(array_intersect($tables, $probe_tables)) == $number_of_probe_tables;
    }

References ilDBInterface\listTables().

Referenced by isApplicable().

Here is the call graph for this function:

Here is the caller graph for this function:

isNotable()

ilDatabasePopulatedObjective::isNotable

(

)

Definition at line 26 of file class.ilDatabasePopulatedObjective.php.

                                : bool
    {
        return true;
    }

queryReader()

ilDatabasePopulatedObjective::queryReader ( string  $path_to_db_dump )

private

Definition at line 119 of file class.ilDatabasePopulatedObjective.php.

                                                         : Generator
    {
        $stack = '';
        $handle = fopen($path_to_db_dump, "r");
        while (($line = fgets($handle)) !== false) {
            if (preg_match('/^--/', $line)) { // Skip comments
                continue;
            }
            if (preg_match('/^\/\*/', $line)) { // Run Variables Assignments as single query
                yield $line;
                $stack = '';
                continue;
            }
            if (!preg_match('/;$/', trim($line))) { // Break after ; character which indicates end of query
                $stack .= $line;
            } else {
                $stack .= $line;
                yield $stack;
                $stack = '';
            }
        }
 
        fclose($handle);
    }

Referenced by readDumpFile().

Here is the caller graph for this function:

readDumpFile()

ilDatabasePopulatedObjective::readDumpFile ( ilDBInterface  $db )

private

Parameters

ilDBInterface

$db

Exceptions

ilDatabaseException

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

                                                     : void
    {
        $path_to_db_dump = $this->config->getPathToDBDump();
        if (!is_file(realpath($path_to_db_dump)) ||
            !is_readable(realpath($path_to_db_dump))) {
            throw new Setup\UnachievableException(
                "Cannot read database dump file: $path_to_db_dump"
            );
        }
        foreach ($this->queryReader(realpath($path_to_db_dump)) as $query) {
            try {
                $statement = $db->prepareManip($query);
                $db->execute($statement);
            } catch (Throwable $e) {
                throw new Setup\UnachievableException(
                    "Cannot populate database with dump file: $path_to_db_dump. Query failed: $query wih message " . $e->getMessage(
                    )
                );
            }
        }
    }

References Vendor\Package\$e, $query, ilDBInterface\execute(), ilDBInterface\prepareManip(), and queryReader().

Here is the call graph for this function:

setDefaultEngine()

ilDatabasePopulatedObjective::setDefaultEngine ( ilDBInterface  $db )

private

Parameters

ilDBInterface | null

$db

Definition at line 147 of file class.ilDatabasePopulatedObjective.php.

                                                         : void
    {
        switch ($db->getDBType()) {
            case ilDBConstants::TYPE_PDO_MYSQL_INNODB:
            case ilDBConstants::TYPE_INNODB:
            case ilDBConstants::TYPE_GALERA:
                $db->manipulate('SET default_storage_engine=InnoDB;');
                break;
            case ilDBConstants::TYPE_PDO_MYSQL_MYISAM:
            case ilDBConstants::TYPE_MYSQL:
                $db->manipulate('SET default_storage_engine=MyISAM;');
                break;
 
        }
    }

References ilDBInterface\getDBType(), ilDBInterface\manipulate(), ilDBConstants\TYPE_GALERA, ilDBConstants\TYPE_INNODB, ilDBConstants\TYPE_MYSQL, ilDBConstants\TYPE_PDO_MYSQL_INNODB, and ilDBConstants\TYPE_PDO_MYSQL_MYISAM.

Here is the call graph for this function:

Field Documentation

MIN_NUMBER_OF_ILIAS_TABLES

const ilDatabasePopulatedObjective::MIN_NUMBER_OF_ILIAS_TABLES = 200

Definition at line 9 of file class.ilDatabasePopulatedObjective.php.

---

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

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