ilMySQLAbstraction Class Reference

This class includes methods that help to abstract ILIAS 3.10.x MySQL tables for the use with MDB2 abstraction layer and full compliance mode support. More...

Collaboration diagram for ilMySQLAbstraction:

Public Member Functions
	__construct ()
	Constructor. More...
	setTestMode ($a_testmode)
	getTestMode ()
	performAbstraction ($a_table_name, $a_set_text_ts_fields_notnull_false=true)
	Converts an existing (MySQL) ILIAS table in an abstract table. More...
	countRecords ($a_table_name)
	Check number of records before and after. More...
	storeStep ($a_table, $a_step)
	Store performed step. More...
	replaceEmptyStringsWithNull ($a_table)
	Replace empty strings with null values. More...
	replaceEmptyDatesWithNull ($a_table)
	Replace empty dates with null. More...
	lowerCaseTableName ($a_table_name)
	Lower case table and field names. More...
	lowerCaseColumnNames ($a_table_name)
	lower case column names More...
	removeAutoIncrement ($a_table_name, $a_auto_inc_field)
	Remove auto_increment attribute of a field. More...
	removePrimaryKey ($a_table, $a_pk)
	Remove primary key from table. More...
	removeIndices ($a_table, $a_indices)
	Remove Indices. More...
	removeConstraints ($a_table, $a_constraints)
	Remove Constraints. More...
	alterTable ($a_table, $a_fields, $a_set_text_ts_fields_notnull_false=true, $pk="")
	addPrimaryKey ($a_table, $a_pk)
	addIndices ($a_table, $a_indices)
	Add indices. More...
	addConstraints ($a_table, $a_constraints)
	Add constraints. More...
	fixIndexNames ($a_table)
	This is only used on tables that have already been abstracted but missed the "full treatment". More...
	addAutoIncrementSequence ($a_table, $a_auto_inc_field)
	Add autoincrement sequence. More...
	fixClobNotNull ($a_table)
	This is only used on tables that have already been abstracted but missed the "full treatment". More...
	fixDatetimeValues ($a_table)
	This is only used on tables that have already been abstracted but missed the "full treatment". More...

Data Fields
	$analyzer

Protected Attributes
	$ilDBInterface
	$manager
	$reverse
	$testmode

Detailed Description

This class includes methods that help to abstract ILIAS 3.10.x MySQL tables for the use with MDB2 abstraction layer and full compliance mode support.

Author

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

Version

Id

class.ilDBUpdate.php 18649 2009-01-21 09:59:23Z akill

Definition at line 12 of file class.ilMySQLAbstraction.php.

Constructor & Destructor Documentation

__construct()

ilMySQLAbstraction::__construct

(

)

Constructor.

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

    {
        global $ilDB;
 
        $this->ilDBInterface = $ilDB;
        $this->manager = $ilDB->loadModule(ilDBConstants::MODULE_MANAGER);
        $this->reverse = $ilDB->loadModule(ilDBConstants::MODULE_REVERSE);
        if (@is_file('../Services/Database/classes/class.ilDBAnalyzer.php')) {
            include_once '../Services/Database/classes/class.ilDBAnalyzer.php';
        } else {
            include_once './Services/Database/classes/class.ilDBAnalyzer.php';
        }
        $this->analyzer = new ilDBAnalyzer();
        $this->setTestMode(false);
    }

References $ilDB, ilDBConstants\MODULE_MANAGER, ilDBConstants\MODULE_REVERSE, and setTestMode().

Here is the call graph for this function:

Member Function Documentation

addAutoIncrementSequence()

ilMySQLAbstraction::addAutoIncrementSequence	(		$a_table,
			$a_auto_inc_field
	)

Add autoincrement sequence.

Parameters

string	table name
string	autoincrement field

Definition at line 601 of file class.ilMySQLAbstraction.php.

    {
        if ($a_auto_inc_field != "") {
            $set = $this->ilDBInterface->query("SELECT MAX(`" . strtolower($a_auto_inc_field) . "`) ma FROM `" . $a_table . "`");
            $rec = $this->ilDBInterface->fetchAssoc($set);
            $next = $rec["ma"] + 1;
            $this->ilDBInterface->createSequence($a_table, $next);
        }
    }

References ilDBInterface\createSequence(), ilDBInterface\fetchAssoc(), and ilDBInterface\query().

Referenced by performAbstraction().

Here is the call graph for this function:

Here is the caller graph for this function:

