ilDBManager Interface Reference

Interface ilDBManager. More...

Inheritance diagram for ilDBManager:

Collaboration diagram for ilDBManager:

Public Member Functions
	listTables (?string $database=null)
	listSequences (?string $database=null)
	createConstraint (string $table, string $name, array $definition)
	listTableFields (string $table)
	listTableConstraints (string $table)
	createSequence (string $seq_name, int $start=1, array $options=[])
	listTableIndexes (string $table)
	alterTable (string $name, array $changes, bool $check)
	createIndex (string $table, string $name, array $definition)
	dropIndex (string $table, string $name)
	dropSequence (string $seq_name)
	dropConstraint (string $table, string $name, bool $primary=false)
	dropTable (string $name)
	getQueryUtils ()
	createTable (string $name, array $fields, array $options=[])
	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)
	foreignKeyExists (string $foreign_key_name, string $table_name)
	dropForeignKey (string $foreign_key_name, string $table_name)

Detailed Description

Interface ilDBManager.

Author

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

Definition at line 27 of file ilDBManager.php.

Member Function Documentation

addForeignKey()

ilDBManager::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
	)

Parameters

string[]	$field_names
string[]	$reference_field_names

Implemented in ilDBPdoManager.

alterTable()

ilDBManager::alterTable	(	string	$name,
		array	$changes,
		bool	$check
	)

Implemented in ilDBPdoManager.

createConstraint()

ilDBManager::createConstraint	(	string	$table,
		string	$name,
		array	$definition
	)

Implemented in ilDBPdoManager.

Referenced by ilDBPdo\addUniqueConstraint().

Here is the caller graph for this function:

createIndex()

ilDBManager::createIndex	(	string	$table,
		string	$name,
		array	$definition
	)

Implemented in ilDBPdoManager.

createSequence()

ilDBManager::createSequence	(	string	$seq_name,
		int	$start = 1,
		array	$options = []
	)

Implemented in ilDBPdoManager.

createTable()

ilDBManager::createTable	(	string	$name,
		array	$fields,
		array	$options = []
	)

Implemented in ilDBPdoManager.

dropConstraint()

ilDBManager::dropConstraint	(	string	$table,
		string	$name,
		bool	$primary = false
	)

Implemented in ilDBPdoManager.

dropForeignKey()

ilDBManager::dropForeignKey	(	string	$foreign_key_name,
		string	$table_name
	)

Implemented in ilDBPdoManager.

dropIndex()

ilDBManager::dropIndex	(	string	$table,
		string	$name
	)

Implemented in ilDBPdoManager.

dropSequence()

ilDBManager::dropSequence

(

string

$seq_name

)

Implemented in ilDBPdoManager.

dropTable()

ilDBManager::dropTable

(

string

$name

)

Parameters

$name

string

Implemented in ilDBPdoManager.

foreignKeyExists()

ilDBManager::foreignKeyExists	(	string	$foreign_key_name,
		string	$table_name
	)

Implemented in ilDBPdoManager.

getQueryUtils()

ilDBManager::getQueryUtils

(

)

Implemented in ilDBPdoManager.

listSequences()

ilDBManager::listSequences

(

?string

$database = null

)

Returns

string[]

Implemented in ilDBPdoManager.

listTableConstraints()

ilDBManager::listTableConstraints

(

string

$table

)

Returns

string[]

Implemented in ilDBPdoManager.

listTableFields()

ilDBManager::listTableFields

(

string

$table

)

Returns

string[]

Implemented in ilDBPdoManager.

listTableIndexes()

ilDBManager::listTableIndexes

(

string

$table

)

Returns

string[]

Implemented in ilDBPdoManager.

listTables()

ilDBManager::listTables

(

?string

$database = null

)

Returns

string[]

Implemented in ilDBPdoManager.

---

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

• components/ILIAS/Database/interfaces/ilDBManager.php