ilPluginDBUpdate Class Reference

Database Update class. More...

Inheritance diagram for ilPluginDBUpdate:

Collaboration diagram for ilPluginDBUpdate:

Public Member Functions
	__construct ( $a_ctype, $a_cname, $a_slot_id, $a_pname, $a_db_handler, $tmp_flag, $a_db_prefix)
	constructor More...
	getFileForStep ($a_version)
	Get db update file name for db step. More...
	_DBUpdate ()
	destructor More...
	getCurrentVersion ()
	Get current DB version. More...
	setCurrentVersion ($a_version)
	Set current DB version. More...
	loadXMLInfo ()
	checkQuery ($q)
	This is a very simple check. More...
Public Member Functions inherited from ilDBUpdate
	__construct ($a_db_handler=0, $client_ini=null)
	ilDBUpdate constructor. More...
	getFileForStep ($a_version)
	Get db update file name for db step. More...
	initStep ($i)
	readDBUpdateFile ()
	readLastUpdateFile ()
	getCurrentVersion ()
	setCurrentVersion ($a_version)
	setRunningStatus ($a_nr)
	Set running status for a step. More...
	getRunningStatus ()
	Get running status. More...
	clearRunningStatus ()
	Clear running status. More...
	readFileVersion ()
	getFileVersion ()
	Get Version of file. More...
	execQuery ($db, $str)
	execute a query More...
	checkQuery ($q)
	check query More...
	applyUpdate ($a_break=0)
	Apply update. More...
	loadXMLInfo ()
	applyUpdateNr (&$nr, $hotfix=false, $custom_update=false)
	apply an update More...
	getDBVersionStatus ()
	getTables ()
	getTableStatus ($table)
	getHotfixCurrentVersion ()
	Get current hotfix version. More...
	setHotfixCurrentVersion ($a_version)
	Set current hotfix version. More...
	getHotfixFileVersion ()
	Get current hotfix version. More...
	readHotfixFileVersion ($a_file_content)
	Set current hotfix version. More...
	readHotfixInfo ($a_force=false)
	Get status of hotfix file. More...
	hotfixAvailable ()
	Get status of hotfix file. More...
	applyHotfix ()
	Apply hotfix. More...
	getCustomUpdatesCurrentVersion ()
	setCustomUpdatesCurrentVersion ($a_version)
	getCustomUpdatesFileVersion ()
	readCustomUpdatesFileVersion ($a_file_content)
	readCustomUpdatesInfo ($a_force=false)
	customUpdatesAvailable ()
	applyCustomUpdates ()
	getUpdateSteps ($a_break=0)
	Get update steps as string (for presentation) More...
	getHotfixSteps ()
	Get hotfix steps. More...
	getUpdateStepNr ($nr, $hotfix=false, $custom_update=false)
	Get single update step for presentation. More...

Additional Inherited Members
Data Fields inherited from ilDBUpdate
	$DB_UPDATE_FILE
	db update file More...
	$currentVersion
	$fileVersion
	$updateMsg

Detailed Description

Database Update class.

Author

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

Version

Id

class.ilDBUpdate.php 15875 2008-02-03 13:56:32Z akill

Definition at line 10 of file class.ilPluginDBUpdate.php.

Constructor & Destructor Documentation

__construct()

ilPluginDBUpdate::__construct	(		$a_ctype,
			$a_cname,
			$a_slot_id,
			$a_pname,
			$a_db_handler,
			$tmp_flag,
			$a_db_prefix
	)

constructor

Definition at line 15 of file class.ilPluginDBUpdate.php.