addConstraints()

ilMySQLAbstraction::addConstraints	(		$a_table,
			$a_constraints
	)

Add constraints.

Parameters

string	table name
array	constraints information

Definition at line 540 of file class.ilMySQLAbstraction.php.

    {
        if (is_array($a_constraints)) {
            $all_valid = true;
 
            foreach ($a_constraints as $c) {
                if (strlen($c["name"]) > 3) {
                    $all_valid = false;
                }
            }
 
            $cnt = 1;
            foreach ($a_constraints as $c) {
                if (is_array($c["fields"])) {
                    if (!$all_valid) {
                        $c["name"] = "c" . $cnt;
                    }
                    $fields = array();
                    foreach ($c["fields"] as $f => $pos) {
                        $fields[] = strtolower($f);
                    }
                    $this->ilDBInterface->addUniqueConstraint($a_table, $fields, strtolower($c["name"]));
                    $cnt++;
                }
            }
        }
    }

Referenced by performAbstraction().

Here is the caller graph for this function:

addIndices()

ilMySQLAbstraction::addIndices	(		$a_table,
			$a_indices
	)

Add indices.

Parameters

string	table name
array	indices information

Definition at line 505 of file class.ilMySQLAbstraction.php.

    {
        if (is_array($a_indices)) {
            $all_valid = true;
 
            foreach ($a_indices as $index) {
                if (strlen($index["name"]) > 3) {
                    $all_valid = false;
                }
            }
 
            $cnt = 1;
            foreach ($a_indices as $index) {
                if (is_array($index["fields"])) {
                    if (!$all_valid) {
                        $index["name"] = "i" . $cnt;
                    }
                    $fields = array();
                    foreach ($index["fields"] as $f => $pos) {
                        $fields[] = strtolower($f);
                    }
                    $this->ilDBInterface->addIndex($a_table, $fields, strtolower($index["name"]), $index["fulltext"]);
                    $cnt++;
                }
            }
        }
    }

References $index, and ilDBInterface\addIndex().

Referenced by fixIndexNames(), and performAbstraction().

Here is the call graph for this function:

Here is the caller graph for this function:

addPrimaryKey()

ilMySQLAbstraction::addPrimaryKey	(		$a_table,
			$a_pk
	)

Parameters

$a_table
$a_pk

Definition at line 487 of file class.ilMySQLAbstraction.php.

    {
        if (is_array($a_pk["fields"])) {
            $fields = array();
            foreach ($a_pk["fields"] as $f => $pos) {
                $fields[] = strtolower($f);
            }
            $this->ilDBInterface->addPrimaryKey($a_table, $fields);
        }
    }

References ilDBInterface\addPrimaryKey().

Referenced by performAbstraction().

Here is the call graph for this function:

Here is the caller graph for this function:

alterTable()

ilMySQLAbstraction::alterTable	(		$a_table,
			$a_fields,
			$a_set_text_ts_fields_notnull_false = true,
			$pk = ""
	)

Parameters

	$a_table
	$a_fields
bool	$a_set_text_ts_fields_notnull_false
string	$pk

Returns

mixed

Exceptions

ilDatabaseException

