This class provides methods for building a DB generation script, getting a full overview on abstract table definitions and more... More...

Collaboration diagram for ilDBGenerator:

Public Member Functions
	__construct ()
	Constructor. More...

	setTargetEncoding ($a_encoding)
	Set the desired target encoding If the target encoding os different from UTF-8 all text values will be shortened to length of of the current text field. More...

	getTargetEncoding ()
	Returns the target encoding. More...

	setBlackList ($a_blacklist)
	Set Table Black List. More...

	getBlackList ()
	Get Table Black List. More...

	setWhiteList ($a_whitelist)
	Set Table White List. More...

	getWhiteList ()
	Get Table White List. More...

	setFilter ($a_filter, $a_value)

	getTables ()

	checkProcessing ($a_table)
	Check whether a table should be processed or not. More...

	buildDBGenerationScript ($a_filename="")
	Build DB generation script. More...

	buildCreateTableStatement ($a_table, $a_file="")
	Build CreateTable statement. More...

	buildAddPrimaryKeyStatement ($a_table, $a_file="")
	Build AddPrimaryKey statement. More...

	buildAddIndexStatements ($a_table, $a_file="")
	Build AddIndex statements. More...

	buildAddUniqueConstraintStatements ($a_table, $a_file="")
	Build AddUniqueConstraint statements. More...

	buildCreateSequenceStatement ($a_table, $a_file="")
	Build CreateSequence statement. More...

	buildSingularSequenceStatement ($a_file="")
	Build CreateSequence statement (if not belonging to table) More...

	buildInsertStatement ($a_table, $a_basedir)
	Write seerialized insert data to array. More...

	buildInsertStatementsXML ($a_table, $a_basedir)

	buildInsertStatements ($a_table, $a_file="")
	Build Insert statements. More...

	getHTMLOverview ($a_filename="")
	Get table definition overview in HTML. More...

	addTableToOverview ($a_table, $a_tpl, $a_cnt)
	Add table to overview template. More...

Static Public Member Functions
static	lookupAbstractedTables ()

Protected Member Functions
	openFile ($a_path)

	closeFile ($fp)

	shortenText ($table, $field, $a_value, $a_size)
	Shorten text depending on target encoding. More...

Protected Attributes
	$target_encoding = 'UTF-8'

	$whitelist = array()

	$blacklist = array()

	$tables = array()

	$filter = array()

Detailed Description

This class provides methods for building a DB generation script, getting a full overview on abstract table definitions and more...

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 13 of file class.ilDBGenerator.php.

Constructor & Destructor Documentation

◆ __construct()

ilDBGenerator::__construct ( )

Constructor.

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

References $ilDB, ilDBConstants\MODULE_MANAGER, and ilDBConstants\MODULE_REVERSE.

                                       {
                 global $ilDB;
 
                 $this->manager = $ilDB->loadModule(ilDBConstants::MODULE_MANAGER);
                 $this->reverse = $ilDB->loadModule(ilDBConstants::MODULE_REVERSE);
                 $this->il_db = $ilDB;
                 include_once("./Services/Database/classes/class.ilDBAnalyzer.php");
                 $this->analyzer = new ilDBAnalyzer();
 
                 $this->allowed_attributes = $ilDB->getAllowedAttributes();
         }

Member Function Documentation

◆ addTableToOverview()

ilDBGenerator::addTableToOverview	(	$a_table,
		$a_tpl,
		$a_cnt
	)

Add table to overview template.

Definition at line 729 of file class.ilDBGenerator.php.

References array.

