ilDBUpdate Class Reference

Database Update class. More...

Inheritance diagram for ilDBUpdate:

Collaboration diagram for ilDBUpdate:

Public Member Functions
	__construct (ilDBInterface $a_db_handler, ilIniFile $client_ini=null)
	getCustomUpdatesCurrentVersion ()
	getCustomUpdatesFileVersion ()
	applyCustomUpdates ()

Protected Member Functions
	checkQuery (string $q)
	initGlobalsRequiredForUpdateSteps (?ilCtrlStructureReader &$ilCtrlStructureReader, ?ilDBInterface &$ilDB)
	applyUpdateNr (int $nr, bool $custom_update=false)
	Apply a custom database update or a plugin update. More...
	setCurrentVersion (?int $a_version)

Protected Attributes
string	$updateMsg
ilDBInterface	$db
ilIniFile	$client_ini = null
Iterator	$ctrl_structure_iterator
string	$error
string	$PATH = './'
array	$filecontent

Private Member Functions
	execQuery (ilDBInterface $db, string $str)
	setCustomUpdatesCurrentVersion (?int $a_version)
	readCustomUpdatesFileVersion (array $a_file_content)
	readCustomUpdatesInfo (bool $a_force=false)

Private Attributes
int	$custom_updates_current_version = 0
int	$custom_updates_file_version = null
bool	$custom_updates_info_read = null
ilSetting	$custom_updates_setting
array	$custom_updates_content = []

Detailed Description

Database Update class.

Author

Peter Gabriel pgabr.nosp@m.iel@.nosp@m.datab.nosp@m.ay.d.nosp@m.e

Alex Killing alex..nosp@m.kill.nosp@m.ing@g.nosp@m.mx.d.nosp@m.e

Version

$Id$

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

Constructor & Destructor Documentation

__construct()

ilDBUpdate::__construct	(	ilDBInterface	$a_db_handler,
		ilIniFile	$client_ini = null
	)

Definition at line 46 of file class.ilDBUpdate.php.

References $client_ini.

    {
        $this->client_ini = $client_ini;
        $this->db = $a_db_handler;
        $this->PATH = "./";

        $class_map = require ILIAS_ABSOLUTE_PATH . '/libs/composer/vendor/composer/autoload_classmap.php';
        $this->ctrl_structure_iterator = new ilCtrlArrayIterator($class_map);
    }

Member Function Documentation

applyCustomUpdates()

ilDBUpdate::applyCustomUpdates

(

)

Definition at line 268 of file class.ilDBUpdate.php.

References $custom_updates_content, $error, $ilDB, applyUpdateNr(), getCustomUpdatesCurrentVersion(), getCustomUpdatesFileVersion(), initGlobalsRequiredForUpdateSteps(), and readCustomUpdatesInfo().

                                        : bool
    {
        $ilCtrlStructureReader = null;
        $ilDB = null;
        $this->initGlobalsRequiredForUpdateSteps($ilCtrlStructureReader, $ilDB);
        $this->readCustomUpdatesInfo(true);

        $file_version = $this->getCustomUpdatesFileVersion();
        $current_version = $this->getCustomUpdatesCurrentVersion();
        $this->filecontent = $this->custom_updates_content;

        $this->updateMsg = 'no_changes';
        if ($current_version < $file_version) {
            $msg = [];
            for ($i = ($current_version + 1); $i <= $file_version; $i++) {
                if ($this->applyUpdateNr($i, true) === false) {
                    $msg[] = [
                        'msg' => 'update_error: ' . $this->error,
                        'nr' => $i,
                    ];
                    $this->updateMsg = implode("\n", $msg);

                    return false;
                }

                $msg[] = [
                    'msg' => 'custom_update_applied',
                    'nr' => $i,
                ];
            }

            $this->updateMsg = implode("\n", $msg);
        }

        return true;
    }

Here is the call graph for this function:

applyUpdateNr()

ilDBUpdate::applyUpdateNr ( int  $nr, bool  $custom_update = false  )

protected

Apply a custom database update or a plugin update.

Parameters

int

$nr