Definition at line 395 of file class.ilMySQLAbstraction.php.

    {
        $n_fields = array();
        foreach ($a_fields as $field => $d) {
            $def = $this->reverse->getTableFieldDefinition($a_table, $field);
            $this->ilDBInterface->handleError($def);
            $best_alt = $this->analyzer->getBestDefinitionAlternative($def);
            $def = $def[$best_alt];
 
            // remove "current_timestamp" default for timestamps (not supported)
            if (strtolower($def["nativetype"]) == "timestamp"
                && strtolower($def["default"]) == "current_timestamp"
            ) {
                unset($def["default"]);
            }
 
            if (strtolower($def["type"]) == "float") {
                unset($def["length"]);
            }
 
            // remove all invalid attributes
            foreach ($def as $k => $v) {
                if (!in_array($k, array( "type", "default", "notnull", "length", "unsigned", "fixed" ))) {
                    unset($def[$k]);
                }
            }
 
            // determine length for decimal type
            if ($def["type"] == "decimal") {
                $l_arr = explode(",", $def["length"]);
                $def["length"] = $l_arr[0];
            }
 
            // remove length values for float
            if ($def["type"] == "float") {
                unset($def["length"]);
            }
 
            // set notnull to false for text/timestamp/date fields
            if ($a_set_text_ts_fields_notnull_false
                && ($def["type"] == "text"
                    || $def["type"] == "timestamp"
                    || $def["type"] == "date")
                && (!is_array($pk) || !isset($field, $pk["fields"][$field]))
            ) {
                $def["notnull"] = false;
            }
 
            // set unsigned to false for integers
            if ($def["type"] == "integer") {
                $def["unsigned"] = false;
            }
 
            // set notnull to false for blob and clob
            if ($def["type"] == "blob" || $def["type"] == "clob") {
                $def["notnull"] = false;
            }
 
            // remove "0000-00-00..." default values
            if (($def["type"] == "timestamp" && $def["default"] == "0000-00-00 00:00:00")
                || ($def["type"] == "date" && $def["default"] == "0000-00-00")
            ) {
                unset($def["default"]);
            }
 
            $a = array();
            foreach ($def as $k => $v) {
                $a[$k] = $v;
            }
            $def["definition"] = $a;
 
            $n_fields[$field] = $def;
        }
 
        $changes = array(
            "change" => $n_fields,
        );
 
        if (!$this->getTestMode()) {
            $r = $this->manager->alterTable($a_table, $changes, false);
        } else {
            $r = $this->manager->createTable(strtolower($a_table) . "_copy", $n_fields);
        }
 
        return true;
    }

References $d, $def, $r, and getTestMode().

Referenced by performAbstraction().

Here is the call graph for this function:

Here is the caller graph for this function:

countRecords()

ilMySQLAbstraction::countRecords

(

$a_table_name

)

Check number of records before and after.

Parameters

string

$a_table_name

Returns

int

Definition at line 198 of file class.ilMySQLAbstraction.php.

    {
        global $ilDB;
 
        $st = $ilDB->prepare("SELECT count(*) AS cnt FROM `" . $a_table_name . "`");
        $res = $ilDB->execute($st);
        $rec = $ilDB->fetchAssoc($res);
 
        return $rec["cnt"];
    }

References $ilDB, and $res.

Referenced by performAbstraction().

Here is the caller graph for this function:

fixClobNotNull()

ilMySQLAbstraction::fixClobNotNull

(

$a_table

)

This is only used on tables that have already been abstracted but missed the "full treatment".

Definition at line 616 of file class.ilMySQLAbstraction.php.

    {
        if (!$this->ilDBInterface->tableExists($a_table)) {
            return;
        }
        $all_valid = true;
        $fields = $this->analyzer->getFieldInformation($a_table);
        foreach ($fields as $name => $def) {
            if ($def["type"] == "clob" && $def["notnull"] == true) {
                $this->ilDBInterface->modifyTableColumn($a_table, $name, array( "type" => "clob", "notnull" => false ));
            }
        }
    }

References $def, $name, ilDBInterface\modifyTableColumn(), and ilDBInterface\tableExists().

Here is the call graph for this function:

fixDatetimeValues()

ilMySQLAbstraction::fixDatetimeValues

(

$a_table

)

This is only used on tables that have already been abstracted but missed the "full treatment".

Definition at line 635 of file class.ilMySQLAbstraction.php.

    {
        if (!$this->ilDBInterface->tableExists($a_table)) {
            return;
        }
        $all_valid = true;
        $fields = $this->analyzer->getFieldInformation($a_table);
        foreach ($fields as $name => $def) {
            if ($def["type"] == "timestamp"
                && ($def["notnull"] == true || $def["default"] == "0000-00-00 00:00:00")
            ) {
                $nd = array( "type" => "timestamp", "notnull" => false );
                if ($def["default"] == "0000-00-00 00:00:00") {
                    $nd["default"] = null;
                }
                $this->ilDBInterface->modifyTableColumn($a_table, $name, $nd);
            }
            if ($def["type"] == "date"
                && ($def["notnull"] == true || $def["default"] == "0000-00-00")
            ) {
                $nd = array( "type" => "date", "notnull" => false );
                if ($def["default"] == "0000-00-00") {
                    $nd["default"] = null;
                }
                $this->ilDBInterface->modifyTableColumn($a_table, $name, $nd);
            }
        }
    }

References $def, $name, $nd, ilDBInterface\modifyTableColumn(), and ilDBInterface\tableExists().

Here is the call graph for this function:

fixIndexNames()

ilMySQLAbstraction::fixIndexNames

(

$a_table

)

This is only used on tables that have already been abstracted but missed the "full treatment".

