ilDBPdoMySQLInnoDB Class Reference
This file is part of ILIAS, a powerful learning management system published by ILIAS open source e-Learning e.V. More...
Inheritance diagram for ilDBPdoMySQLInnoDB:
Collaboration diagram for ilDBPdoMySQLInnoDB:
Public Member Functions | |||
| supportsFulltext () | |||
| supportsTransactions () | |||
| addFulltextIndex (string $table_name, array $fields, string $name='in') | |||
| Public Member Functions inherited from ilDBPdoMySQL | |||
| supportsTransactions () | |||
| initHelpers () | |||
| supportsEngineMigration () | |||
| migrateTableToEngine (string $table_name, string $engine=ilDBConstants::MYSQL_ENGINE_INNODB) | |||
| migrateAllTablesToEngine (string $engine=ilDBConstants::MYSQL_ENGINE_INNODB) | |||
| migrateTableCollation (string $table_name, string $collation=ilDBConstants::MYSQL_COLLATION_UTF8MB4) | |||
| migrateAllTablesToCollation (string $collation=ilDBConstants::MYSQL_COLLATION_UTF8MB4) | |||
| @inheritDoc More... | |||
| supportsCollationMigration () | |||
| @inheritDoc More... | |||
| nextId (string $table_name) | |||
| doesCollationSupportMB4Strings () | |||
| @inheritDoc More... | |||
| Public Member Functions inherited from ilDBPdo | |||
| connect (bool $return_false_for_error=false) | |||
| initHelpers () | |||
| getFieldDefinition () | |||
| setFieldDefinition (\ilDBPdoFieldDefinition $field_definition) | |||
| createDatabase (string $a_name, string $a_charset="utf8", string $a_collation="") | |||
| getLastErrorCode () | |||
| initFromIniFile (?ilIniFile $ini=null) | |||
| generateDSN () | |||
| quoteIdentifier (string $identifier, bool $check_option=false) | |||
| nextId (string $table_name) | |||
| createTable (string $table_name, array $fields, bool $drop_table=false, bool $ignore_erros=false) | |||
| checkColumnName (string $a_name) | |||
| addPrimaryKey (string $table_name, array $primary_keys) | |||
| dropIndexByFields (string $table_name, array $fields) | |||
| getPrimaryKeyIdentifier () | |||
| createSequence (string $table_name, int $start=1) | |||
| tableExists (string $table_name) | |||
| tableColumnExists (string $table_name, string $column_name) | |||
| addTableColumn (string $table_name, string $column_name, array $attributes) | |||
| dropTable (string $table_name, bool $error_if_not_existing=true) | |||
| query (string $query) | |||
| fetchAll (ilDBStatement $statement, int $fetch_mode=ilDBConstants::FETCHMODE_ASSOC) | |||
| dropSequence (string $table_name) | |||
| dropTableColumn (string $table_name, string $column_name) | |||
| renameTableColumn (string $table_name, string $column_old_name, string $column_new_name) | |||
| insert (string $table_name, array $values) | |||
| fetchObject (ilDBStatement $query_result) | |||
| update (string $table_name, array $columns, array $where) | |||
| @description $where MUST contain existing columns only. More... | |||
| manipulate (string $query) | |||
| fetchAssoc (ilDBStatement $statement) | |||
| numRows (ilDBStatement $statement) | |||
| quote ($value, ?string $type=null) | |||
| indexExistsByFields (string $table_name, array $fields) | |||
| addIndex (string $table_name, array $fields, string $index_name='', bool $fulltext=false) | |||
| addFulltextIndex (string $table, array $fields, string $a_name="in") | |||
| dropFulltextIndex (string $a_table, string $a_name) | |||
| Drop fulltext index. More... | |||
| isFulltextIndex (string $a_table, string $a_name) | |||
| Is index a fulltext index? More... | |||
| getIndexName (string $index_name_base) | |||
| getSequenceName (string $table_name) | |||
| constraintName (string $a_table, string $a_constraint) | |||
| Determine contraint name by table name and constraint name. More... | |||
| getDSN () | |||
| Get DSN. More... | |||
| getDBType () | |||
| Get DSN. More... | |||
| setDBType (string $type) | |||
| lockTables (array $tables) | |||
| unlockTables () | |||
| in (string $field, array $values, bool $negate=false, string $type="") | |||
| queryF (string $query, array $types, array $values) | |||
| manipulateF (string $query, array $types, array $values) | |||
| useSlave (bool $bool) | |||
| TODO. More... | |||
| setLimit (int $limit, int $offset=0) | |||
| Set the Limit for the next Query. More... | |||
| like (string $column, string $type, string $value="?", bool $case_insensitive=true) | |||
| now () | |||
| replace (string $table, array $primary_keys, array $other_columns) | |||
| Replace into method. More... | |||
| equals (string $columns, $value, string $type, bool $emptyOrNull=false) | |||
| getHost () | |||
| setHost (string $host) | |||
| getDbname () | |||
| setDbname (string $dbname) | |||
| getCharset () | |||
| setCharset (string $charset) | |||
| getUsername () | |||
| setUsername (string $username) | |||
| getPassword () | |||
| setPassword (string $password) | |||
| getPort () | |||
| setPort (int $port) | |||
| setDBUser (string $user) | |||
| setDBPort (int $port) | |||
| setDBPassword (string $password) | |||
| setDBHost (string $host) | |||
| upper (string $expression) | |||
| lower (string $expression) | |||
| substr (string $a_exp, int $a_pos=1, int $a_len=-1) | |||
| prepareManip (string $query, ?array $types=null) | |||
| prepare (string $query, ?array $types=null, ?array $result_types=null) | |||
| enableResultBuffering (bool $a_status) | |||
| supportsSlave () | |||
| supportsFulltext () | |||
| supportsTransactions () | |||
| supports (string $feature) | |||
| listTables () | |||
| loadModule (string $module) | |||
| getAllowedAttributes () | |||
| |||
| sequenceExists (string $sequence) | |||
| listSequences () | |||
| concat (array $values, bool $allow_null=true) | |||
| locate (string $needle, string $string, int $start_pos=1) | |||
| modifyTableColumn (string $table, string $column, array $attributes) | |||
| free (ilDBStatement $a_st) | |||
| renameTable (string $name, string $new_name) | |||
| checkTableName (string $a_name) | |||
| beginTransaction () | |||
| commit () | |||
| rollback () | |||
| dropIndex (string $a_table, string $a_name="i1") | |||
| setStorageEngine (string $storage_engine) | |||
| getStorageEngine () | |||
| queryCol (string $query, int $type=PDO::FETCH_ASSOC, int $colnum=0) | |||
| queryRow (string $query, ?array $types=null, int $fetchmode=ilDBConstants::FETCHMODE_DEFAULT) | |||
| getServerVersion (bool $native=false) | |||
| escape (string $value, bool $escape_wildcards=false) | |||
| escapePattern (string $text) | |||
| migrateAllTablesToEngine (string $engine=ilDBConstants::MYSQL_ENGINE_INNODB) | |||
| migrateAllTablesToCollation (string $collation=ilDBConstants::MYSQL_COLLATION_UTF8MB4) | |||
| @inheritDoc More... | |||
| supportsCollationMigration () | |||
| @inheritDoc More... | |||
| supportsEngineMigration () | |||
| checkIndexName (string $name) | |||
| addUniqueConstraint (string $table, array $fields, string $name="con") | |||
| dropUniqueConstraint (string $table, string $name="con") | |||
| dropUniqueConstraintByFields (string $table, array $fields) | |||
| getLastInsertId () | |||
| buildAtomQuery () | |||
| uniqueConstraintExists (string $table, array $fields) | |||
| dropPrimaryKey (string $table_name) | |||
| executeMultiple (ilDBStatement $stmt, array $data) | |||
| fromUnixtime (string $expr, bool $to_text=true) | |||
| unixTimestamp () | |||
| getDBVersion () | |||
| sanitizeMB4StringIfNotSupported (string $query) | |||
| |||
| doesCollationSupportMB4Strings () | |||
| @inheritDoc More... | |||
| groupConcat (string $a_field_name, string $a_seperator=",", ?string $a_order=null) | |||
| cast (string $a_field_name, string $a_dest_type) | |||
| primaryExistsByFields (string $table_name, array $fields) | |||
| Public Member Functions inherited from ilDBInterface | |||
| doesCollationSupportMB4Strings () | |||
| sanitizeMB4StringIfNotSupported (string $query) | |||
| initFromIniFile (?ilIniFile $ini=null) | |||
| connect (bool $return_false_on_error=false) | |||
| nextId (string $table_name) | |||
| createTable (string $table_name, array $fields, bool $drop_table=false, bool $ignore_erros=false) | |||
| addPrimaryKey (string $table_name, array $primary_keys) | |||
| createSequence (string $table_name, int $start=1) | |||
| getSequenceName (string $table_name) | |||
| tableExists (string $table_name) | |||
| tableColumnExists (string $table_name, string $column_name) | |||
| addTableColumn (string $table_name, string $column_name, array $attributes) | |||
| dropTable (string $table_name, bool $error_if_not_existing=true) | |||
| renameTable (string $old_name, string $new_name) | |||
| query (string $query) | |||
| Run a (read-only) Query on the database. More... | |||
| fetchAll (ilDBStatement $statement, int $fetch_mode=ilDBConstants::FETCHMODE_ASSOC) | |||
| dropSequence (string $table_name) | |||
| dropTableColumn (string $table_name, string $column_name) | |||
| renameTableColumn (string $table_name, string $column_old_name, string $column_new_name) | |||
| insert (string $table_name, array $values) | |||
| fetchObject (ilDBStatement $query_result) | |||
| update (string $table_name, array $values, array $where) | |||
| @description $where MUST contain existing columns only. More... | |||
| manipulate (string $query) | |||
| Run a (write) Query on the database. More... | |||
| fetchAssoc (ilDBStatement $statement) | |||
| numRows (ilDBStatement $statement) | |||
| quote ($value, string $type) | |||
| addIndex (string $table_name, array $fields, string $index_name='', bool $fulltext=false) | |||
| indexExistsByFields (string $table_name, array $fields) | |||
| getDSN () | |||
| Get DSN. More... | |||
| getDBType () | |||
| Get DSN. More... | |||
| lockTables (array $tables) | |||
| Abstraction of lock table. More... | |||
| unlockTables () | |||
| Unlock tables locked by previous lock table calls. More... | |||
| in (string $field, array $values, bool $negate=false, string $type="") | |||
| queryF (string $query, array $types, array $values) | |||
| manipulateF (string $query, array $types, array $values) | |||
| useSlave (bool $bool) | |||
| setLimit (int $limit, int $offset=0) | |||
| like (string $column, string $type, string $value="?", bool $case_insensitive=true) | |||
| Generate a like subquery. More... | |||
| now () | |||
| replace (string $table, array $primary_keys, array $other_columns) | |||
| Replace into method. More... | |||
| equals (string $columns, $value, string $type, bool $emptyOrNull=false) | |||
| setDBUser (string $user) | |||
| setDBPort (int $port) | |||
| setDBPassword (string $password) | |||
| setDBHost (string $host) | |||
| upper (string $expression) | |||
| lower (string $expression) | |||
| substr (string $expression) | |||
| prepare (string $a_query, array $a_types=null, array $a_result_types=null) | |||
| Prepare a query (SELECT) statement to be used with execute. More... | |||
| prepareManip (string $a_query, ?array $a_types=null) | |||
| enableResultBuffering (bool $a_status) | |||
| execute (ilDBStatement $stmt, array $data=[]) | |||
| sequenceExists (string $sequence) | |||
| listSequences () | |||
| supports (string $feature) | |||
| supportsFulltext () | |||
| supportsSlave () | |||
| supportsTransactions () | |||
| listTables () | |||
| loadModule (string $module) | |||
| getAllowedAttributes () | |||
| concat (array $values, bool $allow_null=true) | |||
| locate (string $needle, string $string, int $start_pos=1) | |||
| quoteIdentifier (string $identifier, bool $check_option=false) | |||
| modifyTableColumn (string $table, string $column, array $attributes) | |||
| free (ilDBStatement $a_st) | |||
| checkTableName (string $a_name) | |||
| beginTransaction () | |||
| commit () | |||
| rollback () | |||
| constraintName (string $a_table, string $a_constraint) | |||
| dropIndex (string $a_table, string $a_name="i1") | |||
| createDatabase (string $a_name, string $a_charset="utf8", string $a_collation="") | |||
| dropIndexByFields (string $table_name, array $afields) | |||
| getPrimaryKeyIdentifier () | |||
| addFulltextIndex (string $table_name, array $afields, string $a_name='in') | |||
| dropFulltextIndex (string $a_table, string $a_name) | |||
| isFulltextIndex (string $a_table, string $a_name) | |||
| setStorageEngine (string $storage_engine) | |||
| getStorageEngine () | |||
| buildAtomQuery () | |||
| groupConcat (string $a_field_name, string $a_seperator=",", ?string $a_order=null) | |||
| cast (string $a_field_name, string $a_dest_type) | |||
| primaryExistsByFields (string $table_name, array $fields) | |||
| getServerVersion (bool $native=false) | |||
| queryCol (string $query, int $type=ilDBConstants::FETCHMODE_DEFAULT, int $colnum=0) | |||
| queryRow (string $query, ?array $types=null, int $fetchmode=ilDBConstants::FETCHMODE_DEFAULT) | |||
| escape (string $value, bool $escape_wildcards=false) | |||
| escapePattern (string $text) | |||
| migrateTableToEngine (string $table_name, string $engine=ilDBConstants::MYSQL_ENGINE_INNODB) | |||
| migrateAllTablesToEngine (string $engine=ilDBConstants::MYSQL_ENGINE_INNODB) | |||
| supportsEngineMigration () | |||
| migrateTableCollation (string $table_name, string $collation=ilDBConstants::MYSQL_COLLATION_UTF8MB4) | |||
| migrateAllTablesToCollation (string $collation=ilDBConstants::MYSQL_COLLATION_UTF8MB4) | |||
| supportsCollationMigration () | |||
| addUniqueConstraint (string $table, array $fields, string $name="con") | |||
| dropUniqueConstraint (string $table, string $name="con") | |||
| dropUniqueConstraintByFields (string $table, array $fields) | |||
| checkIndexName (string $name) | |||
| getLastInsertId () | |||
| uniqueConstraintExists (string $table, array $fields) | |||
| dropPrimaryKey (string $table_name) | |||
| executeMultiple (ilDBStatement $stmt, array $data) | |||
| fromUnixtime (string $expr, bool $to_text=true) | |||
| unixTimestamp () | |||
| getDBVersion () | |||
| returns the Version of the Database (e.g. More... | |||
Protected Attributes | |
| string | $storage_engine = 'InnoDB' |
| Protected Attributes inherited from ilDBPdoMySQL | |
| array | $modes |
| Protected Attributes inherited from ilDBPdo | |
| string | $host = '' |
| string | $dbname = '' |
| string | $charset = 'utf8' |
| string | $username = '' |
| string | $password = '' |
| int | $port = 3306 |
| PDO | $pdo = null |
| ilDBPdoManager | $manager |
| ilDBPdoReverse | $reverse |
| int | $limit = null |
| int | $offset = null |
| string | $storage_engine = 'InnoDB' |
| string | $dsn = '' |
| array | $attributes |
| string | $db_type = '' |
| int | $error_code = 0 |
| ilDBPdoFieldDefinition | $field_definition = null |
Additional Inherited Members | |
| Static Public Member Functions inherited from ilDBPdo | |
| static | isReservedWord (string $a_word) |
| Static Public Member Functions inherited from ilDBInterface | |
| static | getReservedWords () |
| Get reserved words. More... | |
| static | isReservedWord (string $a_word) |
| Data Fields inherited from ilDBPdo | |
| array | $options = [] |
| const | FEATURE_TRANSACTIONS = 'transactions' |
| const | FEATURE_FULLTEXT = 'fulltext' |
| const | FEATURE_SLAVE = 'slave' |
| Protected Member Functions inherited from ilDBPdoMySQL | |
| initSQLMode () | |
| getAdditionalAttributes () | |
| Protected Member Functions inherited from ilDBPdo | |
| initSQLMode () | |
| getAttributes () | |
| getAdditionalAttributes () | |
| checkTableColumns (array $a_cols) | |
| checkColumn (string $a_col, array $a_def) | |
| checkColumnDefinition (array $a_def, bool $a_modify_mode=false) | |
| appendLimit (string $query) | |
Detailed Description
This file is part of ILIAS, a powerful learning management system published by ILIAS open source e-Learning e.V.
ILIAS is licensed with the GPL-3.0, see https://www.gnu.org/licenses/gpl-3.0.en.html You should have received a copy of said license along with the source code, too.
If this is not the case or you just want to try ILIAS, you'll find us at: https://www.ilias.de https://github.com/ILIAS-eLearning Class ilDBPdoMySQLInnoDB
Definition at line 25 of file class.ilDBPdoMySQLInnoDB.php.
Member Function Documentation
◆ addFulltextIndex()
| ilDBPdoMySQLInnoDB::addFulltextIndex | ( | string | $table, |
| array | $fields, | ||
| string | $a_name = 'in' |
||
| ) |
- Exceptions
-
Reimplemented from ilDBPdo.
Definition at line 41 of file class.ilDBPdoMySQLInnoDB.php.
41 : bool
42 {
43 return false; // NOT SUPPORTED
44 }
◆ supportsFulltext()
| ilDBPdoMySQLInnoDB::supportsFulltext | ( | ) |
Reimplemented from ilDBPdo.
Definition at line 29 of file class.ilDBPdoMySQLInnoDB.php.
29 : bool
30 {
31 return false;
32 }
◆ supportsTransactions()
| ilDBPdoMySQLInnoDB::supportsTransactions | ( | ) |
Reimplemented from ilDBPdoMySQL.
Reimplemented in ilDBPdoMySQLGalera.
Definition at line 35 of file class.ilDBPdoMySQLInnoDB.php.
35 : bool
36 {
37 return false;
38 }
Field Documentation
◆ $storage_engine
|
protected |
Definition at line 27 of file class.ilDBPdoMySQLInnoDB.php.
The documentation for this class was generated from the following file:
- Services/Database/classes/PDO/class.ilDBPdoMySQLInnoDB.php
