ilPluginDBUpdate Class Reference

Database Update class. More...

Inheritance diagram for ilPluginDBUpdate:

Collaboration diagram for ilPluginDBUpdate:

Public Member Functions
	ilPluginDBUpdate ($a_ctype, $a_cname, $a_slot_id, $a_pname, $a_db_handler, $tmp_flag, $a_db_prefix)
	constructor
	getFileForStep ($a_version)
	Get db update file name for db step.
	_DBUpdate ()
	destructor
	getCurrentVersion ()
	Get current DB version.
	setCurrentVersion ($a_version)
	Set current DB version.
	loadXMLInfo ()
	checkQuery ($q)
	This is a very simple check.
Public Member Functions inherited from ilDBUpdate
	ilDBUpdate ($a_db_handler=0, $tmp_flag=false)
	constructor
	readDBUpdateFile ()
	readLastUpdateFile ()
	readFileVersion ()
	getFileVersion ()
	Get Version of file.
	execQuery ($db, $str)
	execute a query
	applyUpdate ()
	Apply update.
	applyUpdateNr ($nr)
	apply an update
	getDBVersionStatus ()
	getTables ()
	getTableStatus ($table)
	optimizeTables ($tables)

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

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 32 of file class.ilPluginDBUpdate.php.

Member Function Documentation

ilPluginDBUpdate::_DBUpdate

(

)

destructor

Returns

boolean

Reimplemented from ilDBUpdate.

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

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

ilPluginDBUpdate::checkQuery

(

$q

)

This is a very simple check.

Could be done better.

Reimplemented from ilDBUpdate.

Definition at line 155 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 start with prefix ".
                                $this->db_prefix;
                }
                else
                {
                        return true;
                }
        }

ilPluginDBUpdate::getCurrentVersion

(

)

Get current DB version.

Reimplemented from ilDBUpdate.

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

References ilDBUpdate\$currentVersion, and DB_FETCHMODE_ASSOC.

Referenced by ilPluginDBUpdate().

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

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

                return $this->currentVersion;
        }

Here is the caller graph for this function:

ilPluginDBUpdate::getFileForStep

(

$a_version

)

Get db update file name for db step.

Reimplemented from ilDBUpdate.

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

Referenced by ilPluginDBUpdate().

        {
                return "dbupdate.php";
        }

Here is the caller graph for this function:

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

constructor

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

References getCurrentVersion(), ilPlugin\getDBUpdateScriptName(), getFileForStep(), ilPluginSlot\lookupSlotName(), 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 $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:

ilPluginDBUpdate::loadXMLInfo

(

)

Reimplemented from ilDBUpdate.

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

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

ilPluginDBUpdate::setCurrentVersion

(

$a_version

)

Set current DB version.

Reimplemented from ilDBUpdate.

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

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

---

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

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