Definition at line 573 of file class.ilMySQLAbstraction.php.

    {
        if (!$this->ilDBInterface->tableExists($a_table)) {
            return;
        }
        $all_valid = true;
        $indices = $this->analyzer->getIndicesInformation($a_table);
        foreach ($indices as $index) {
            if (strlen($index["name"]) > 3) {
                $all_valid = false;
            }
        }
 
        if (!$all_valid) {
            foreach ($indices as $index) {
                $this->ilDBInterface->dropIndex($a_table, $index["name"]);
            }
            $this->addIndices($a_table, $indices);
        }
    }

References $index, addIndices(), ilDBInterface\dropIndex(), and ilDBInterface\tableExists().

Here is the call graph for this function:

getTestMode()

ilMySQLAbstraction::getTestMode

(

)

Returns

bool

Definition at line 69 of file class.ilMySQLAbstraction.php.

    {
        return $this->testmode;
    }

References $testmode.

Referenced by alterTable(), and performAbstraction().

Here is the caller graph for this function:

lowerCaseColumnNames()

ilMySQLAbstraction::lowerCaseColumnNames

(

$a_table_name

)

lower case column names

Parameters

string

$a_table_name

Definition at line 312 of file class.ilMySQLAbstraction.php.

    {
        global $ilDB;
 
        $result = mysql_query("SHOW COLUMNS FROM `" . $a_table_name . "`");
        while ($row = mysql_fetch_assoc($result)) {
            if ($row["Field"] != strtolower($row["Field"])) {
                $ilDB->renameTableColumn($a_table_name, $row["Field"], strtolower($row["Field"]));
            }
        }
    }

References $ilDB, $result, and $row.

Referenced by performAbstraction().

Here is the caller graph for this function:

lowerCaseTableName()

ilMySQLAbstraction::lowerCaseTableName

(

$a_table_name

)

Lower case table and field names.

Parameters

string

$a_table_name

Definition at line 294 of file class.ilMySQLAbstraction.php.

    {
        global $ilDB;
 
        if ($a_table_name != strtolower($a_table_name)) {
            // this may look strange, but it does not work directly
            // (seems that mysql does not see no difference whether upper or lowercase characters are used
            mysql_query("ALTER TABLE `" . $a_table_name . "` RENAME `" . strtolower($a_table_name) . "xxx" . "`");
            mysql_query("ALTER TABLE `" . strtolower($a_table_name) . "xxx" . "` RENAME `" . strtolower($a_table_name) . "`");
        }
    }

References $ilDB.

Referenced by performAbstraction().

Here is the caller graph for this function:

performAbstraction()

ilMySQLAbstraction::performAbstraction	(		$a_table_name,
			$a_set_text_ts_fields_notnull_false = true
	)

Converts an existing (MySQL) ILIAS table in an abstract table.

This means the table conforms to the MDB2 field types, uses sequences instead of auto_increment.

Parameters

$a_table_name

string

