MultiTableUpdateExecutor
extends AbstractSqlExecutor
in package
Executes the SQL statements for bulk DQL UPDATE statements on classes in Class Table Inheritance (JOINED).
Table of Contents
- $_sqlStatements : array<string|int, mixed>|string
- $queryCacheProfile : QueryCacheProfile
- $_createTempTableSql : string
- $_dropTempTableSql : string
- $_insertSql : string
- $_numParametersInUpdateClause : int
- $_sqlParameters : array<string|int, mixed>
- __construct() : mixed
- Initializes a new <tt>MultiTableUpdateExecutor</tt>.
- execute() : int
- Executes all sql statements.
- getSqlStatements() : array<string|int, mixed>|string
- Gets the SQL statements that are executed by the executor.
- removeQueryCacheProfile() : void
- Do not use query cache
- setQueryCacheProfile() : void
Properties
$_sqlStatements
protected
array<string|int, mixed>|string
$_sqlStatements
$queryCacheProfile
protected
QueryCacheProfile
$queryCacheProfile
$_createTempTableSql
private
string
$_createTempTableSql
$_dropTempTableSql
private
string
$_dropTempTableSql
$_insertSql
private
string
$_insertSql
$_numParametersInUpdateClause
private
int
$_numParametersInUpdateClause
= 0
$_sqlParameters
private
array<string|int, mixed>
$_sqlParameters
= []
Methods
__construct()
Initializes a new <tt>MultiTableUpdateExecutor</tt>.
public
__construct(UpdateStatement $AST, SqlWalker $sqlWalker) : mixed
Internal note: Any SQL construction and preparation takes place in the constructor for best performance. With a query cache the executor will be cached.
Parameters
- $AST : UpdateStatement
-
The root AST node of the DQL query.
- $sqlWalker : SqlWalker
-
The walker used for SQL generation from the AST.
Return values
mixed —execute()
Executes all sql statements.
public
execute(Connection $conn, array<string|int, mixed> $params, array<string|int, mixed> $types) : int
Parameters
- $conn : Connection
-
The database connection that is used to execute the queries.
- $params : array<string|int, mixed>
- $types : array<string|int, mixed>
Return values
int —getSqlStatements()
Gets the SQL statements that are executed by the executor.
public
getSqlStatements() : array<string|int, mixed>|string
Return values
array<string|int, mixed>|string —All the SQL update statements.
removeQueryCacheProfile()
Do not use query cache
public
removeQueryCacheProfile() : void
Return values
void —setQueryCacheProfile()
public
setQueryCacheProfile(QueryCacheProfile $qcp) : void
Parameters
- $qcp : QueryCacheProfile