Referenced by getHTMLOverview().

                                                                      {
                 $fields = $this->analyzer->getFieldInformation($a_table);
                 $indices = $this->analyzer->getIndicesInformation($a_table);
                 $constraints = $this->analyzer->getConstraintsInformation($a_table);
                 $pk = $this->analyzer->getPrimaryKeyInformation($a_table);
                 $auto = $this->analyzer->getAutoIncrementField($a_table);
                 $has_sequence = $this->analyzer->hasSequence($a_table);
 
                 // table filter
                 if (isset($this->filter["has_sequence"])) {
                         if ((!$has_sequence && $auto == "" && $this->filter["has_sequence"])
                             || (($has_sequence || $auto != "") && !$this->filter["has_sequence"])
                         ) {
                                 return false;
                         }
                 }
 
                 // indices
                 $indices_output = false;
                 if (is_array($indices) && count($indices) > 0 && !$this->filter["skip_indices"]) {
                         foreach ($indices as $index => $def) {
                                 $f2 = array();
                                 foreach ($def["fields"] as $f => $pos) {
                                         $f2[] = $f;
                                 }
                                 $a_tpl->setCurrentBlock("index");
                                 $a_tpl->setVariable("VAL_INDEX", $def["name"]);
                                 $a_tpl->setVariable("VAL_FIELDS", implode($f2, ", "));
                                 $a_tpl->parseCurrentBlock();
                                 $indices_output = true;
                         }
                         $a_tpl->setCurrentBlock("index_table");
                         $a_tpl->parseCurrentBlock();
                 }
 
                 // constraints
                 $constraints_output = false;
                 if (is_array($constraints) && count($constraints) > 0 && !$this->filter["skip_constraints"]) {
                         foreach ($constraints as $index => $def) {
                                 $f2 = array();
                                 foreach ($def["fields"] as $f => $pos) {
                                         $f2[] = $f;
                                 }
                                 $a_tpl->setCurrentBlock("constraint");
                                 $a_tpl->setVariable("VAL_CONSTRAINT", $def["name"]);
                                 $a_tpl->setVariable("VAL_CTYPE", $def["type"]);
                                 $a_tpl->setVariable("VAL_CFIELDS", implode($f2, ", "));
                                 $a_tpl->parseCurrentBlock();
                                 $constraints_output = true;
                         }
                         $a_tpl->setCurrentBlock("constraint_table");
                         $a_tpl->parseCurrentBlock();
                 }
 
                 // fields
                 $fields_output = false;
                 foreach ($fields as $field => $def) {
                         // field filter
                         if (isset($this->filter["alt_types"])) {
                                 if (($def["alt_types"] == "" && $this->filter["alt_types"])
                                     || ($def["alt_types"] != "" && !$this->filter["alt_types"])
                                 ) {
                                         continue;
                                 }
                         }
                         if (isset($this->filter["type"])) {
                                 if ($def["type"] != $this->filter["type"]) {
                                         continue;
                                 }
                         }
                         if (isset($this->filter["nativetype"])) {
                                 if ($def["nativetype"] != $this->filter["nativetype"]) {
                                         continue;
                                 }
                         }
                         if (isset($this->filter["unsigned"])) {
                                 if ($def["unsigned"] != $this->filter["unsigned"]) {
                                         continue;
                                 }
                         }
 
                         $a_tpl->setCurrentBlock("field");
                         if (empty($pk["fields"][$field])) {
                                 $a_tpl->setVariable("VAL_FIELD", strtolower($field));
                         } else {
                                 $a_tpl->setVariable("VAL_FIELD", "<u>" . strtolower($field) . "</u>");
                         }
                         $a_tpl->setVariable("VAL_TYPE", $def["type"]);
                         $a_tpl->setVariable("VAL_LENGTH", (!is_null($def["length"])) ? $def["length"] : "&nbsp;");
 
                         if (strtolower($def["default"]) == "current_timestamp") {
                                 //$def["default"] = "0000-00-00 00:00:00";
                                 unset($def["default"]);
                         }
 
                         $a_tpl->setVariable("VAL_DEFAULT", (!is_null($def["default"])) ? $def["default"] : "&nbsp;");
                         $a_tpl->setVariable("VAL_NOT_NULL", (!is_null($def["notnull"])) ? (($def["notnull"]) ? "true" : "false") : "&nbsp;");
                         $a_tpl->setVariable("VAL_FIXED", (!is_null($def["fixed"])) ? (($def["fixed"]) ? "true" : "false") : "&nbsp;");
                         $a_tpl->setVariable("VAL_UNSIGNED", (!is_null($def["unsigned"])) ? (($def["unsigned"]) ? "true" : "false") : "&nbsp;");
                         $a_tpl->setVariable("VAL_ALTERNATIVE_TYPES", ($def["alt_types"] != "") ? $def["alt_types"] : "&nbsp;");
                         $a_tpl->setVariable("VAL_NATIVETYPE", ($def["nativetype"] != "") ? $def["nativetype"] : "&nbsp;");
                         $a_tpl->parseCurrentBlock();
                         $fields_output = true;
                 }
 
                 if ($fields_output) {
                         $a_tpl->setCurrentBlock("field_table");
                         $a_tpl->parseCurrentBlock();
                 }
 
                 // table information
                 if ($indices_output || $fields_output || $constraints_output) {
                         $a_tpl->setCurrentBlock("table");
                         $a_tpl->setVariable("TXT_TABLE_NAME", strtolower($a_table));
                         if ($has_sequence || $auto != "") {
                                 $a_tpl->setVariable("TXT_SEQUENCE", "Has Sequence");
                         } else {
                                 $a_tpl->setVariable("TXT_SEQUENCE", "No Sequence");
                         }
                         $a_tpl->setVariable("VAL_CNT", (int)$a_cnt);
                         $a_tpl->parseCurrentBlock();
 
                         return true;
                 }
 
                 return false;
         }

