ilDBPdoMySQLGalera Class Reference

Class ilDBPdoMySQLInnoDB. More...

Inheritance diagram for ilDBPdoMySQLGalera:

Collaboration diagram for ilDBPdoMySQLGalera:

Public Member Functions
	supportsTransactions ()
	buildAtomQuery ()
Public Member Functions inherited from ilDBPdoMySQLInnoDB
	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)
	supportsCollationMigration ()
	nextId (string $table_name)
	doesCollationSupportMB4Strings ()
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)
	$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)
	Prepare a query (SELECT) statement to be used with execute. More...
	enableResultBuffering (bool $a_status)
	supportsSlave ()
	supportsFulltext ()
	supportsTransactions ()
	supports (string $feature)
	listTables ()
	loadModule (string $module)
	getAllowedAttributes ()
	Returns string[] More...
	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)
	supportsCollationMigration ()
	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)
	Parameters $query string to sanitize, all MB4-Characters like emojis will re replaced with ??? Returns string sanitized query More...
	doesCollationSupportMB4Strings ()
	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)
Public Member Functions inherited from ilDBInterface
	quote ($value, string $type)
	substr (string $expression)
	execute (ilDBStatement $stmt, array $data=[])

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...
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)
Protected Attributes inherited from ilDBPdoMySQLInnoDB
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
array string	$db_type = ''
int	$error_code = 0
ilDBPdoFieldDefinition	$field_definition = null

Detailed Description

Class ilDBPdoMySQLInnoDB.

Author

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

Definition at line 25 of file class.ilDBPdoMySQLGalera.php.

Member Function Documentation

buildAtomQuery()

ilDBPdoMySQLGalera::buildAtomQuery

(

)

Implements ilDBInterface.

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

                                    : ilAtomQuery
    {
        return new ilAtomQueryTransaction($this);
    }

supportsTransactions()

ilDBPdoMySQLGalera::supportsTransactions

(

)

Implements ilDBInterface.

Definition at line 28 of file class.ilDBPdoMySQLGalera.php.

                                          : bool
    {
        return true;
    }

---

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

• components/ILIAS/Database/classes/PDO/class.ilDBPdoMySQLGalera.php