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 (string $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');` More...

	getTargetEncoding ()

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

	getBlackList ()

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

	getWhiteList ()

	setFilter (string $a_filter, string $a_value)

	getTables ()

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

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

	buildCreateTableStatement (string $a_table, $a_file=null)

	buildAddPrimaryKeyStatement (string $a_table, $a_file=null)

	buildAddIndexStatements (string $a_table, $a_file=null)

	buildAddUniqueConstraintStatements (string $a_table, $file_handle=null)

	buildCreateSequenceStatement (string $a_table, $file_handle=null)

	buildSingularSequenceStatement ($file_handle=null)

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

	buildInsertStatements (string $a_table, $file_handle=null)

Static Public Member Functions
static	lookupAbstractedTables ()

Protected Member Functions
	openFile (string $a_path)

	closeFile ($fp)

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

Protected Attributes
string	$target_encoding = 'UTF-8'

array	$whitelist = []

array	$blacklist = []

array	$tables = []

array	$filter = []

ilDBManager	$manager

ilDBReverse	$reverse

ilDBInterface	$il_db

ilDBAnalyzer	$analyzer

array	$allowed_attributes = []

array	$fields = []

Private Member Functions
	printOrWrite (string $string, $file_handle=null)

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

Constructor & Destructor Documentation

◆ __construct()

ilDBGenerator::__construct ( )

Constructor.

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

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

     {
         global $DIC;
         $ilDB = $DIC->database();
 
         $this->manager = $ilDB->loadModule(ilDBConstants::MODULE_MANAGER);
         $this->reverse = $ilDB->loadModule(ilDBConstants::MODULE_REVERSE);
         $this->il_db = $ilDB;
         $this->analyzer = new ilDBAnalyzer();
         $this->allowed_attributes = $ilDB->getAllowedAttributes();
     }

Member Function Documentation

◆ buildAddIndexStatements()

ilDBGenerator::buildAddIndexStatements	(	string	$a_table,
			$a_file = `null`
	)

Parameters

resource $a_file

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

References Vendor\Package\$f, and null.

Referenced by buildDBGenerationScript().

                                                                             : void
     {
         $ind = $this->analyzer->getIndicesInformation($a_table, true);
 
         if (is_array($ind)) {
             foreach ($ind as $i) {
                 $ft = $i["fulltext"] ? ", true" : ", 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 === null) {
                     echo $in_st;
                 } else {
                     fwrite($a_file, $in_st);
                 }
             }
         }
     }

Here is the caller graph for this function:

◆ buildAddPrimaryKeyStatement()

ilDBGenerator::buildAddPrimaryKeyStatement	(	string	$a_table,
			$a_file = `null`
	)

Parameters

resource $a_file

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

References Vendor\Package\$f, and null.

Referenced by buildDBGenerationScript().

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

Here is the caller graph for this function:

◆ buildAddUniqueConstraintStatements()

ilDBGenerator::buildAddUniqueConstraintStatements	(	string	$a_table,
			$file_handle = `null`
	)

Parameters

resource $file_handle

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

References Vendor\Package\$f, and printOrWrite().

Referenced by buildDBGenerationScript().

                                                                                             : void
     {
         $con = $this->analyzer->getConstraintsInformation($a_table, true);
 
         if (is_array($con)) {
             $in_st = '';
             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";
             }
             $this->printOrWrite($in_st, $file_handle);
         }
     }

Here is the call graph for this function:

Here is the caller graph for this function:

◆ buildCreateSequenceStatement()

ilDBGenerator::buildCreateSequenceStatement	(	string	$a_table,
			$file_handle = `null`
	)

Parameters

resource $file_handle

Exceptions

ilDatabaseException

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

References ILIAS\Repository\int(), and printOrWrite().

Referenced by buildDBGenerationScript().

                                                                                       : void
     {
         $seq = $this->analyzer->hasSequence($a_table);
         if ($seq !== false) {
             $seq_st = "\n" . '$ilDB->createSequence("' . $a_table . '", ' . (int) $seq . ');' . "\n";
 
             $this->printOrWrite($seq_st, $file_handle);
         }
     }

Here is the call graph for this function:

Here is the caller graph for this function:

◆ buildCreateTableStatement()

ilDBGenerator::buildCreateTableStatement	(	string	$a_table,
			$a_file = `null`
	)

Parameters

string	$a_table
resource	$a_file

Exceptions

ilDatabaseException

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