Here is the caller graph for this function:

◆ buildAddIndexStatements()

ilDBGenerator::buildAddIndexStatements	(	$a_table,
		$a_file = `""`
	)

Build AddIndex statements.

Parameters

string	table name
file	file resource or empty string

Definition at line 446 of file class.ilDBGenerator.php.

Referenced by buildDBGenerationScript().

                                                                         {
                 $ind = $this->analyzer->getIndicesInformation($a_table, true);
 
                 if (is_array($ind)) {
                         foreach ($ind as $i) {
                                 if ($i["fulltext"]) {
                                         $ft = ", true";
                                 } else {
                                         $ft = ", false";
                                 }
                                 $in_st = "\n" . '$in_fields = array(';
                                 $sep = "";
                                 foreach ($i["fields"] as $f => $pos) {
                                         $in_st .= $sep . '"' . $f . '"';
                                         $sep = ",";
                                 }
                                 $in_st .= ");\n";
                                 $in_st .= '$ilDB->addIndex("' . $a_table . '", $in_fields, "' . $i["name"] . '"' . $ft . ');' . "\n";
 
                                 if ($a_file == "") {
                                         echo $in_st;
                                 } else {
                                         fwrite($a_file, $in_st);
                                 }
                         }
                 }
         }

Here is the caller graph for this function:

◆ buildAddPrimaryKeyStatement()

ilDBGenerator::buildAddPrimaryKeyStatement	(	$a_table,
		$a_file = `""`
	)

Build AddPrimaryKey statement.

Parameters

string	table name
file	file resource or empty string

Definition at line 418 of file class.ilDBGenerator.php.

Referenced by buildDBGenerationScript().

                                                                             {
                 $pk = $this->analyzer->getPrimaryKeyInformation($a_table);
 
                 if (is_array($pk["fields"]) && count($pk["fields"]) > 0) {
                         $pk_st = "\n" . '$pk_fields = array(';
                         $sep = "";
                         foreach ($pk["fields"] as $f => $pos) {
                                 $pk_st .= $sep . '"' . $f . '"';
                                 $sep = ",";
                         }
                         $pk_st .= ");\n";
                         $pk_st .= '$ilDB->addPrimaryKey("' . $a_table . '", $pk_fields);' . "\n";
 
                         if ($a_file == "") {
                                 echo $pk_st;
                         } else {
                                 fwrite($a_file, $pk_st);
                         }
                 }
         }

Here is the caller graph for this function:

◆ buildAddUniqueConstraintStatements()

ilDBGenerator::buildAddUniqueConstraintStatements	(	$a_table,
		$a_file = `""`
	)

Build AddUniqueConstraint statements.

Parameters

string	table name
file	file resource or empty string

Definition at line 481 of file class.ilDBGenerator.php.

Referenced by buildDBGenerationScript().

                                                                                    {
                 $con = $this->analyzer->getConstraintsInformation($a_table, true);
 
                 if (is_array($con)) {
                         foreach ($con as $i) {
                                 $in_st = "\n" . '$in_fields = array(';
                                 $sep = "";
                                 foreach ($i["fields"] as $f => $pos) {
                                         $in_st .= $sep . '"' . $f . '"';
                                         $sep = ",";
                                 }
                                 $in_st .= ");\n";
                                 $in_st .= '$ilDB->addUniqueConstraint("' . $a_table . '", $in_fields, "' . $i["name"] . '");' . "\n";
 
                                 if ($a_file == "") {
                                         echo $in_st;
                                 } else {
                                         fwrite($a_file, $in_st);
                                 }
                         }
                 }
         }

Here is the caller graph for this function:

◆ buildCreateSequenceStatement()

ilDBGenerator::buildCreateSequenceStatement	(	$a_table,
		$a_file = `""`
	)

Build CreateSequence statement.

Parameters

string	table name
file	file resource or empty string

Definition at line 511 of file class.ilDBGenerator.php.

Referenced by buildDBGenerationScript().

                                                                              {
                 $seq = $this->analyzer->hasSequence($a_table);
                 if ($seq !== false) {
                         $seq_st = "\n" . '$ilDB->createSequence("' . $a_table . '", ' . (int)$seq . ');' . "\n";
 
                         if ($a_file == "") {
                                 echo $seq_st;
                         } else {
                                 fwrite($a_file, $seq_st);
                         }
                 }
         }

Here is the caller graph for this function:

◆ buildCreateTableStatement()

ilDBGenerator::buildCreateTableStatement	(	$a_table,
		$a_file = `""`
	)

