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 39 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 581 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 522 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 488 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 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 471 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 380 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, $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 193 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 595 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 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 613 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 $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 554 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 addIndices(), ilDBInterface\dropIndex(), and ilDBInterface\tableExists().

Here is the call graph for this function:

◆ getTestMode()

ilMySQLAbstraction::getTestMode ( )

Returns: bool

Definition at line 66 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 302 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 285 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 78 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 320 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 361 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 346 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 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 333 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 249 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 $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 225 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 $ilDB.

Referenced by performAbstraction().

Here is the caller graph for this function:

◆ setTestMode()

ilMySQLAbstraction::setTestMode ( $a_testmode )

Parameters

$a_testmode

Definition at line 58 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 210 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 ));
        }