Class TupleComparison

This expression represents SQL fragments that are used for comparing one tuple to another, one tuple to a set of other tuples or one tuple to an expression

Namespace: Cake\Database\Expression

Property Summary

$_field protected

Cake\Database\ExpressionInterface|array|string

The field name or expression to be used in the left hand side of the operator
$_isMultiple protected

bool

Whether the value in this expression is a traversable
$_operator protected

string

The operator used for comparing field and value
$_type protected

string|null

The type to be used for casting the value to a database representation
$_value protected

mixed

The value to be used in the right hand side of the operation
$_valueExpressions protected

arrayCake\Database\ExpressionInterface>

A cached list of ExpressionInterface objects that were found in the value for this expression.
$types protected

array<string|null>

The type to be used for casting the value to a database representation

Method Summary

__clone() public

Create a deep clone.
__construct() public

Constructor
_bindValue() protected

Registers a value in the placeholder generator and returns the generated placeholder
_castToExpression() protected

Conditionally converts the passed value to an ExpressionInterface object if the type class implements the ExpressionTypeInterface. Otherwise, returns the value unmodified.
_collectExpressions() protected

Returns an array with the original $values in the first position and all ExpressionInterface objects that could be found in the second position.
_flattenValue() protected

Converts a traversable value into a set of placeholders generated by $binder and separated by ,
_requiresToExpressionCasting() protected

Returns an array with the types that require values to be casted to expressions, out of the list of type names passed as parameter.
_stringExpression() protected

Returns a template and a placeholder for the value after registering it with the placeholder $binder
_stringifyValues() protected

Returns a string with the values as placeholders in a string to be used for the SQL version of this expression
_traverseValue() protected

Conditionally executes the callback for the passed value if it is an ExpressionInterface
getField() public

Returns the field name
getOperator() public

Returns the operator used for comparison
getType() public

Returns the type to be used for casting the value to a database representation
getValue() public

Returns the value used for comparison
isMulti() public

Determines if each of the values in this expressions is a tuple in itself
setField() public

Sets the field name
setOperator() public

Sets the operator to use for the comparison
setValue() public

Sets the value
sql() public

Converts the Node into a SQL string fragment.
traverse() public

Iterates over each part of the expression recursively for every level of the expressions tree and executes the callback, passing as first parameter the instance of the expression currently being iterated.

Method Detail

__clone() ¶ public

__clone(): void

Create a deep clone.

Clones the field and value if they are expression objects.

Returns

void

__construct() ¶ public

__construct(Cake\Database\ExpressionInterface|array|string $fields, Cake\Database\ExpressionInterface|array $values, array<string|null> $types = [], string $conjunction = '=')

Constructor

Parameters

Cake\Database\ExpressionInterface|array|string $fields: the fields to use to form a tuple
Cake\Database\ExpressionInterface|array $values: the values to use to form a tuple
array<string|null> $types optional: the types names to use for casting each of the values, only one type per position in the value array in needed
string $conjunction optional: the operator used for comparing field and value

_bindValue() ¶ protected

_bindValue(mixed $value, Cake\Database\ValueBinder $binder, string|null $type = null): string

Registers a value in the placeholder generator and returns the generated placeholder

Parameters

mixed $value
Cake\Database\ValueBinder $binder
string|null $type optional

Returns

string

_castToExpression() ¶ protected

_castToExpression(mixed $value, string|null $type = null): mixed

Conditionally converts the passed value to an ExpressionInterface object if the type class implements the ExpressionTypeInterface. Otherwise, returns the value unmodified.

Parameters

mixed $value: The value to convert to ExpressionInterface
string|null $type optional: The type name

Returns

mixed

_collectExpressions() ¶ protected

_collectExpressions(Cake\Database\ExpressionInterface|iterable $values): array

Returns an array with the original $values in the first position and all ExpressionInterface objects that could be found in the second position.

Parameters

Cake\Database\ExpressionInterface|iterable $values: The rows to insert

Returns

array

_flattenValue() ¶ protected

_flattenValue(iterable $value, Cake\Database\ValueBinder $binder, string|null $type = null): string

Converts a traversable value into a set of placeholders generated by $binder and separated by ,

Parameters

iterable $value: the value to flatten
Cake\Database\ValueBinder $binder: The value binder to use
string|null $type optional: the type to cast values to

Returns

string

_requiresToExpressionCasting() ¶ protected

_requiresToExpressionCasting(array $types): array

Returns an array with the types that require values to be casted to expressions, out of the list of type names passed as parameter.

Parameters

array $types: List of type names

Returns

array

_stringExpression() ¶ protected

_stringExpression(Cake\Database\ValueBinder $binder): array

