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)
	Set Test Mode. More...

	getTestMode ()
	Get Test Mode. More...

	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="")
	Use abstract types as delivered by MDB2 to alter table and make it use only MDB2 known types. More...

	addPrimaryKey ($a_table, $a_pk)
	Add primary key. More...

	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

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 14 of file class.ilMySQLAbstraction.php.

Constructor & Destructor Documentation

◆ __construct()

ilMySQLAbstraction::__construct ( )

Constructor.

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

        {
                global $ilDB;
                
                $this->il_db = $ilDB;
                $this->manager = $ilDB->db->loadModule('Manager');
                $this->reverse = $ilDB->db->loadModule('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, 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 633 of file class.ilMySQLAbstraction.php.

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

Referenced by performAbstraction().

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 562 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->il_db->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 521 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->il_db->addIndex($a_table, $fields, strtolower($index["name"]), $index["fulltext"]);
                                        $cnt++;
                                }
                        }
                }
        }

Referenced by fixIndexNames(), and performAbstraction().

Here is the caller graph for this function:

◆ addPrimaryKey()

ilMySQLAbstraction::addPrimaryKey	(	$a_table,
		$a_pk
	)

Add primary key.

Parameters

string	table name
array	primary key information

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

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

Referenced by performAbstraction().

Here is the caller graph for this function:

◆ alterTable()

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

Use abstract types as delivered by MDB2 to alter table and make it use only MDB2 known types.

Parameters

string	table name
array	fields information

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

        {
                $n_fields = array();
                foreach ($a_fields as $field => $d)
                {
                        $def = $this->reverse->getTableFieldDefinition($a_table, $field);
                        $this->il_db->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
                        );
//var_dump($n_fields);
                if (!$this->getTestMode())
                {
                        $r = $this->manager->alterTable($a_table, $changes, false);
                }
                else
                {
                        $r = $this->manager->createTable(strtolower($a_table)."_copy", $n_fields);
                }
 
                if (MDB2::isError($r))
                {
                        //$err = "<br>Details: ".mysql_error();
                        var_dump($r);
                }
                else
                {
                        return $r;
                }
        }

References $d, $r, getTestMode(), and MDB2\isError().

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.

Definition at line 196 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 648 of file class.ilMySQLAbstraction.php.

        {
                if (!$this->il_db->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->il_db->modifyTableColumn($a_table, $name, array("type" => "clob", "notnull" => false));
                        }
                }
        }

◆ fixDatetimeValues()

ilMySQLAbstraction::fixDatetimeValues ( $a_table )

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

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

        {
                if (!$this->il_db->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->il_db->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->il_db->modifyTableColumn($a_table, $name, $nd);
                        }
                }
        }

References $nd.

◆ fixIndexNames()

ilMySQLAbstraction::fixIndexNames ( $a_table )

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

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

        {
                if (!$this->il_db->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->il_db->dropIndex($a_table, $index["name"]);
                        }
                        $this->addIndices($a_table, $indices);
                }
        }

References addIndices().

Here is the call graph for this function:

◆ getTestMode()

ilMySQLAbstraction::getTestMode ( )

Get Test Mode.

Returns: boolean Test Mode

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

        {
                return $this->testmode;
        }

Referenced by alterTable(), and performAbstraction().

Here is the caller graph for this function:

◆ lowerCaseColumnNames()

ilMySQLAbstraction::lowerCaseColumnNames ( $a_table_name )

lower case column names

Definition at line 304 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 table name

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

string table name

Definition at line 67 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)
                        {
                                die("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 325 of file class.ilMySQLAbstraction.php.

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

Referenced by performAbstraction().

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 370 of file class.ilMySQLAbstraction.php.

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

Referenced by performAbstraction().

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 353 of file class.ilMySQLAbstraction.php.

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

Referenced by performAbstraction().

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 339 of file class.ilMySQLAbstraction.php.

        {
                if ($a_pk["name"] != "")
                {
                        $this->il_db->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.

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

        {
                global $ilDB;
                
                if (!$this->il_db->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.

Referenced by performAbstraction().

Here is the caller graph for this function:

◆ replaceEmptyStringsWithNull()

ilMySQLAbstraction::replaceEmptyStringsWithNull ( $a_table )

Replace empty strings with null values.

Definition at line 220 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 )

Set Test Mode.

Parameters

boolean $a_testmode Test Mode

Definition at line 45 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.

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

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

Referenced by performAbstraction().

Here is the caller graph for this function:

Field Documentation

◆ $analyzer

ilMySQLAbstraction::$analyzer

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

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

Services/Database/classes/class.ilMySQLAbstraction.php

Public Member Functions

Data Fields

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