|
Elgg
Version 6.1
|
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.
1.8.11