Returns a template and a placeholder for the value after registering it with the placeholder $binder

Parameters

Cake\Database\ValueBinder $binder: The value binder to use.

Returns

array

_stringifyValues() ¶ protected

_stringifyValues(Cake\Database\ValueBinder $binder): string

Returns a string with the values as placeholders in a string to be used for the SQL version of this expression

Parameters

Cake\Database\ValueBinder $binder: The value binder to convert expressions with.

Returns

string

_traverseValue() ¶ protected

_traverseValue(mixed $value, Closure $callback): void

Conditionally executes the callback for the passed value if it is an ExpressionInterface

Parameters

mixed $value: The value to traverse
Closure $callback: The callback to use when traversing

Returns

void

getField() ¶ public

getField(): Cake\Database\ExpressionInterface|array|string

Returns the field name

Returns

Cake\Database\ExpressionInterface|array|string

getOperator() ¶ public

getOperator(): string

Returns the operator used for comparison

Returns

string

getType() ¶ public

getType(): array<string|null>

Returns the type to be used for casting the value to a database representation

Returns

array<string|null>

getValue() ¶ public

getValue(): mixed

Returns the value used for comparison

Returns

mixed

isMulti() ¶ public

isMulti(): bool

Determines if each of the values in this expressions is a tuple in itself

Returns

bool

setField() ¶ public

setField(Cake\Database\ExpressionInterface|array|string $field): void

Sets the field name

Parameters

Cake\Database\ExpressionInterface|array|string $field: The field to compare with.

Returns

void

setOperator() ¶ public

setOperator(string $operator): void

Sets the operator to use for the comparison

Parameters

string $operator: The operator to be used for the comparison.

Returns

void

setValue() ¶ public

setValue(mixed $value): void

Sets the value

Parameters

mixed $value: The value to compare

Returns

void

sql() ¶ public

sql(Cake\Database\ValueBinder $binder): string

Converts the Node into a SQL string fragment.

Parameters

Cake\Database\ValueBinder $binder

Returns

string

traverse() ¶ public

traverse(Closure $callback): $this

Iterates over each part of the expression recursively for every level of the expressions tree and executes the callback, passing as first parameter the instance of the expression currently being iterated.

Parameters

Closure $callback

Returns

$this

Property Detail

`$_field` ¶ protected

The field name or expression to be used in the left hand side of the operator

Type

Cake\Database\ExpressionInterface|array|string

`$_isMultiple` ¶ protected

Whether the value in this expression is a traversable

Type

bool

`$_operator` ¶ protected

The operator used for comparing field and value

Type

string

`$_type` ¶ protected

The type to be used for casting the value to a database representation

Type

string|null

`$_value` ¶ protected

The value to be used in the right hand side of the operation

Type

mixed

`$_valueExpressions` ¶ protected

A cached list of ExpressionInterface objects that were found in the value for this expression.

Type

arrayCake\Database\ExpressionInterface>

`$types` ¶ protected

The type to be used for casting the value to a database representation

Type

array<string|null>

Namespaces

Class TupleComparison

Property Summary

Method Summary

__clone() public

__construct() public

_bindValue() protected

_castToExpression() protected

_collectExpressions() protected

_flattenValue() protected

_requiresToExpressionCasting() protected

_stringExpression() protected

_stringifyValues() protected

_traverseValue() protected

getField() public

getOperator() public

getType() public

getValue() public

isMulti() public

setField() public

setOperator() public

setValue() public

sql() public

traverse() public

Method Detail

__clone() ¶ public

Returns

__construct() ¶ public

Parameters

_bindValue() ¶ protected

Parameters

Returns

_castToExpression() ¶ protected

Parameters

Returns

_collectExpressions() ¶ protected

Parameters

Returns

_flattenValue() ¶ protected

Parameters

Returns

_requiresToExpressionCasting() ¶ protected

Parameters

Returns

_stringExpression() ¶ protected

Parameters

Returns

_stringifyValues() ¶ protected

Parameters

Returns

_traverseValue() ¶ protected

Parameters

Returns

getField() ¶ public

Returns

getOperator() ¶ public

Returns

getType() ¶ public

Returns

getValue() ¶ public

Returns

isMulti() ¶ public

Returns

setField() ¶ public

Parameters

Returns

setOperator() ¶ public

Parameters

Returns

setValue() ¶ public

Parameters

Returns

sql() ¶ public

Parameters

Returns

traverse() ¶ public

Parameters

Returns

Property Detail

$_field ¶ protected

`$_field` ¶ protected

`$_isMultiple` ¶ protected

`$_operator` ¶ protected

`$_type` ¶ protected

`$_value` ¶ protected

`$_valueExpressions` ¶ protected

`$types` ¶ protected