Elgg
Version 6.0
|
Query builder for updating data in the database. More...
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 |
Query builder for updating data in the database.
Definition at line 8 of file Delete.php.
|
static |
Returns a QueryBuilder for deleting data from a given table.
string | $table | table name |
Definition at line 17 of file Delete.php.