Build CreateTable statement.

Parameters

string	table name
file	file resource or empty string

Definition at line 367 of file class.ilDBGenerator.php.

References fields.

Referenced by buildDBGenerationScript().

                                                                           {
                 $fields = $this->analyzer->getFieldInformation($a_table, true);
                 $this->fields = $fields;
                 $create_st = "\n\n//\n// " . $a_table . "\n//\n";
                 $create_st .= '$fields = array (' . "\n";
                 $f_sep = "";
                 foreach ($fields as $f => $def) {
 
                         $create_st .= "\t" . $f_sep . '"' . $f . '" => array (' . "\n";
                         $f_sep = ",";
                         $a_sep = "";
                         foreach ($def as $k => $v) {
                                 if ($k != "nativetype" && $k != "alt_types" && $k != "autoincrement" && !is_null($v)) {
                                         switch ($k) {
                                                 case "notnull":
                                                 case "unsigned":
                                                 case "fixed":
                                                         $v = $v ? "true" : "false";
                                                         break;
 
                                                 case "default":
                                                 case "type":
                                                         $v = '"' . $v . '"';
                                                         break;
 
                                                 default:
                                                         break;
                                         }
                                         $create_st .= "\t\t" . $a_sep . '"' . $k . '" => ' . $v . "\n";
                                         $a_sep = ",";
                                 }
                         }
                         $create_st .= "\t" . ')' . "\n";
                 }
                 $create_st .= ');' . "\n";
                 $create_st .= '$ilDB->createTable("' . $a_table . '", $fields);' . "\n";
 
                 if ($a_file == "") {
                         echo $create_st;
                 } else {
                         fwrite($a_file, $create_st);
                 }
         }

Here is the caller graph for this function:

◆ buildDBGenerationScript()

ilDBGenerator::buildDBGenerationScript ( $a_filename = "" )

Build DB generation script.

Parameters

string output filename, if no filename is given, script is echoed

Definition at line 275 of file class.ilDBGenerator.php.

References $file, $ok, $path, $start, array, buildAddIndexStatements(), buildAddPrimaryKeyStatement(), buildAddUniqueConstraintStatements(), buildCreateSequenceStatement(), buildCreateTableStatement(), buildInsertStatement(), buildInsertStatements(), buildSingularSequenceStatement(), checkProcessing(), closeFile(), getTables(), and openFile().

                                                                   {
                 if (@is_dir($a_filename)) {
                         $isDirectory = true;
                         $path = $a_filename;
                 } else {
                         $isDirectory = false;
                         $path = '';
                 }
 
                 $file = "";
                 if ($a_filename != "" and !$isDirectory) {
                         $file = fopen($a_filename, "w");
 
                         $start = '<?php' . "\n" . 'function setupILIASDatabase()' . "\n{\n";
                         $start .= "\t" . 'global $ilDB;' . "\n\n";
                         fwrite($file, $start);
                 } elseif ($isDirectory) {
                         ;
                 } else {
                         echo "<pre>";
                 }
 
                 $this->getTables();
 
                 foreach ($this->tables as $table) {
                         if ($this->checkProcessing($table)) {
                                 if ($a_filename != "") {
                                         flush();
                                 }
 
                                 if ($isDirectory) {
                                         $file = $this->openFile($path . '/' . $table);
                                 }
 
                                 // create table statement
                                 $this->buildCreateTableStatement($table, $file);
 
                                 // primary key
                                 $this->buildAddPrimaryKeyStatement($table, $file);
 
                                 // indices
                                 $this->buildAddIndexStatements($table, $file);
 
                                 // constraints (currently unique keys)
                                 $this->buildAddUniqueConstraintStatements($table, $file);
 
                                 // auto increment sequence
                                 $this->buildCreateSequenceStatement($table, $file);
 
                                 if (in_array($table, array('usr_session_stats', 'usr_session_raw', 'il_plugin'))) {
                                         continue;
                                 }
 
                                 // inserts
                                 if ($isDirectory) {
                                         $this->buildInsertStatement($table, $path);
                                         #$this->buildInsertStatementsXML($table,$path);
                                 } else {
                                         $this->buildInsertStatements($table, $file);
                                 }
 
                                 if ($isDirectory) {
                                         $this->closeFile($file);
                                 }
                         } else {
                                 if ($a_filename != "") {
                                         echo "<br><b>missing: " . $table . "</b>";
                                         flush();
                                 }
                         }
                 }
 
                 // sequence(s) without table (of same name)
                 $this->buildSingularSequenceStatement($file);
 
                 if ($a_filename == "") {
                         echo "</pre>";
                 } elseif (!$isDirectory) {
                         $end = "\n}\n?>\n";
                         $ok = fwrite($file, $end);
                         var_dump($ok);
                         fclose($file);
                 }
         }

