ILIAS\Database\Connection Interface Reference
Wrapper for the Setup to work, as they require a namespace. More...
Inheritance diagram for ILIAS\Database\Connection:
Collaboration diagram for ILIAS\Database\Connection:
Additional Inherited Members | |
| 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) | |
| addForeignKey (string $foreign_key_name, array $field_names, string $table_name, array $reference_field_names, string $reference_table, ?ForeignKeyConstraints $on_update=null, ?ForeignKeyConstraints $on_delete=null) | |
| dropForeignKey (string $foreign_key_name, string $table_name) | |
| foreignKeyExists (string $foreign_key_name, string $table_name) | |
| buildIntegrityAnalyser () | |
| primaryExistsByFields (string $table_name, array $fields) | |
| Static Public Member Functions inherited from ilDBInterface | |
| static | getReservedWords () |
| Get reserved words. More... | |
| static | isReservedWord (string $a_word) |
Detailed Description
Wrapper for the Setup to work, as they require a namespace.
Definition at line 26 of file Connection.php.
The documentation for this interface was generated from the following file:
- components/ILIAS/Database/src/Connection.php