References Vendor\Package\$f, $fields, and null.

Referenced by buildDBGenerationScript().

                                                                               : void
     {
         $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 .= '     )' . "\n";
         }
         $create_st .= ');' . "\n";
         $create_st .= '$ilDB->createTable("' . $a_table . '", $fields);' . "\n";
 
         if ($a_file === null) {
             echo $create_st;
         } else {
             fwrite($a_file, $create_st);
         }
     }

Here is the caller graph for this function:

◆ buildDBGenerationScript()

ilDBGenerator::buildDBGenerationScript ( string $a_filename = "" )

Build DB generation script.

Parameters

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

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

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

                                                                     : void
     {
         if (@is_dir($a_filename)) {
             $is_dir = true;
             $path = $a_filename;
         } else {
             $is_dir = false;
             $path = '';
         }
 
         $file = "";
         if ($a_filename !== "" && !$is_dir) {
             $file = fopen($a_filename, 'wb');
 
             $start = '<?php' . "\n" . 'function setupILIASDatabase()' . "\n{\n";
             $start .= ' global $ilDB;' . "\n\n";
             fwrite($file, $start);
         } else {
             echo "<pre>";
         }
 
         foreach ($this->getTables() as $table) {
             if ($this->checkProcessing($table)) {
                 if ($a_filename !== "") {
                     flush();
                 }
 
                 if ($is_dir) {
                     $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, ['usr_session_stats', 'usr_session_raw', 'il_plugin'])) {
                     continue;
                 }
 
                 // inserts
                 if ($is_dir) {
                     $this->buildInsertStatement($table, $path);
                     #$this->buildInsertStatementsXML($table,$path);
                 } else {
                     $this->buildInsertStatements($table, $file);
                 }
 
                 if ($is_dir) {
                     $this->closeFile($file);
                 }
             } elseif ($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 (!$is_dir) {
             $end = "\n}\n?>\n";
             $ok = fwrite($file, $end);
             fclose($file);
         }
     }

Here is the call graph for this function:

◆ buildInsertStatement()

ilDBGenerator::buildInsertStatement	(	string	$a_table,
		string	$a_basedir
	)

Write seerialized insert data to array.

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

References $DIC, Vendor\Package\$f, and shortenText().

Referenced by buildDBGenerationScript().

                                                                             : bool
     {
         global $DIC;
         $ilLogger = $DIC->logger()->root();
 
         $ilLogger->log('Starting export of:' . $a_table);
 
         $set = $this->il_db->query("SELECT * FROM " . $this->il_db->quoteIdentifier($a_table));
         $row = 0;
 
         umask(0000);
         if (!mkdir(
             $concurrentDirectory = $a_basedir . '/' . $a_table . '_inserts',
             fileperms($a_basedir)
         ) && !is_dir($concurrentDirectory)) {
             throw new \RuntimeException(sprintf('Directory "%s" was not created', $concurrentDirectory));
         }
 
         $filenum = 1;
         while ($rec = $this->il_db->fetchAssoc($set)) {
             $values = [];
             foreach ($rec as $f => $v) {
                 if ($this->fields[$f]['type'] === 'text' && $this->fields[$f]['length'] >= 1000) {
                     $v = $this->shortenText($a_table, $f, $v, $this->fields[$f]['length']);
                 }
 
                 $values[$f] = [
                     $this->fields[$f]['type'],
                     $v,
                 ];
             }
 
             $rows[$a_table][$row++] = $values;
 
             if ($row >= 1000) {
                 $ilLogger->log('Writing insert statements after 1000 lines...');
                 $fp = fopen($a_basedir . '/' . $a_table . '_inserts/' . $filenum++ . '.data', 'wb');
                 fwrite($fp, serialize($rows));
                 fclose($fp);
 
                 $row = 0;
                 unset($rows);
             }
         }
         if (isset($rows)) {
             $fp = fopen($a_basedir . '/' . $a_table . '_inserts/' . $filenum++ . '.data', 'wb');
             fwrite($fp, serialize($rows) . "\n");
             fclose($fp);
         }
 
         $ilLogger->log('Finished export of: ' . $a_table);
         if (function_exists('memory_get_usage')) {
             $ilLogger->log('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	(	string	$a_table,
			$file_handle = `null`
	)

Parameters

resource $file_handle

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

References Vendor\Package\$f, and printOrWrite().

Referenced by buildDBGenerationScript().

                                                                                : void
     {
         if ($a_table === "lng_data") {
             return;
         }
 
         $set = $this->il_db->query("SELECT * FROM " . $this->il_db->quoteIdentifier($a_table));
         $ins_st = "";
         while ($rec = $this->il_db->fetchAssoc($set)) {
             $fields = [];
             $types = [];
             $values = [];
             $i_str = [];
             foreach ($rec as $f => $v) {
                 $v = str_replace('\\', '\\\\', $v);
                 $i_str[] = "'" . $f . "' => array('" . $this->fields[$f]["type"] . "', '" . str_replace(
                     "'",
                     "\'",
                     $v
                 ) . "')";
             }
             $ins_st = "\n" . '$ilDB->insert("' . $a_table . '", array(' . "\n";
             $ins_st .= implode(", ", $i_str) . "));\n";
 
             $this->printOrWrite($ins_st, $file_handle);
             $ins_st = "";
         }
     }

Here is the call graph for this function:

Here is the caller graph for this function:

◆ buildSingularSequenceStatement()

ilDBGenerator::buildSingularSequenceStatement ( $file_handle = null )

Parameters

resource $file_handle

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

References $r, and printOrWrite().

Referenced by buildDBGenerationScript().

                                                                        : void
     {
         $r = $this->manager->listSequences();
 
         foreach ($r as $seq) {
             if (!in_array($seq, $this->tables, true)) {
                 // 12570
                 if ($seq === "sahs_sc13_seq") {
                     continue;
                 }
 
                 $create_st = "\n" . '$ilDB->createSequence("' . $seq . '");' . "\n";
 
                 $this->printOrWrite($create_st, $file_handle);
             }
         }
     }

Here is the call graph for this function:

Here is the caller graph for this function:

◆ checkProcessing()

ilDBGenerator::checkProcessing ( string $a_table )

Check whether a table should be processed or not.

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

Referenced by buildDBGenerationScript().

                                                     : bool
     {
         // check black list
         if (in_array($a_table, $this->blacklist, true)) {
             return false;
         }
         // check white list
         return !($this->whitelist !== [] && !in_array($a_table, $this->whitelist, true));
     }

Here is the caller graph for this function:

◆ closeFile()

ilDBGenerator::closeFile ( $fp )

protected

Parameters

resource $fp

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

Referenced by buildDBGenerationScript().

                                      : void
     {
         fclose($fp);
     }

Here is the caller graph for this function:

◆ getBlackList()

ilDBGenerator::getBlackList ( )

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

References $blacklist.

                                   : array
     {
         return $this->blacklist;
     }

◆ getTables()

ilDBGenerator::getTables ( )

Returns: string[]

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

Referenced by buildDBGenerationScript().

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

Here is the caller graph for this function:

◆ getTargetEncoding()

ilDBGenerator::getTargetEncoding ( )

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

References $target_encoding.

Referenced by shortenText().

                                        : string
     {
         return $this->target_encoding;
     }

Here is the caller graph for this function:

◆ getWhiteList()

ilDBGenerator::getWhiteList ( )

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

References $whitelist.

                                   : array
     {
         return $this->whitelist;
     }

◆ lookupAbstractedTables()

static ilDBGenerator::lookupAbstractedTables ( )

static

Returns: string[]

Deprecated:: abstraction_progress is no longer used in ILIAS

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

References $DIC, $ilDB, $res, and ilDBConstants\FETCHMODE_OBJECT.

                                                    : array
     {
         global $DIC;
         $ilDB = $DIC->database();
 
         $query = "SELECT DISTINCT(table_name) FROM abstraction_progress ";
         $res = $ilDB->query($query);
         $names = [];
         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, [
             '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 ( string $a_path )

protected

Returns: resource

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

Referenced by buildDBGenerationScript().

     {
         $start = '';
         $file = fopen($a_path, 'wb');
         $start .= '     global $ilDB;' . "\n\n";
         fwrite($file, $start);
 
         return $file;
     }

Here is the caller graph for this function:

◆ printOrWrite()

ilDBGenerator::printOrWrite	(	string	$string,
			$file_handle = `null`
	)

private

Parameters

resource $file_handle

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

References null.

Referenced by buildAddUniqueConstraintStatements(), buildCreateSequenceStatement(), buildInsertStatements(), and buildSingularSequenceStatement().

                                                                       : void
     {
         if ($file_handle === null) {
             echo $string;
         } else {
             fwrite($file_handle, $string);
         }
     }

Here is the caller graph for this function:

◆ setBlackList()

ilDBGenerator::setBlackList ( array $a_blacklist )

Set Table Black List.

(Tables that should not be included in the processing)

Parameters

string[] $a_blacklist Table Black List

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

                                                     : void
     {
         $this->blacklist = $a_blacklist;
     }

◆ setFilter()

ilDBGenerator::setFilter	(	string	$a_filter,
		string	$a_value
	)

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

References ILIAS\Repository\filter().

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

Here is the call graph for this function:

◆ setTargetEncoding()

ilDBGenerator::setTargetEncoding ( string $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');

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

                                                          : void
     {
         $this->target_encoding = $a_encoding;
     }

◆ setWhiteList()

ilDBGenerator::setWhiteList ( array $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

string[] $a_whitelist Table White List

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

                                                     : void
     {
         $this->whitelist = $a_whitelist;
     }

◆ shortenText()

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

protected

Shorten text depending on target encoding.

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

References $DIC, getTargetEncoding(), and ilStr\shortenText().

Referenced by buildInsertStatement().

                                                                                               : string
     {
         global $DIC;
         $ilLogger = $DIC->logger()->root();
 
         if ($this->getTargetEncoding() === 'UTF-8') {
             return $a_value;
         }
         // Convert to target encoding
         $shortened = mb_convert_encoding($a_value, $this->getTargetEncoding(), 'UTF-8');
         // Shorten
         $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)) {
             $ilLogger->log('Table        : ' . $table);
             $ilLogger->log('Field        : ' . $field);
             $ilLogger->log('Type         : ' . $this->fields[$field]['type']);
             $ilLogger->log('Length       : ' . $this->fields[$field]['length']);
             $ilLogger->log('Before       : ' . $a_value);
             $ilLogger->log('Shortened    : ' . $shortened);
             $ilLogger->log('Strlen Before: ' . strlen($a_value));
             $ilLogger->log('Strlen After : ' . strlen($shortened));
         }
 
         return $shortened;
     }

Here is the call graph for this function:

Here is the caller graph for this function:

Field Documentation

◆ $allowed_attributes

array ilDBGenerator::$allowed_attributes = []

protected

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

◆ $analyzer

ilDBAnalyzer ilDBGenerator::$analyzer

protected

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

◆ $blacklist

array ilDBGenerator::$blacklist = []

protected

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

Referenced by getBlackList().

◆ $fields

array ilDBGenerator::$fields = []

protected

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

Referenced by buildCreateTableStatement().

◆ $filter

array ilDBGenerator::$filter = []

protected

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

◆ $il_db

ilDBInterface ilDBGenerator::$il_db

protected

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

◆ $manager

ilDBManager ilDBGenerator::$manager

protected

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

◆ $reverse

ilDBReverse ilDBGenerator::$reverse

protected

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

◆ $tables

array ilDBGenerator::$tables = []

protected

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

◆ $target_encoding

string ilDBGenerator::$target_encoding = 'UTF-8'

protected

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

Referenced by getTargetEncoding().

◆ $whitelist

array ilDBGenerator::$whitelist = []

protected

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

Referenced by getWhiteList().

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

components/ILIAS/Database/classes/class.ilDBGenerator.php

Public Member Functions

Static Public Member Functions

Protected Member Functions

Protected Attributes

Private Member Functions

Detailed Description

Constructor & Destructor Documentation

◆ __construct()

Member Function Documentation

◆ buildAddIndexStatements()

◆ buildAddPrimaryKeyStatement()

◆ buildAddUniqueConstraintStatements()

◆ buildCreateSequenceStatement()

◆ buildCreateTableStatement()

◆ buildDBGenerationScript()

◆ buildInsertStatement()

◆ buildInsertStatements()

◆ buildSingularSequenceStatement()

◆ checkProcessing()

◆ closeFile()

◆ getBlackList()

◆ getTables()

◆ getTargetEncoding()

◆ getWhiteList()

◆ lookupAbstractedTables()

◆ openFile()

◆ printOrWrite()

◆ setBlackList()

◆ setFilter()

◆ setTargetEncoding()

◆ setWhiteList()

◆ shortenText()

Field Documentation

◆ $allowed_attributes

◆ $analyzer

◆ $blacklist

◆ $fields

◆ $filter

◆ $il_db

◆ $manager

◆ $reverse

◆ $tables

◆ $target_encoding

◆ $whitelist