Here is the call graph for this function:

◆ buildInsertStatement()

ilDBGenerator::buildInsertStatement	(	$a_table,
		$a_basedir
	)

Write seerialized insert data to array.

Parameters

object	$a_table
object	$a_basedir

Returns

Definition at line 560 of file class.ilDBGenerator.php.

References $ilLog, $row, array, fields, and shortenText().

Referenced by buildDBGenerationScript().

                                                                    {
                 global $ilLog;
 
                 $ilLog->write('Starting export of:' . $a_table);
 
                 $set = $this->il_db->query("SELECT * FROM " . $this->il_db->quoteIdentifier($a_table));
                 $row = 0;
 
                 umask(0000);
                 mkdir($a_basedir . '/' . $a_table . '_inserts', fileperms($a_basedir));
 
                 $filenum = 1;
                 while ($rec = $this->il_db->fetchAssoc($set)) {
                         $values = array();
                         foreach ($rec as $f => $v) {
                                 if ($this->fields[$f]['type'] == 'text' and $this->fields[$f]['length'] >= 1000) {
                                         $v = $this->shortenText($a_table, $f, $v, $this->fields[$f]['length']);
                                 }
 
                                 $values[$f] = array(
                                         $this->fields[$f]['type'],
                                         $v,
                                 );
                         }
 
                         $rows[$a_table][$row ++] = $values;
 
                         if ($row >= 1000) {
                                 $ilLog->write('Writing insert statements after 1000 lines...');
                                 $fp = fopen($a_basedir . '/' . $a_table . '_inserts/' . $filenum ++ . '.data', 'w');
                                 fwrite($fp, serialize((array)$rows));
                                 fclose($fp);
 
                                 $row = 0;
                                 unset($rows);
                         }
                 }
                 if ($rows) {
                         $fp = fopen($a_basedir . '/' . $a_table . '_inserts/' . $filenum ++ . '.data', 'w');
                         fwrite($fp, serialize((array)$rows) . "\n");
                         fclose($fp);
                 }
 
                 $ilLog->write('Finished export of: ' . $a_table);
                 if (function_exists('memory_get_usage')) {
                         $ilLog->write('Memory usage: ' . memory_get_usage(true));
                 }
 
                 return true;
         }

Here is the call graph for this function:

Here is the caller graph for this function:

◆ buildInsertStatements()

ilDBGenerator::buildInsertStatements	(	$a_table,
		$a_file = `""`
	)

Build Insert statements.

Parameters

string	table name
file	file resource or empty string

Definition at line 660 of file class.ilDBGenerator.php.

References array, and fields.

Referenced by buildDBGenerationScript().

                                                                       {
                 if ($a_table == "lng_data") {
                         return;
                 }
 
                 $set = $this->il_db->query("SELECT * FROM " . $this->il_db->quoteIdentifier($a_table));
                 $ins_st = "";
                 $first = true;
                 while ($rec = $this->il_db->fetchAssoc($set)) {
                         $fields = array();
                         $types = array();
                         $values = array();
                         $i_str = array();
                         foreach ($rec as $f => $v) {
                                 $fields[] = $f;
                                 $types[] = '"' . $this->fields[$f]["type"] . '"';
                                 $v = str_replace('\\', '\\\\', $v);
                                 $values[] = "'" . str_replace("'", "\'", $v) . "'";
                                 $i_str[] = "'" . $f . "' => array('" . $this->fields[$f]["type"] . "', '" . str_replace("'", "\'", $v) . "')";
                         }
                         $fields_str = "(" . implode($fields, ",") . ")";
                         $types_str = "array(" . implode($types, ",") . ")";
                         $values_str = "array(" . implode($values, ",") . ")";
                         $ins_st = "\n" . '$ilDB->insert("' . $a_table . '", array(' . "\n";
                         $ins_st .= implode($i_str, ", ") . "));\n";
                         //$ins_st.= "\t".$fields_str."\n";
                         //$ins_st.= "\t".'VALUES '."(%s".str_repeat(",%s", count($fields) - 1).')"'.",\n";
                         //$ins_st.= "\t".$types_str.','.$values_str.');'."\n";
 
                         if ($a_file == "") {
                                 echo $ins_st;
                         } else {
                                 fwrite($a_file, $ins_st);
                         }
                         $ins_st = "";
                 }
         }

Here is the caller graph for this function:

◆ buildInsertStatementsXML()

ilDBGenerator::buildInsertStatementsXML	(	$a_table,
		$a_basedir
	)

Parameters

