InConditionBuilder
extends InConditionBuilder
in package
Class InConditionBuilder builds objects of [[InCondition]]
Table of Contents
Properties
Methods
- __construct() : mixed
- ExpressionBuilderTrait constructor.
- build() : string
- Method builds the raw SQL from the $expression that will not be additionally escaped or quoted.
- buildCompositeInCondition() : string
- Builds SQL for IN condition.
- buildSubqueryInCondition() : string
- Builds SQL for IN condition.
- buildValues() : array<string|int, mixed>
- Builds $values to be used in [[InCondition]]
- getNullCondition() : string
- Builds is null/is not null condition for column based on operator
- getRawValuesFromTraversableObject() : array<string|int, mixed>
- splitCondition() : string|null
- Oracle DBMS does not support more than 1000 parameters in `IN` condition.
Properties
$queryBuilder
protected
QueryBuilder
$queryBuilder
Methods
__construct()
ExpressionBuilderTrait constructor.
public
__construct(QueryBuilder $queryBuilder) : mixed
Parameters
- $queryBuilder : QueryBuilder
build()
Method builds the raw SQL from the $expression that will not be additionally escaped or quoted.
public
build(ExpressionInterface|InCondition $expression[, array<string|int, mixed> &$params = [] ]) : string
Parameters
- $expression : ExpressionInterface|InCondition
-
the expression to be built.
- $params : array<string|int, mixed> = []
-
the binding parameters.
Return values
string —the raw SQL that will not be additionally escaped or quoted.
buildCompositeInCondition()
Builds SQL for IN condition.
protected
buildCompositeInCondition(string $operator, array<string|int, mixed>|Traversable $columns, array<string|int, mixed> $values, array<string|int, mixed> &$params) : string
Parameters
- $operator : string
- $columns : array<string|int, mixed>|Traversable
- $values : array<string|int, mixed>
- $params : array<string|int, mixed>
Return values
string —SQL
buildSubqueryInCondition()
Builds SQL for IN condition.
protected
buildSubqueryInCondition(string $operator, array<string|int, mixed>|string $columns, Query $values, array<string|int, mixed> &$params) : string
Parameters
- $operator : string
- $columns : array<string|int, mixed>|string
- $values : Query
- $params : array<string|int, mixed>
Return values
string —SQL
buildValues()
Builds $values to be used in [[InCondition]]
protected
buildValues(ConditionInterface|InCondition $condition, array<string|int, mixed> $values, array<string|int, mixed> &$params) : array<string|int, mixed>
Parameters
- $condition : ConditionInterface|InCondition
- $values : array<string|int, mixed>
- $params : array<string|int, mixed>
-
the binding parameters
Return values
array<string|int, mixed> —of prepared for SQL placeholders
getNullCondition()
Builds is null/is not null condition for column based on operator
protected
getNullCondition(string $operator, string $column) : string
Parameters
- $operator : string
- $column : string
Tags
Return values
string —is null or is not null condition
getRawValuesFromTraversableObject()
protected
getRawValuesFromTraversableObject(Traversable $traversableObject) : array<string|int, mixed>
Parameters
- $traversableObject : Traversable
Tags
Return values
array<string|int, mixed> —raw values
splitCondition()
Oracle DBMS does not support more than 1000 parameters in `IN` condition.
protected
splitCondition(ExpressionInterface|InCondition $condition, array<string|int, mixed> &$params) : string|null
This method splits long IN condition into series of smaller ones.
Parameters
- $condition : ExpressionInterface|InCondition
-
the expression to be built.
- $params : array<string|int, mixed>
-
the binding parameters.
Return values
string|null —null when split is not required. Otherwise - built SQL condition.