Elgg\Database\Update Class Reference

Query builder for updating data in the database. More...

Inheritance diagram for Elgg\Database\Update:

Static Public Member Functions
static	table (string $table)
	Returns a QueryBuilder for updating data in a given table. More...

Additional Inherited Members
Public Member Functions inherited from Elgg\Database\QueryBuilder
	__construct (protected readonly Connection $backup_connection)
	Initializes a new QueryBuilder. More...
	getConnection ()
	Returns the connection. More...
	subquery (string $table,?string $alias=null)
	Creates a new SelectQueryBuilder for join/where sub queries using the DB connection of the primary QueryBuilder. More...
	addClause (Clause $clause,?string $alias=null)
	Apply clause to this instance. More...
	prefix (string $table)
	Prefixes the table name with installation DB prefix. More...
	getTableName ()
	Returns the name of the primary table. More...
	getTableAlias ()
	Returns the alias of the primary table. More...
	param ($value, string $type=ELGG_VALUE_STRING,?string $key=null)
	Sets a new parameter assigning it a unique parameter key/name if none provided Returns the name of the new parameter. More...
	execute (bool $track_query=true)
	from (string $table,?string $alias=null)
	{} More...
	insert (string $table)
	{} More...
	update (string $table)
	{} More...
	delete (string $table)
	{} More...
	join (string $fromAlias, string $join, string $alias,?string $condition=null)
	{} More...
	innerJoin (string $fromAlias, string $join, string $alias,?string $condition=null)
	{} More...
	leftJoin (string $fromAlias, string $join, string $alias,?string $condition=null)
	{} More...
	rightJoin (string $fromAlias, string $join, string $alias,?string $condition=null)
	{} More...
	orderBy (string $sort,?string $order=null)
	{} More...
	addOrderBy (string $sort,?string $order=null)
	{} More...
	merge ($parts=null, $boolean= 'AND')
	Merges multiple composite expressions with a boolean. More...
	compare (string $x, string $comparison, $y=null,?string $type=null,?bool $case_sensitive=null)
	Build value comparison clause. More...
	between (string $x, $lower=null, $upper=null,?string $type=null)
	Build a between clause. More...
	getNextJoinAlias ()
	Get an index of the next available join alias. More...
	joinEntitiesTable (string $from_alias= '', string $from_column= 'guid',?string $join_type= 'inner',?string $joined_alias=null)
	Join entity table from alias and return joined table alias. More...
	joinMetadataTable (string $from_alias= '', string $from_column= 'guid', $name=null,?string $join_type= 'inner',?string $joined_alias=null)
	Join metadata table from alias and return joined table alias. More...
	joinAnnotationTable (string $from_alias= '', string $from_column= 'guid', $name=null,?string $join_type= 'inner',?string $joined_alias=null)
	Join annotations table from alias and return joined table alias. More...
	joinRelationshipTable (string $from_alias= '', string $from_column= 'guid', $name=null, bool $inverse=false,?string $join_type= 'inner',?string $joined_alias=null)
	Join relationship table from alias and return joined table alias. More...
Public Attributes inherited from Elgg\Database\QueryBuilder
const	CALCULATIONS
Protected Attributes inherited from Elgg\Database\QueryBuilder
array	$joins = []
int	$join_index = 0
string	$table_name = null
string	$table_alias = null

Detailed Description

Query builder for updating data in the database.

Definition at line 8 of file Update.php.

Member Function Documentation

static Elgg\Database\Update::table ( string  $table )

static

Returns a QueryBuilder for updating data in a given table.

Parameters

string

$table

table name

Returns

static

Definition at line 17 of file Update.php.

---

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

• engine/classes/Elgg/Database/Update.php