References $DIC, getCurrentVersion(), ilPlugin\getDBUpdateScriptName(), getFileForStep(), ilPluginSlot\lookupSlotName(), PATH, ilDBUpdate\readDBUpdateFile(), ilDBUpdate\readFileVersion(), and ilDBUpdate\readLastUpdateFile().

      {
        $this->db_prefix = $a_db_prefix;
        
        // workaround to allow setup migration
        if ($a_db_handler) {
            $this->db = $a_db_handler;
            
            if ($tmp_flag) {
                $this->PATH = "./";
            } else {
                $this->PATH = "../";
            }
        } else {
            global $DIC;
            $mySetup = $DIC['mySetup'];
            $this->db = $mySetup->db;
            $this->PATH = "./";
        }
        
        $this->ctype = $a_ctype;
        $this->cname = $a_cname;
        $this->slot_id = $a_slot_id;
        $this->pname = $a_pname;
        
        include_once("./Services/Component/classes/class.ilPluginSlot.php");
        $this->slot_name = ilPluginSlot::lookupSlotName(
            $this->ctype,
            $this->cname,
            $this->slot_id
        );
        
        $this->getCurrentVersion();
        
        // get update file for current version
        $updatefile = $this->getFileForStep($this->currentVersion + 1);

        $this->current_file = $updatefile;
        $this->DB_UPDATE_FILE = $this->PATH .
            ilPlugin::getDBUpdateScriptName(
                $this->ctype,
                $this->cname,
                $this->slot_name,
                $this->pname
            );

        //
        // NOTE: multiple update files for plugins are not supported yet
        //
        $this->LAST_UPDATE_FILE = $this->PATH .
            ilPlugin::getDBUpdateScriptName(
                $this->ctype,
                $this->cname,
                $this->slot_name,
                $this->pname
            );

        $this->readDBUpdateFile();
        $this->readLastUpdateFile();
        $this->readFileVersion();
    }

Here is the call graph for this function:

Member Function Documentation

_DBUpdate()

ilPluginDBUpdate::_DBUpdate

(

)

destructor

Returns

boolean

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

    {
        // this may be used in setup!?
//              $this->db->disconnect();
    }

checkQuery()

ilPluginDBUpdate::checkQuery

(

$q

)

This is a very simple check.

Could be done better.

Definition at line 145 of file class.ilPluginDBUpdate.php.

    {
        if ((is_int(stripos($q, "create table")) || is_int(stripos($q, "alter table")) ||
            is_int(stripos($q, "drop table")))
            && !is_int(stripos($q, $this->db_prefix))) {
            return "Plugin may only create or alter tables that use prefix " .
                $this->db_prefix;
        } else {
            return true;
        }
    }

getCurrentVersion()

ilPluginDBUpdate::getCurrentVersion

(

)

Get current DB version.

Definition at line 106 of file class.ilPluginDBUpdate.php.

References ilDBUpdate\$currentVersion.

Referenced by __construct().

    {
        $q = "SELECT db_version FROM il_plugin " .
            " WHERE component_type = " . $this->db->quote($this->ctype, "text") .
            " AND component_name = " . $this->db->quote($this->cname, "text") .
            " AND slot_id = " . $this->db->quote($this->slot_id, "text") .
            " AND name = " . $this->db->quote($this->pname, "text");
        $set = $this->db->query($q);
        $rec = $this->db->fetchAssoc($set);

        $this->currentVersion = (int) $rec["db_version"];

        return $this->currentVersion;
    }

Here is the caller graph for this function:

getFileForStep()

ilPluginDBUpdate::getFileForStep

(

$a_version

)

Get db update file name for db step.

Definition at line 87 of file class.ilPluginDBUpdate.php.

Referenced by __construct().

    {
        return "dbupdate.php";
    }

Here is the caller graph for this function:

loadXMLInfo()

ilPluginDBUpdate::loadXMLInfo

(

)

Definition at line 136 of file class.ilPluginDBUpdate.php.

    {
        // to do: reload control structure information for plugin
        return true;
    }

setCurrentVersion()

ilPluginDBUpdate::setCurrentVersion

(

$a_version

)

Set current DB version.

Definition at line 124 of file class.ilPluginDBUpdate.php.

    {
        $q = "UPDATE il_plugin SET db_version = " . $this->db->quote((int) $a_version, "integer") .
            " WHERE component_type = " . $this->db->quote($this->ctype, "text") .
            " AND component_name = " . $this->db->quote($this->cname, "text") .
            " AND slot_id = " . $this->db->quote($this->slot_id, "text") .
            " AND name = " . $this->db->quote($this->pname, "text");
        $this->db->manipulate($q);
        $this->currentVersion = $a_version;
        return true;
    }

---

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

• Services/Component/classes/class.ilPluginDBUpdate.php