Elgg  Version 6.0
Static Public Member Functions | List of all members
Elgg\Database\Delete Class Reference

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

Inheritance diagram for Elgg\Database\Delete:
Elgg\Database\QueryBuilder

Static Public Member Functions

static fromTable (string $table)
 Returns a QueryBuilder for deleting data from 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 Delete.php.

Member Function Documentation

static Elgg\Database\Delete::fromTable ( string  $table)
static

Returns a QueryBuilder for deleting data from a given table.

Parameters
string$tabletable name
Returns
static

Definition at line 17 of file Delete.php.


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