ilDBPdoMySQL Class Reference

Class ilDBPdoMySQL. More...

Inheritance diagram for ilDBPdoMySQL:

Collaboration diagram for ilDBPdoMySQL:

Public Member Functions
	supportsTransactions ()
	initHelpers ()
	supportsEngineMigration ()
	migrateAllTablesToEngine ($engine=ilDBConstants::MYSQL_ENGINE_INNODB)
	migrateAllTablesToCollation ($collation=ilDBConstants::MYSQL_COLLATION_UTF8MB4)
	supportsCollationMigration ()
	nextId ($table_name)
	doesCollationSupportMB4Strings ()
Public Member Functions inherited from ilDBPdo
	connect ($return_false_for_error=false)
	initHelpers ()
	getFieldDefinition ()
	setFieldDefinition ($field_definition)
	createDatabase ($a_name, $a_charset="utf8", $a_collation="")
	getLastErrorCode ()
	initFromIniFile ($tmpClientIniFile=null)
	generateDSN ()
	quoteIdentifier ($identifier, $check_option=false)
	nextId ($table_name)
	createTable ($table_name, $fields, $drop_table=false, $ignore_erros=false)
	checkColumnName ($a_name)
	addPrimaryKey ($table_name, $primary_keys)
	dropIndexByFields ($table_name, $fields)
	getPrimaryKeyIdentifier ()
	createSequence ($table_name, $start=1)
	tableExists ($table_name)
	tableColumnExists ($table_name, $column_name)
	addTableColumn ($table_name, $column_name, $attributes)
	dropTable ($table_name, $error_if_not_existing=true)
	query ($query)
	dropSequence ($table_name)
	dropTableColumn ($table_name, $column_name)
	renameTableColumn ($table_name, $column_old_name, $column_new_name)
	insert ($table_name, $values)
	fetchObject ($query_result)
	update ($table_name, $columns, $where)
	manipulate ($query)
	fetchAssoc ($query_result)
	numRows ($query_result)
	quote ($value, $type=null)
	indexExistsByFields ($table_name, $fields)
	addIndex ($table_name, $fields, $index_name='', $fulltext=false)
	addFulltextIndex ($a_table, $a_fields, $a_name="in")
	dropFulltextIndex ($a_table, $a_name)
	Drop fulltext index. More...
	isFulltextIndex ($a_table, $a_name)
	Is index a fulltext index? More...
	getIndexName ($index_name_base)
	getSequenceName ($table_name)
	constraintName ($a_table, $a_constraint)
	Determine contraint name by table name and constraint name. More...
	getDSN ()
	getDBType ()
	setDBType ($type)
	lockTables ($tables)
	unlockTables ()
	in ($field, $values, $negate=false, $type="")
	queryF ($query, $types, $values)
	manipulateF ($query, $types, $values)
	useSlave ($bool)
	setLimit ($limit, $offset=0)
	Set the Limit for the next Query. More...
	like ($column, $type, $value="?", $case_insensitive=true)
	now ()
	replace ($table, $primaryKeys, $otherColumns)
	Replace into method. More...
	equals ($columns, $value, $type, $emptyOrNull=false)
	getHost ()
	setHost ($host)
	getDbname ()
	setDbname ($dbname)
	getCharset ()
	setCharset ($charset)
	getUsername ()
	setUsername ($username)
	getPassword ()
	setPassword ($password)
	getPort ()
	setPort ($port)
	setDBUser ($user)
	setDBPort ($port)
	setDBPassword ($password)
	setDBHost ($host)
	upper ($a_exp)
	lower ($a_exp)
	substr ($a_exp, $a_pos=1, $a_len=-1)
	prepareManip ($query, $types=null)
	prepare ($query, $types=null, $result_types=null)
	enableResultBuffering ($a_status)
	supportsSlave ()
	supportsFulltext ()
	supportsTransactions ()
	supports ($feature)
	listTables ()
	loadModule ($module)
	getAllowedAttributes ()
	Returns array More...
	sequenceExists ($sequence)
	listSequences ()
	concat (array $values, $allow_null=true)
	locate ($a_needle, $a_string, $a_start_pos=1)
	modifyTableColumn ($table, $a_column, $a_attributes)
	renameTable ($a_name, $a_new_name)
	checkTableName ($a_name)
	beginTransaction ()
	commit ()
	rollback ()
	dropIndex ($a_table, $a_name="i1")
	setStorageEngine ($storage_engine)
	getStorageEngine ()
	queryCol ($query, $type=PDO::FETCH_ASSOC, $colnum=0)
	queryRow ($query, $types=null, $fetchmode=ilDBConstants::FETCHMODE_DEFAULT)
	getServerVersion ($native=false)
	escape ($value, $escape_wildcards=false)
	escapePattern ($text)
	migrateAllTablesToEngine ($engine=ilDBConstants::MYSQL_ENGINE_INNODB)
	migrateAllTablesToCollation ($collation=ilDBConstants::MYSQL_COLLATION_UTF8MB4)
	supportsCollationMigration ()
	supportsEngineMigration ()
	checkIndexName ($name)
	addUniqueConstraint ($table, $fields, $name="con")
	dropUniqueConstraint ($a_table, $a_name="con")
	dropUniqueConstraintByFields ($a_table, $a_fields)
	getLastInsertId ()
	buildAtomQuery ()
	uniqueConstraintExists ($table, array $fields)
	dropPrimaryKey ($table_name)
	executeMultiple ($stmt, $a_data)
	fromUnixtime ($a_expr, $a_to_text=true)
	unixTimestamp ()
	autoExecute ($tablename, $fields, $mode=ilDBConstants::AUTOQUERY_INSERT, $where=false)
	Generate an insert, update or delete query and call prepare() and execute() on it. More...
	getDBVersion ()
	sanitizeMB4StringIfNotSupported ($query)
	Parameters $query string to sanitize, all MB4-Characters like emojis will re replaced with ??? Returns string sanitized query More...
	doesCollationSupportMB4Strings ()
	groupConcat ($a_field_name, $a_seperator=",", $a_order=null)
	Parameters string $a_field_name string $a_seperator string $a_order Returns string More...
	cast ($a_field_name, $a_dest_type)
	Parameters string $a_field_name string $a_dest_type Returns string; More...
