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.

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

                                       {
                 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);
         }

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.

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

Referenced by performAbstraction().

                                                                               {
                 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);
                 }
         }

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.

References array.

Referenced by performAbstraction().

                                                                  {
                 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 ++;
                                 }
                         }
                 }
         }

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.

References ilDBInterface\addIndex(), and array.

Referenced by fixIndexNames(), and performAbstraction().

                                                          {
                 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 ++;
                                 }
                         }
                 }
         }

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.

References ilDBInterface\addPrimaryKey(), and array.

Referenced by performAbstraction().

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

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

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

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

Referenced by performAbstraction().

                                                                                                               {
                 $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;
         }

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.

References $ilDB, and $res.

Referenced by performAbstraction().

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

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.

References array, ilDBInterface\modifyTableColumn(), and ilDBInterface\tableExists().

                                                  {
                 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 ));
                         }
                 }
         }

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.

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

                                                     {
                 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);
                         }
                 }
         }

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.

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

                                                 {
                 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);
                 }
         }

Here is the call graph for this function:

◆ getTestMode()

ilMySQLAbstraction::getTestMode ( )

Returns: bool

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

References $testmode.

Referenced by alterTable(), and performAbstraction().

                                       {
                 return $this->testmode;
         }

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.

References $ilDB, $result, and $row.

Referenced by performAbstraction().

                                                             {
                 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"]));
                         }
                 }
         }

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.

References $ilDB.

Referenced by performAbstraction().

                                                           {
                 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) . "`");
                 }
         }

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.

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

                                                                                                       {
                 // 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) . ".");
                         }
                 }
         }

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.

References array, and ilDBInterface\modifyTableColumn().

Referenced by performAbstraction().

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

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.

References ilDBInterface\query().

Referenced by performAbstraction().

                                                                     {
                 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"] . "`");
                                 }
                         }
                 }
         }

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.

References ilDBInterface\query().

Referenced by performAbstraction().

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

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.

Referenced by performAbstraction().

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

Here is the caller graph for this function:

◆ replaceEmptyDatesWithNull()

ilMySQLAbstraction::replaceEmptyDatesWithNull ( $a_table )

Replace empty dates with null.

Parameters

$a_table

Exceptions

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

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

Referenced by performAbstraction().

                                                             {
                 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'");
                 }
         }

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

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

References $ilDB, and array.

Referenced by performAbstraction().

                                                               {
                 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 . "` = ''");
                 }
         }

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.

Referenced by __construct().

                                                  {
                 $this->testmode = $a_testmode;
         }

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.

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

Referenced by performAbstraction().

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

Here is the call graph for this function:

Here is the caller graph for this function:

Field Documentation

◆ $analyzer

ilMySQLAbstraction::$analyzer

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

◆ $ilDBInterface

ilMySQLAbstraction::$ilDBInterface

protected

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

◆ $manager

ilMySQLAbstraction::$manager

protected

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

◆ $reverse

ilMySQLAbstraction::$reverse

protected

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

◆ $testmode

ilMySQLAbstraction::$testmode

protected

Definition at line 33 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

Public Member Functions

Data Fields

Protected Attributes

Detailed Description

Constructor & Destructor Documentation

◆ __construct()

Member Function Documentation

◆ addAutoIncrementSequence()

◆ addConstraints()

◆ addIndices()

◆ addPrimaryKey()

◆ alterTable()

◆ countRecords()

◆ fixClobNotNull()

◆ fixDatetimeValues()

◆ fixIndexNames()

◆ getTestMode()

◆ lowerCaseColumnNames()

◆ lowerCaseTableName()

◆ performAbstraction()

◆ removeAutoIncrement()

◆ removeConstraints()

◆ removeIndices()

◆ removePrimaryKey()

◆ replaceEmptyDatesWithNull()

◆ replaceEmptyStringsWithNull()

◆ setTestMode()

◆ storeStep()

Field Documentation

◆ $analyzer

◆ $ilDBInterface

◆ $manager

◆ $reverse

◆ $testmode