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 $DIC;
        $ilDB = $DIC->database();
 
        $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 $DIC, $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 636 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 575 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++;
                }
            }
        }
    }

References $c, and $f.

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 540 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 $f, $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 522 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 $f, and 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 419 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 205 of file class.ilMySQLAbstraction.php.

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

References $DIC, $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 651 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 677 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 608 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 70 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 334 of file class.ilMySQLAbstraction.php.

    {
        global $DIC;
        $ilDB = $DIC->database();
 
        $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 $DIC, $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 315 of file class.ilMySQLAbstraction.php.

    {
        global $DIC;
        $ilDB = $DIC->database();
 
        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 $DIC, and $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

string	$a_table_name	string
bool	$a_set_text_ts_fields_notnull_false

Exceptions

ilDatabaseException

Definition at line 87 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 354 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 398 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 $c, and 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 382 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 368 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 277 of file class.ilMySQLAbstraction.php.

    {
        global $DIC;
        $ilDB = $DIC->database();
 
        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, $DIC, $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 250 of file class.ilMySQLAbstraction.php.

    {
        global $DIC;
        $ilDB = $DIC->database();
 
        $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, $DIC, and $ilDB.

Referenced by performAbstraction().

Here is the caller graph for this function:

setTestMode()

ilMySQLAbstraction::setTestMode

(

$a_testmode

)

Parameters

$a_testmode

Definition at line 61 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 224 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