Definition at line 82 of file class.ilMySQLAbstraction.php.

    {
        // to do: log this procedure
 
        // count number of records at the beginning
        $nr_rec = $this->countRecords($a_table_name);
 
        // convert table name to lowercase
        if (!$this->getTestMode()) {
            $this->lowerCaseTableName($a_table_name);
            $a_table_name = strtolower($a_table_name);
            $this->storeStep($a_table_name, 10);
        }
 
        // get auto increment information
        $auto_inc_field = $this->analyzer->getAutoIncrementField($a_table_name);
 
        // get primary key information
        $pk = $this->analyzer->getPrimaryKeyInformation($a_table_name);
 
        // get indices information
        $indices = $this->analyzer->getIndicesInformation($a_table_name);
 
        // get constraints information
        $constraints = $this->analyzer->getConstraintsInformation($a_table_name);
 
        // get field information
        $fields = $this->analyzer->getFieldInformation($a_table_name);
 
        if (!$this->getTestMode()) {
            // remove auto increment
            $this->removeAutoIncrement($a_table_name, $auto_inc_field, $fields);
            $this->storeStep($a_table_name, 20);
 
            // remove primary key
            $this->removePrimaryKey($a_table_name, $pk);
            $this->storeStep($a_table_name, 30);
 
            // remove indices
            $this->removeIndices($a_table_name, $indices);
            $this->storeStep($a_table_name, 40);
 
            // remove constraints
            $this->removeConstraints($a_table_name, $constraints);
            $this->storeStep($a_table_name, 45);
        }
 
        // alter table using mdb2 field types
        $this->alterTable($a_table_name, $fields, $a_set_text_ts_fields_notnull_false, $pk);
        if ($this->getTestMode()) {
            $a_table_name = strtolower($a_table_name) . "_copy";
        } else {
            $this->storeStep($a_table_name, 50);
        }
 
        // lower case field names
        $this->lowerCaseColumnNames($a_table_name);
        if (!$this->getTestMode()) {
            $this->storeStep($a_table_name, 60);
        }
 
        // add primary key
        $this->addPrimaryKey($a_table_name, $pk);
        if (!$this->getTestMode()) {
            $this->storeStep($a_table_name, 70);
        }
 
        // add indices
        $this->addIndices($a_table_name, $indices);
        if (!$this->getTestMode()) {
            $this->storeStep($a_table_name, 80);
        }
 
        // add constraints
        $this->addConstraints($a_table_name, $constraints);
        if (!$this->getTestMode()) {
            $this->storeStep($a_table_name, 85);
        }
 
        // add "auto increment" sequence
        if ($auto_inc_field != "") {
            $this->addAutoIncrementSequence($a_table_name, $auto_inc_field);
        }
        if (!$this->getTestMode()) {
            $this->storeStep($a_table_name, 90);
        }
 
        // replace empty strings with null values in text fields
        $this->replaceEmptyStringsWithNull($a_table_name);
        if (!$this->getTestMode()) {
            $this->storeStep($a_table_name, 100);
        }
 
        // replace empty "0000-00-00..." dates with null
        $this->replaceEmptyDatesWithNull($a_table_name);
        if (!$this->getTestMode()) {
            $this->storeStep($a_table_name, 110);
        }
 
        $nr_rec2 = $this->countRecords($a_table_name);
 
        if (!$this->getTestMode()) {
            if ($nr_rec != $nr_rec2) {
                throw new ilDatabaseException("ilMySQLAbstraction: Unexpected difference in table record number, table '" . $a_table_name . "'."
                                              . " Before: " . ((int) $nr_rec) . ", After: " . ((int) $nr_rec2) . ".");
            }
        }
    }

References addAutoIncrementSequence(), addConstraints(), addIndices(), addPrimaryKey(), alterTable(), countRecords(), getTestMode(), lowerCaseColumnNames(), lowerCaseTableName(), removeAutoIncrement(), removeConstraints(), removeIndices(), removePrimaryKey(), replaceEmptyDatesWithNull(), replaceEmptyStringsWithNull(), and storeStep().

Here is the call graph for this function:

removeAutoIncrement()

ilMySQLAbstraction::removeAutoIncrement	(		$a_table_name,
			$a_auto_inc_field
	)

Remove auto_increment attribute of a field.

Parameters

string	table name
string	autoincrement field

Definition at line 331 of file class.ilMySQLAbstraction.php.

    {
        if ($a_auto_inc_field != "") {
            $this->ilDBInterface->modifyTableColumn($a_table_name, $a_auto_inc_field, array());
        }
    }

References ilDBInterface\modifyTableColumn().

Referenced by performAbstraction().

Here is the call graph for this function:

Here is the caller graph for this function:

removeConstraints()

ilMySQLAbstraction::removeConstraints	(		$a_table,
			$a_constraints
	)

Remove Constraints.

Parameters

string	table name
array	constraints information

Definition at line 375 of file class.ilMySQLAbstraction.php.

    {
        if (is_array($a_constraints)) {
            foreach ($a_constraints as $c) {
                if ($c["type"] == "unique") {
                    $this->ilDBInterface->query("ALTER TABLE `" . $a_table . "` DROP INDEX `" . $c["name"] . "`");
                }
            }
        }
    }

References ilDBInterface\query().

Referenced by performAbstraction().

Here is the call graph for this function:

Here is the caller graph for this function:

removeIndices()

ilMySQLAbstraction::removeIndices	(		$a_table,
			$a_indices
	)

Remove Indices.

Parameters

string	table name
array	indices information

Definition at line 359 of file class.ilMySQLAbstraction.php.

    {
        if (is_array($a_indices)) {
            foreach ($a_indices as $index) {
                $this->ilDBInterface->query("ALTER TABLE `" . $a_table . "` DROP INDEX `" . $index["name"] . "`");
            }
        }
    }

References $index, and ilDBInterface\query().

Referenced by performAbstraction().

