HumHub Documentation (unofficial)

InConditionBuilder
in package
implements ExpressionBuilderInterface uses ExpressionBuilderTrait

Class InConditionBuilder builds objects of [[InCondition]]

Tags
author

Dmytro Naumenko d.naumenko.a@gmail.com

since
2.0.14

Table of Contents

Interfaces

ExpressionBuilderInterface
Interface ExpressionBuilderInterface is designed to build raw SQL from specific expression objects that implement [[ExpressionInterface]].

Properties

$queryBuilder  : QueryBuilder

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>

Properties

Methods

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
since
2.0.31
Return values
string —

is null or is not null condition

getRawValuesFromTraversableObject()

protected getRawValuesFromTraversableObject(Traversable $traversableObject) : array<string|int, mixed>
Parameters
$traversableObject : Traversable
Tags
since
2.0.31
Return values
array<string|int, mixed> —

raw values


        

        
    




    

    

                                

                

                                
    

        On this page

        
    


                

                            

            

    

        

            
Search results