object	$a_table
object	$a_file	[optional]

Returns

Definition at line 618 of file class.ilDBGenerator.php.

References $ilLog, $w, array, fields, and shortenText().

                                                                        {
                 global $ilLog;
 
                 include_once './Services/Xml/classes/class.ilXmlWriter.php';
                 $w = new ilXmlWriter();
                 $w->xmlStartTag('Table', array( 'name' => $a_table ));
 
                 $set = $this->il_db->query("SELECT * FROM " . $this->il_db->quoteIdentifier($a_table));
                 $ins_st = "";
                 $first = true;
                 while ($rec = $this->il_db->fetchAssoc($set)) {
                         #$ilLog->write('Num: '.$num++);
                         $w->xmlStartTag('Row');
 
                         $fields = array();
                         $types = array();
                         $values = array();
                         foreach ($rec as $f => $v) {
                                 if ($this->fields[$f]['type'] == 'text' and $this->fields[$f]['length'] >= 1000) {
                                         $v = $this->shortenText($a_table, $f, $v, $this->fields[$f]['length']);
                                 }
 
                                 $w->xmlElement('Value', array(
                                                 'name' => $f,
                                                 'type' => $this->fields[$f]['type'],
                                         ), $v);
                         }
 
                         $w->xmlEndTag('Row');
                 }
                 $w->xmlEndTag('Table');
 
                 $w->xmlDumpFile($a_basedir . '/' . $a_table . '.xml', false);
         }

Here is the call graph for this function:

◆ buildSingularSequenceStatement()

ilDBGenerator::buildSingularSequenceStatement ( $a_file = "" )

Build CreateSequence statement (if not belonging to table)

Parameters

file	file resource or empty string

Definition at line 530 of file class.ilDBGenerator.php.

References $r.

Referenced by buildDBGenerationScript().

                                                                      {
                 $r = $this->manager->listSequences();
 
                         foreach ($r as $seq) {
                                 if (!in_array($seq, $this->tables)) {
                                         // 12570
                                         if ($seq == "sahs_sc13_seq") {
                                                 continue;
                                         }
 
                                         $create_st = "\n" . '$ilDB->createSequence("' . $seq . '");' . "\n";
 
                                         if ($a_file == "") {
                                                 echo $create_st;
                                         } else {
                                                 fwrite($a_file, $create_st);
                                         }
                                 }
                         }
 
         }

Here is the caller graph for this function:

◆ checkProcessing()

ilDBGenerator::checkProcessing ( $a_table )

Check whether a table should be processed or not.

Definition at line 223 of file class.ilDBGenerator.php.

Referenced by buildDBGenerationScript(), and getHTMLOverview().

                                                   {
                 // check black list
                 if (in_array($a_table, $this->blacklist)) {
                         return false;
                 }
 
                 // check white list
                 if (count($this->whitelist) > 0 && !in_array($a_table, $this->whitelist)) {
                         return false;
                 }
 
                 return true;
         }

Here is the caller graph for this function:

◆ closeFile()

ilDBGenerator::closeFile ( $fp )

protected

Definition at line 256 of file class.ilDBGenerator.php.

Referenced by buildDBGenerationScript().

                                           {
                 if (1) {
                         #fwrite ($fp, $end);
                         fclose($fp);
 
                         return;
                 }
 
                 $end = "\n}\n?>\n";
                 fwrite($fp, $end);
                 fclose($fp);
         }

Here is the caller graph for this function:

◆ getBlackList()

ilDBGenerator::getBlackList ( )

Get Table Black List.

Returns: array Table Black List

Definition at line 173 of file class.ilDBGenerator.php.

References $blacklist.

                                        {
                 return $this->blacklist;
         }

◆ getHTMLOverview()

ilDBGenerator::getHTMLOverview ( $a_filename = "" )

Get table definition overview in HTML.

Parameters

string output filename, if no filename is given, script is echoed

Definition at line 704 of file class.ilDBGenerator.php.

References $tpl, addTableToOverview(), checkProcessing(), getTables(), and ILIAS_VERSION.

                                                           {
                 $tpl = new ilTemplate("tpl.db_overview.html", true, true, "Services/Database");
 
                 $this->getTables();
                 $cnt = 1;
                 foreach ($this->tables as $table) {
                         if ($this->checkProcessing($table)) {
                                 // create table statement
                                 if ($this->addTableToOverview($table, $tpl, $cnt)) {
                                         $cnt ++;
                                 }
                         }
                 }
 
                 $tpl->setVariable("TXT_TITLE", "ILIAS Abstract DB Tables (" . ILIAS_VERSION . ")");
 
                 if ($a_filename == "") {
                         echo $tpl->get();
                 }
         }

