InConditionBuilder

API reference › yii › db › sqlite › conditions › InConditionBuilder

class	yii\db\sqlite\conditions\InConditionBuilder
Extends	yii\db\conditions\InConditionBuilder
Implements	yii\db\ExpressionBuilderInterface
Uses traits	yii\db\ExpressionBuilderTrait
Since	2.0.14
Source	framework/db/sqlite/conditions/InConditionBuilder.php

Builds objects of InCondition.

Properties

Property	Type	Description	Defined by
$queryBuilder protected	yii\db\QueryBuilder	Default: null.	yii\db\ExpressionBuilderTrait

Methods

Method	Description	Defined by
__construct()	ExpressionBuilderTrait constructor.	yii\db\ExpressionBuilderTrait
build()	Builds raw SQL from the expression.	yii\db\conditions\InConditionBuilder
buildCompositeInCondition() protected	Builds SQL for composite IN condition.	yii\db\conditions\InConditionBuilder
buildSubqueryInCondition() protected	Builds SQL for IN condition.	InConditionBuilder
buildValues() protected	Builds values to be used in InCondition.	yii\db\conditions\InConditionBuilder
getNotEqualOperator() protected	Returns inequality operator for decomposed NOT IN conditions.	InConditionBuilder
getNullCondition() protected	Builds IS NULL / IS NOT NULL condition for a scalar column based on the operator.	yii\db\conditions\InConditionBuilder

Method details

buildSubqueryInCondition()

protected function buildSubqueryInCondition(string $operator, array|string|yii\db\ExpressionInterface $columns, yii\db\Query $values, array &$params): string

Builds SQL for IN condition.

Parameters

Parameter	Type	Description
$operator	string	Operator in uppercase.
$columns	array|string|yii\db\ExpressionInterface	The columns to be matched.
$values	yii\db\Query	Subquery values.
$params	array	The binding parameters.

Returns

string: SQL for IN condition.

Throws

• yii\base\NotSupportedException: if $columns is an array

getNotEqualOperator()

protected function getNotEqualOperator(): string

Returns inequality operator for decomposed NOT IN conditions.

Returns

string: Inequality operator.