Query builder for inserting data into the database. More...
Inheritance diagram for Elgg\Database\Insert:
Static Public Member Functions | |
| static | intoTable (string $table) |
| Returns a QueryBuilder for inserting 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 inserting data into the database.
Definition at line 8 of file Insert.php.
Member Function Documentation
◆ intoTable()
|
static |
Returns a QueryBuilder for inserting data in a given table.
- Parameters
-
string $table table name
- Returns
- static
Definition at line 17 of file Insert.php.
The documentation for this class was generated from the following file:
- engine/classes/Elgg/Database/Insert.php