Here is the call graph for this function:

◆ getTables()

ilDBGenerator::getTables ( )

Returns: array

Definition at line 212 of file class.ilDBGenerator.php.

References $r, and $tables.

Referenced by buildDBGenerationScript(), and getHTMLOverview().

                                     {
                 $r = $this->manager->listTables();
                 $this->tables = $r;
 
                 return $this->tables;
         }

Here is the caller graph for this function:

◆ getTargetEncoding()

ilDBGenerator::getTargetEncoding ( )

Returns the target encoding.

Returns: string

Definition at line 152 of file class.ilDBGenerator.php.

References $target_encoding.

Referenced by shortenText().

                                             {
                 return $this->target_encoding;
         }

Here is the caller graph for this function:

◆ getWhiteList()

ilDBGenerator::getWhiteList ( )

Get Table White List.

Returns: array Table White List

Definition at line 195 of file class.ilDBGenerator.php.

References $whitelist.

                                        {
                 return $this->whitelist;
         }

◆ lookupAbstractedTables()

static ilDBGenerator::lookupAbstractedTables ( )

static

Returns: array

Deprecated:: abstraction_progress is no longer used in ILIAS

Definition at line 56 of file class.ilDBGenerator.php.

References $ilDB, $names, $query, $res, $row, array, and ilDBConstants\FETCHMODE_OBJECT.

                                                         {
                 global $ilDB;
 
                 $query = "SELECT DISTINCT(table_name) FROM abstraction_progress ";
                 $res = $ilDB->query($query);
                 $names = array();
                 while ($row = $res->fetchRow(ilDBConstants::FETCHMODE_OBJECT)) {
                         $names[] = $row->table_name;
                 }
 
                 // tables that have been already created in an abstracted
                 // way or tables that have been renamed after being abstracted
                 // (see db_update script)
                 $abs_tables = array_merge($names, array(
                         'acc_access_key',
                         'acc_user_access_key',
                         'ldap_rg_mapping',
                         'page_anchor',
                         'qpl_question_orderinghorizontal',
                         'qpl_question_fileupload',
                         'chat_smilies',
                         'style_color',
                         'style_template_class',
                         'style_template',
                         'page_style_usage',
                         'style_setting',
                         'page_editor_settings',
                         'mep_data',
                         'license_data',
                         'loginname_history',
                         'mep_item',
                         'qpl_a_cloze',
                         'qpl_a_imagemap',
                         'qpl_a_matching',
                         'qpl_num_range',
                         'qpl_qst_cloze',
                         'qpl_qst_essay',
                         'qpl_qst_fileupload',
                         'qpl_qst_flash',
                         'qpl_qst_horder',
                         'qpl_qst_imagemap',
                         'qpl_qst_javaapplet',
                         'qpl_qst_matching',
                         'qpl_qst_mc',
                         'qpl_qst_numeric',
                         'qpl_qst_ordering',
                         'qpl_qst_sc',
                         'qpl_qst_textsubset',
                         'qpl_qst_type',
                         'qpl_sol_sug',
                         'udf_text',
                         'udf_clob',
                         'xmlnestedsettmp',
                         'cache_text',
                         'cache_clob',
                         'qpl_a_errortext',
                         'qpl_qst_errortext',
                         'tst_rnd_cpy',
                         'tst_rnd_qpl_title',
                         'qpl_a_mdef',
                 ));
 
                 return $abs_tables;
         }

◆ openFile()

ilDBGenerator::openFile ( $a_path )

protected

Definition at line 238 of file class.ilDBGenerator.php.

References $file, and $start.

Referenced by buildDBGenerationScript().

                                              {
                 if (1) {
                         $file = fopen($a_path, "w");
                         $start .= "\t" . 'global $ilDB;' . "\n\n";
                         fwrite($file, $start);
 
                         return $file;
                 }
 
                 $file = fopen($a_path, "w");
                 $start = '<?php' . "\n" . 'function setupILIASDatabase()' . "\n{\n";
                 $start .= "\t" . 'global $ilDB;' . "\n\n";
                 fwrite($file, $start);
 
                 return $file;
         }

Here is the caller graph for this function:

◆ setBlackList()

ilDBGenerator::setBlackList ( $a_blacklist )

Set Table Black List.

(Tables that should not be included in the processing)

Parameters

array $a_blacklist Table Black List

Definition at line 163 of file class.ilDBGenerator.php.

                                                    {
                 $this->blacklist = $a_blacklist;
         }

◆ setFilter()

ilDBGenerator::setFilter	(	$a_filter,
		$a_value
	)

Parameters

$a_filter
$a_value