Public Member Functions inherited from ilDBInterface
	fetchAll ($query_result, $fetch_mode=ilDBConstants::FETCHMODE_ASSOC)
	substr ($a_exp)
	execute ($stmt, $data=array())
	free ($a_st)

Protected Member Functions
	initSQLMode ()
	getAdditionalAttributes ()
Protected Member Functions inherited from ilDBPdo
	initSQLMode ()
	getAttributes ()
	getAdditionalAttributes ()
	checkTableColumns ($a_cols)
	checkColumn ($a_col, $a_def)
	checkColumnDefinition ($a_def, $a_modify_mode=false)
	appendLimit ($query)
	autoPrepare ($table, $table_fields, $mode=ilDBConstants::AUTOQUERY_INSERT, $where=false, $types=null, $result_types=ilDBConstants::PREPARE_MANIP)
	buildManipSQL ($table, $table_fields, $mode, $where=false)

Additional Inherited Members
Static Public Member Functions inherited from ilDBPdo
static	isReservedWord ($a_word)
Static Public Member Functions inherited from ilDBInterface
static	getReservedWords ()
	Get reserved words. More...
Data Fields inherited from ilDBPdo
const	FEATURE_TRANSACTIONS = 'transactions'
const	FEATURE_FULLTEXT = 'fulltext'
const	FEATURE_SLAVE = 'slave'
Protected Attributes inherited from ilDBPdo
	$host = ''
	$dbname = ''
	$charset = 'utf8'
	$username = ''
	$password = ''
	$port = 3306
	$pdo
	$manager
	$reverse
	$limit = null
	$offset = null
	$storage_engine = 'MyISAM'
	$dsn = ''
	$attributes
	$db_type = ''
	$error_code = 0
	$field_definition

Detailed Description

Class ilDBPdoMySQL.

Author

Fabian Schmid fs@st.nosp@m.uder.nosp@m.-raim.nosp@m.ann..nosp@m.ch

Definition at line 11 of file class.ilDBPdoMySQL.php.

Member Function Documentation

doesCollationSupportMB4Strings()

ilDBPdoMySQL::doesCollationSupportMB4Strings

(

)

Implements ilDBInterface.

Definition at line 141 of file class.ilDBPdoMySQL.php.

    {
        // Currently ILIAS does not support utf8mb4, after that ilDB could check like this:
        //              static $supported;
        //              if (!isset($supported)) {
        //                      $q = "SELECT default_character_set_name FROM information_schema.SCHEMATA WHERE schema_name = %s;";
        //                      $res = $this->queryF($q, ['text'], [$this->getDbname()]);
        //                      $data = $this->fetchObject($res);
        //                      $supported = ($data->default_character_set_name === 'utf8mb4');
        //              }

        return false;
    }