number what patch to apply (Reference: Patch for https://mantis.ilias.de/view.php?id=28550) private

Definition at line 129 of file class.ilDBUpdate.php.

References $error, $ilDB, execQuery(), initGlobalsRequiredForUpdateSteps(), setCurrentVersion(), and setCustomUpdatesCurrentVersion().

Referenced by applyCustomUpdates(), and ilPluginDBUpdate\applyUpdate().

                                                                          : bool
    {
        $ilCtrlStructureReader = null;
        $ilDB = null;
        $this->initGlobalsRequiredForUpdateSteps($ilCtrlStructureReader, $ilDB);

        reset($this->filecontent);

        //init
        $i = 0;

        //go through filecontent
        while (!preg_match("/^<\#" . $nr . ">/", $this->filecontent[$i]) && $i < count($this->filecontent)) {
            $i++;
        }

        //update not found
        if ($i === count($this->filecontent)) {
            $this->error = 'update_not_found';

            return false;
        }

        $i++;

        //update found, now extract this update to a new array
        $update = [];
        while ($i < count($this->filecontent) && !preg_match("/^<#" . ($nr + 1) . ">/", $this->filecontent[$i])) {
            $update[] = trim($this->filecontent[$i]);
            $i++;
        }

        //now you have the update, now process it
        $sql = [];
        $php = [];
        $mode = 'sql';

        foreach ($update as $row) {
            if (preg_match("/<\?php/", $row)) {
                if (count($sql) > 0) {
                    if ($this->execQuery($this->db, implode("\n", $sql)) === false) {
                        return false;
                    }
                    $sql = [];
                }
                $mode = 'php';
            } elseif (preg_match("/\?>/", $row)) {
                if (count($php) > 0) {
                    $code = implode("\n", $php);
                    if (eval($code) === false) {
                        $this->error = 'Parse error: ' . $code;

                        return false;
                    }
                    $php = [];
                }
                $mode = 'sql';
            } else {
                if ($mode === 'sql') {
                    $sql[] = $row;
                }

                if ($mode === 'php') {
                    $php[] = $row;
                }
            }
        }

        if ($mode === 'sql' && count($sql) > 0 && $this->execQuery($this->db, implode("\n", $sql)) === false) {
            $this->error = "dump_error: " . $this->error;

            return false;
        }

        if ($custom_update) {
            $this->setCustomUpdatesCurrentVersion($nr);
        } else {
            $this->setCurrentVersion($nr);
        }

        return true;
    }

Here is the call graph for this function:

Here is the caller graph for this function:

checkQuery()

ilDBUpdate::checkQuery ( string  $q )

protected

Definition at line 91 of file class.ilDBUpdate.php.

Referenced by execQuery().

                                            : bool
    {
        return true;
    }

Here is the caller graph for this function:

execQuery()

ilDBUpdate::execQuery ( ilDBInterface  $db, string  $str  )

private

PhpUndefinedVariableInspection

PhpUndefinedVariableInspection

Definition at line 56 of file class.ilDBUpdate.php.

References $check, $q, checkQuery(), and ilDBInterface\query().

Referenced by applyUpdateNr().

                                                              : bool
    {
        $q = "";
        $sql = explode("\n", trim($str));
        foreach ($sql as $i => $statement) {
            $sql[$i] = trim($statement);
            if ($statement !== "" && $statement[0] !== "#") {
                //take line per line, until last char is ";"
                if (substr($statement, -1) === ";") {
                    //query is complete
                    $q .= " " . substr($statement, 0, -1);
                    $check = $this->checkQuery($q);
                    if ($check === true) {
                        $db->query($q);
                    } else {
                        $this->error = (string) $check;
                        return false;
                    }
                    unset($q);
                } else {
                    $q .= " " . $statement;
                }
            }
        }
        if (isset($q) && $q !== "") {
            echo "incomplete_statement: " . $q . "<br>";

            return false;
        }

        return true;
    }

Here is the call graph for this function:

Here is the caller graph for this function:

getCustomUpdatesCurrentVersion()

ilDBUpdate::getCustomUpdatesCurrentVersion

(

)

Definition at line 212 of file class.ilDBUpdate.php.

References $custom_updates_current_version, and readCustomUpdatesInfo().

Referenced by applyCustomUpdates().

                                                    : ?int
    {
        $this->readCustomUpdatesInfo();

        return $this->custom_updates_current_version;
    }

Here is the call graph for this function:

Here is the caller graph for this function:

getCustomUpdatesFileVersion()

ilDBUpdate::getCustomUpdatesFileVersion

(

)

Definition at line 230 of file class.ilDBUpdate.php.

References $custom_updates_file_version, and readCustomUpdatesInfo().

Referenced by applyCustomUpdates().

                                                 : ?int
    {
        $this->readCustomUpdatesInfo();

        return $this->custom_updates_file_version;
    }

Here is the call graph for this function:

Here is the caller graph for this function:

initGlobalsRequiredForUpdateSteps()

ilDBUpdate::initGlobalsRequiredForUpdateSteps ( ?ilCtrlStructureReader &  $ilCtrlStructureReader, ?ilDBInterface &  $ilDB  )

protected

Definition at line 96 of file class.ilDBUpdate.php.

References $DIC, and $GLOBALS.

Referenced by applyCustomUpdates(), ilPluginDBUpdate\applyUpdate(), and applyUpdateNr().

     : void {
        global $DIC;

        // TODO: There is currently a huge mixup of globals, $DIC and dependencies, esprecially in setup and during DB-Updates. This leads to many problems. The following core tries to provide the needed dependencies for the dbupdate-script. The code hopefully will change in the future.

        if (isset($GLOBALS['ilCtrlStructureReader'])) {
            $ilCtrlStructureReader = $GLOBALS['ilCtrlStructureReader'];
        } elseif ($DIC->offsetExists('ilCtrlStructureReader')) {
            $ilCtrlStructureReader = $DIC['ilCtrlStructureReader'];
        } else {
            $ilCtrlStructureReader = new ilCtrlStructureReader(
                $this->ctrl_structure_iterator,
                new ilCtrlStructureCidGenerator()
            );
            $DIC->offsetSet('ilCtrlStructureReader', $ilCtrlStructureReader);
        }

        $GLOBALS['ilCtrlStructureReader'] = $ilCtrlStructureReader;

        if ($this->client_ini) {
            $ilCtrlStructureReader->setIniFile($this->client_ini);
        }
        $ilDB = $DIC->database();
    }

Here is the caller graph for this function:

readCustomUpdatesFileVersion()

ilDBUpdate::readCustomUpdatesFileVersion ( array  $a_file_content )

private

Definition at line 237 of file class.ilDBUpdate.php.

References $version.

Referenced by readCustomUpdatesInfo().

                                                                        : int
    {
        //go through file content and search for last occurrence of <#x>
        reset($a_file_content);
        $regs = [];
        $version = 0;
        foreach ($a_file_content as $row) {
            if (preg_match("/^<#([0-9]+)>/", $row, $regs)) {
                $version = $regs[1];
            }
        }

        return (int) $version;
    }

Here is the caller graph for this function:

readCustomUpdatesInfo()

ilDBUpdate::readCustomUpdatesInfo ( bool  $a_force = false )

private

Definition at line 252 of file class.ilDBUpdate.php.

References ILIAS\Repository\int(), and readCustomUpdatesFileVersion().

Referenced by applyCustomUpdates(), getCustomUpdatesCurrentVersion(), getCustomUpdatesFileVersion(), and setCustomUpdatesCurrentVersion().

                                                                 : void
    {
        if ($this->custom_updates_info_read && !$a_force) {
            return;
        }

        $this->custom_updates_setting = new ilSetting();
        $custom_updates_file = $this->PATH . 'setup/sql/dbupdate_custom.php';
        if (is_file($custom_updates_file)) {
            $this->custom_updates_content = @file($custom_updates_file);
            $this->custom_updates_current_version = (int) $this->custom_updates_setting->get('db_version_custom', '0');
            $this->custom_updates_file_version = $this->readCustomUpdatesFileVersion($this->custom_updates_content);
        }
        $this->custom_updates_info_read = true;
    }

Here is the call graph for this function:

Here is the caller graph for this function:

setCurrentVersion()

ilDBUpdate::setCurrentVersion ( ?int  $a_version )

protected

Definition at line 226 of file class.ilDBUpdate.php.

Referenced by applyUpdateNr().

                                                         : void
    {
    }

Here is the caller graph for this function:

setCustomUpdatesCurrentVersion()

ilDBUpdate::setCustomUpdatesCurrentVersion ( ?int  $a_version )

private

Definition at line 219 of file class.ilDBUpdate.php.

References readCustomUpdatesInfo().

Referenced by applyUpdateNr().

                                                                    : void
    {
        $this->readCustomUpdatesInfo();
        $this->custom_updates_setting->set('db_version_custom', (string) $a_version);
        $this->custom_updates_current_version = $a_version;
    }

Here is the call graph for this function:

Here is the caller graph for this function:

Field Documentation

$client_ini

ilIniFile ilDBUpdate::$client_ini = null

protected

Definition at line 32 of file class.ilDBUpdate.php.

Referenced by __construct().

$ctrl_structure_iterator

Iterator ilDBUpdate::$ctrl_structure_iterator

protected

Definition at line 33 of file class.ilDBUpdate.php.

$custom_updates_content

array ilDBUpdate::$custom_updates_content = []

private

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

Referenced by applyCustomUpdates().

$custom_updates_current_version

int ilDBUpdate::$custom_updates_current_version = 0

private

Definition at line 40 of file class.ilDBUpdate.php.

Referenced by getCustomUpdatesCurrentVersion().

$custom_updates_file_version

int ilDBUpdate::$custom_updates_file_version = null

private

Definition at line 41 of file class.ilDBUpdate.php.

Referenced by getCustomUpdatesFileVersion().

$custom_updates_info_read

bool ilDBUpdate::$custom_updates_info_read = null

private

Definition at line 42 of file class.ilDBUpdate.php.

$custom_updates_setting

ilSetting ilDBUpdate::$custom_updates_setting

private

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

$db

ilDBInterface ilDBUpdate::$db

protected

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

Referenced by ilPluginDBUpdate\__construct().

$error

string ilDBUpdate::$error

protected

Definition at line 35 of file class.ilDBUpdate.php.

Referenced by applyCustomUpdates(), and applyUpdateNr().

$filecontent

array ilDBUpdate::$filecontent

protected

Definition at line 38 of file class.ilDBUpdate.php.

$PATH

string ilDBUpdate::$PATH = './'

protected

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

$updateMsg

string ilDBUpdate::$updateMsg

protected

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

---

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

• Services/Database/classes/class.ilDBUpdate.php