Here is the call graph for this function:

Here is the caller graph for this function:

removePrimaryKey()

ilMySQLAbstraction::removePrimaryKey	(		$a_table,
			$a_pk
	)

Remove primary key from table.

Parameters

string	table name
array	primary key information

Definition at line 345 of file class.ilMySQLAbstraction.php.

    {
        if ($a_pk["name"] != "") {
            $this->ilDBInterface->dropPrimaryKey($a_table, $a_pk["name"]);
        }
    }

Referenced by performAbstraction().

Here is the caller graph for this function:

replaceEmptyDatesWithNull()

ilMySQLAbstraction::replaceEmptyDatesWithNull

(

$a_table

)

Replace empty dates with null.

Parameters

$a_table

Exceptions

ilDatabaseException

Definition at line 257 of file class.ilMySQLAbstraction.php.

    {
        global $ilDB;
 
        if (!$this->ilDBInterface->tableExists($a_table)) {
            return;
        }
 
        $fields = $this->analyzer->getFieldInformation($a_table);
        $upfields = array();
        foreach ($fields as $field => $def) {
            if ($def["type"] == "timestamp") {
                $upfields[] = $field;
            }
        }
        foreach ($upfields as $uf) {
            $ilDB->query("UPDATE `" . $a_table . "` SET `" . $uf . "` = null WHERE `" . $uf . "` = '0000-00-00 00:00:00'");
        }
 
        $upfields = array();
        reset($fields);
        foreach ($fields as $field => $def) {
            if ($def["type"] == "date") {
                $upfields[] = $field;
            }
        }
        foreach ($upfields as $uf) {
            $ilDB->query("UPDATE `" . $a_table . "` SET `" . $uf . "` = null WHERE `" . $uf . "` = '0000-00-00'");
        }
    }

References $def, $ilDB, and ilDBInterface\tableExists().

Referenced by performAbstraction().

Here is the call graph for this function:

Here is the caller graph for this function:

replaceEmptyStringsWithNull()

ilMySQLAbstraction::replaceEmptyStringsWithNull

(

$a_table

)

Replace empty strings with null values.

Parameters

$a_table

Exceptions

ilDatabaseException

Definition at line 232 of file class.ilMySQLAbstraction.php.

    {
        global $ilDB;
 
        $fields = $this->analyzer->getFieldInformation($a_table);
        $upfields = array();
        foreach ($fields as $field => $def) {
            if ($def["type"] == "text"
                && ($def["length"] >= 1 && $def["length"] <= 4000)
            ) {
                $upfields[] = $field;
            }
        }
        foreach ($upfields as $uf) {
            $ilDB->query("UPDATE `" . $a_table . "` SET `" . $uf . "` = null WHERE `" . $uf . "` = ''");
        }
    }

References $def, and $ilDB.

Referenced by performAbstraction().

Here is the caller graph for this function:

setTestMode()

ilMySQLAbstraction::setTestMode

(

$a_testmode

)

Parameters

$a_testmode

Definition at line 60 of file class.ilMySQLAbstraction.php.

    {
        $this->testmode = $a_testmode;
    }

Referenced by __construct().

Here is the caller graph for this function:

storeStep()

ilMySQLAbstraction::storeStep	(		$a_table,
			$a_step
	)

Store performed step.

Parameters

$a_table
$a_step

Definition at line 216 of file class.ilMySQLAbstraction.php.

    {
        $st = $this->ilDBInterface->prepareManip("REPLACE INTO abstraction_progress (table_name, step)" . " VALUES (?,?)", array(
            "text",
            "integer",
        ));
        $this->ilDBInterface->execute($st, array( $a_table, $a_step ));
    }

References ilDBInterface\execute(), and ilDBInterface\prepareManip().

Referenced by performAbstraction().

Here is the call graph for this function:

Here is the caller graph for this function:

Field Documentation

$analyzer

ilMySQLAbstraction::$analyzer

Definition at line 18 of file class.ilMySQLAbstraction.php.

$ilDBInterface

ilMySQLAbstraction::$ilDBInterface

protected

Definition at line 22 of file class.ilMySQLAbstraction.php.

$manager

ilMySQLAbstraction::$manager

protected

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

$reverse

ilMySQLAbstraction::$reverse

protected

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

$testmode

ilMySQLAbstraction::$testmode

protected

Definition at line 34 of file class.ilMySQLAbstraction.php.

Referenced by getTestMode().

---

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

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