getAdditionalAttributes()

ilDBPdoMySQL::getAdditionalAttributes ( )

protected

Returns

array

Definition at line 49 of file class.ilDBPdoMySQL.php.

    {
        return array(
            PDO::MYSQL_ATTR_USE_BUFFERED_QUERY => true,
            PDO::ATTR_TIMEOUT => 300 * 60,
        );
    }

initHelpers()

ilDBPdoMySQL::initHelpers

(

)

Definition at line 23 of file class.ilDBPdoMySQL.php.

    {
        $this->manager = new ilDBPdoManager($this->pdo, $this);
        $this->reverse = new ilDBPdoReverse($this->pdo, $this);
        $this->field_definition = new ilDBPdoMySQLFieldDefinition($this);
    }

initSQLMode()

ilDBPdoMySQL::initSQLMode ( )

protected

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

    {
        $this->pdo->query("SET SESSION sql_mode = 'IGNORE_SPACE,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION';");
    }

migrateAllTablesToCollation()

ilDBPdoMySQL::migrateAllTablesToCollation

(

$collation = ilDBConstants::MYSQL_COLLATION_UTF8MB4

)

Implements ilDBPdoInterface.

Definition at line 85 of file class.ilDBPdoMySQL.php.

References $errors, ilDBPdo\loadModule(), and ilDBConstants\MODULE_MANAGER.

    {
        $ilDBPdoManager = $this->loadModule(ilDBConstants::MODULE_MANAGER);
        $errors = array();
        foreach ($ilDBPdoManager->listTables() as $table_name) {
            $q = "ALTER TABLE {$this->quoteIdentifier($table_name)} CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;";
            try {
                $this->pdo->exec($q);
            } catch (PDOException $e) {
                $errors[] = $table_name;
            }
        }

        return $errors;
    }

Here is the call graph for this function:

migrateAllTablesToEngine()

ilDBPdoMySQL::migrateAllTablesToEngine

(

$engine = ilDBConstants::MYSQL_ENGINE_INNODB

)

Parameters

string

$engine

Returns

array

Implements ilDBPdoInterface.

Definition at line 62 of file class.ilDBPdoMySQL.php.

References $engine, $errors, $table, ilDBPdo\listTables(), and ilDBPdo\queryCol().

    {
        $engines = $this->queryCol('SHOW ENGINES');
        if (!in_array($engine, $engines)) {
            return array();
        }

        $errors = array();
        foreach ($this->listTables() as $table) {
            try {
                $this->pdo->exec("ALTER TABLE {$table} ENGINE={$engine}");
            } catch (Exception $e) {
                $errors[$table] = $e->getMessage();
            }
        }

        return $errors;
    }

Here is the call graph for this function:

nextId()

ilDBPdoMySQL::nextId

(

$table_name

)

Parameters

string

$table_name

Returns

int

Implements ilDBInterface.

Definition at line 115 of file class.ilDBPdoMySQL.php.

References $query, $result, ilDBPdo\getSequenceName(), ilDBPdo\query(), and ilDBPdo\quoteIdentifier().

    {
        $sequence_name = $this->quoteIdentifier($this->getSequenceName($table_name), true);
        $seqcol_name = 'sequence';
        $query = "INSERT INTO $sequence_name ($seqcol_name) VALUES (NULL)";
        try {
            $this->pdo->exec($query);
        } catch (PDOException $e) {
            // no such table check
        }

        $result = $this->query('SELECT LAST_INSERT_ID() AS next');
        $value = $result->fetchObject()->next;

        if (is_numeric($value)) {
            $query = "DELETE FROM $sequence_name WHERE $seqcol_name < $value";
            $this->pdo->exec($query);
        }

        return $value;
    }

Here is the call graph for this function:

supportsCollationMigration()

ilDBPdoMySQL::supportsCollationMigration

(

)

Implements ilDBPdoInterface.

Definition at line 105 of file class.ilDBPdoMySQL.php.

    {
        return true;
    }

supportsEngineMigration()

ilDBPdoMySQL::supportsEngineMigration

(

)

Returns

bool

Implements ilDBPdoInterface.

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

    {
        return true;
    }

supportsTransactions()

ilDBPdoMySQL::supportsTransactions

(

)

Returns

bool

Implements ilDBInterface.

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

    {
        return false;
    }

---

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

• Services/Database/classes/PDO/class.ilDBPdoMySQL.php