Definition at line 204 of file class.ilDBGenerator.php.

                                                        {
                 $this->filter[$a_filter] = $a_value;
         }

◆ setTargetEncoding()

ilDBGenerator::setTargetEncoding ( $a_encoding )

Set the desired target encoding If the target encoding os different from UTF-8 all text values will be shortened to length of of the current text field.

E.g: il_meta_keyword keyword(4000) target encoding: UTF16

=> $value = mb_convert_encoding($value,'UTF-8','UTF-16'); $value = mb_strcut($value,0,4000,'UTF16'); $value = mb_convert_encoding($value,'UTF-16','UTF-8');

Parameters

object $a_encoding

Returns

Definition at line 142 of file class.ilDBGenerator.php.

                                                        {
                 $this->target_encoding = $a_encoding;
         }

◆ setWhiteList()

ilDBGenerator::setWhiteList ( $a_whitelist )

Set Table White List.

Per default all tables are included in the processing. If a white list ist provided, only them will be used.

Parameters

array $a_whitelist Table White List

Definition at line 185 of file class.ilDBGenerator.php.

                                                    {
                 $this->whitelist = $a_whitelist;
         }

◆ shortenText()

ilDBGenerator::shortenText	(	$table,
		$field,
		$a_value,
		$a_size
	)

protected

Shorten text depending on target encoding.

Parameters

string	$table
string	$field
string	$a_value
int	$a_size

Returns: string

Definition at line 867 of file class.ilDBGenerator.php.

References $ilLog, fields, getTargetEncoding(), and ilStr\shortenText().

Referenced by buildInsertStatement(), and buildInsertStatementsXML().

                                                                           {
                 global $ilLog;
 
                 if ($this->getTargetEncoding() == 'UTF-8') {
                         return $a_value;
                 }
                 // Convert to target encoding
                 $shortened = mb_convert_encoding($a_value, $this->getTargetEncoding(), 'UTF-8');
                 // Shorten
                 include_once './Services/Utilities/classes/class.ilStr.php';
                 $shortened = ilStr::shortenText($shortened, 0, $a_size, $this->getTargetEncoding());
                 // Convert back to UTF-8
                 $shortened = mb_convert_encoding($shortened, 'UTF-8', $this->getTargetEncoding());
 
                 if (strlen($a_value) != strlen($shortened)) {
                         $ilLog->write('Table        : ' . $table);
                         $ilLog->write('Field        : ' . $field);
                         $ilLog->write('Type         : ' . $this->fields[$field]['type']);
                         $ilLog->write('Length       : ' . $this->fields[$field]['length']);
                         $ilLog->write('Before       : ' . $a_value);
                         $ilLog->write('Shortened    : ' . $shortened);
                         $ilLog->write('Strlen Before: ' . strlen($a_value));
                         $ilLog->write('Strlen After : ' . strlen($shortened));
                 }
 
                 return $shortened;
         }

Here is the call graph for this function:

Here is the caller graph for this function:

Field Documentation

◆ $blacklist

ilDBGenerator::$blacklist = array()

protected

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

Referenced by getBlackList().

◆ $filter

ilDBGenerator::$filter = array()

protected

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

◆ $tables

ilDBGenerator::$tables = array()

protected

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

Referenced by getTables().

◆ $target_encoding

ilDBGenerator::$target_encoding = 'UTF-8'

protected

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

Referenced by getTargetEncoding().

◆ $whitelist

ilDBGenerator::$whitelist = array()

protected

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

Referenced by getWhiteList().

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

Services/Database/classes/class.ilDBGenerator.php

Public Member Functions

Static Public Member Functions

Protected Member Functions

Protected Attributes

Detailed Description

Constructor & Destructor Documentation

◆ __construct()

Member Function Documentation

◆ addTableToOverview()

◆ buildAddIndexStatements()

◆ buildAddPrimaryKeyStatement()

◆ buildAddUniqueConstraintStatements()

◆ buildCreateSequenceStatement()

◆ buildCreateTableStatement()

◆ buildDBGenerationScript()

◆ buildInsertStatement()

◆ buildInsertStatements()

◆ buildInsertStatementsXML()

◆ buildSingularSequenceStatement()

◆ checkProcessing()

◆ closeFile()

◆ getBlackList()

◆ getHTMLOverview()

◆ getTables()

◆ getTargetEncoding()

◆ getWhiteList()

◆ lookupAbstractedTables()

◆ openFile()

◆ setBlackList()

◆ setFilter()

◆ setTargetEncoding()

◆ setWhiteList()

◆ shortenText()

Field Documentation

◆ $blacklist

◆ $filter

◆ $tables

◆ $target_encoding

◆ $whitelist