Class CaseExpression
This class represents a SQL Case statement
Properties summary
- $_conditions protected
arrayA list of strings or other expression objects that represent the conditions of the case statement. For example one key of the array might look like "sum > :value"
- $_elseValue protected
string|\Cake\Database\ExpressionInterface|array|nullThe
ELSEvalue for the case statement. If null then noELSEwill be included. - $_values protected
arrayValues that are associated with the conditions in the $_conditions array.
Method Summary
- _addExpressions() protected
Iterates over the passed in conditions and ensures that there is a matching true value for each.
- _castToExpression() protected
Conditionally converts the passed value to an ExpressionInterface object if the type class implements the ExpressionTypeInterface. Otherwise, returns the value unmodified.
- _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.
- traverse() public
Iterates over each part of the expression recursively for every level of the expressions tree and executes the $visitor callable passing as first parameter the instance of the expression currently being iterated.
Method Detail
__construct() public
__construct(mixed $conditions, mixed $values, mixed $types)
Constructs the case expression
Parameters
-
array|\Cake\Database\ExpressionInterface$conditions optional The conditions to test. Must be a ExpressionInterface instance, or an array of ExpressionInterface instances.
-
array|\Cake\Database\ExpressionInterface$values optional associative array of values to be associated with the conditions passed in $conditions. If there are more $values than $conditions, the last $value is used as the
ELSEvalue-
array$types optional associative array of types to be associated with the values passed in $values
_addExpressions() protected
_addExpressions(mixed $conditions, mixed $values, mixed $types)
Iterates over the passed in conditions and ensures that there is a matching true value for each.
If no matching true value, then it is defaulted to '1'.
Parameters
-
array|\Cake\Database\ExpressionInterface$conditions Must be a ExpressionInterface instance, or an array of ExpressionInterface instances.
-
array|\Cake\Database\ExpressionInterface$values associative array of values of each condition
-
array$types associative array of types to be associated with the values
_castToExpression() protected
_castToExpression(mixed $value, mixed $type)
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 converto to ExpressionInterface
-
string$type The type name
Returns
mixed_compile() protected
_compile(mixed $part, \Cake\Database\ValueBinder $generator)
Compiles the relevant parts into sql
Parameters
-
array|string|\Cake\Database\ExpressionInterface$part The part to compile
-
\Cake\Database\ValueBinder$generator Sql generator
Returns
string_requiresToExpressionCasting() protected
_requiresToExpressionCasting(mixed $types)
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
arrayadd() public
add(mixed $conditions, mixed $values, mixed $types)
Adds one or more conditions and their respective true values to the case object.
Conditions must be a one dimensional array or a QueryExpression. The trueValues must be a similar structure, but may contain a string value.
Parameters
-
array|\Cake\Database\ExpressionInterface$conditions optional Must be a ExpressionInterface instance, or an array of ExpressionInterface instances.
-
array|\Cake\Database\ExpressionInterface$values optional associative array of values of each condition
-
array$types optional associative array of types to be associated with the values
Returns
$thiselseValue() public
elseValue(mixed $value, mixed $type)
Sets the default value
Parameters
-
\Cake\Database\ExpressionInterface|string|array|null$value optional Value to set
-
string|null$type optional Type of value
sql() public
sql(\Cake\Database\ValueBinder $generator)
Converts the Node into a SQL string fragment.
Parameters
-
\Cake\Database\ValueBinder$generator Placeholder generator object
Returns
stringtraverse() public
traverse(callable $visitor)
Iterates over each part of the expression recursively for every level of the expressions tree and executes the $visitor callable passing as first parameter the instance of the expression currently being iterated.
Parameters
-
callable$visitor The callable to apply to all nodes.
Property Detail
$_conditions protected
A list of strings or other expression objects that represent the conditions of the case statement. For example one key of the array might look like "sum > :value"
Type
array$_elseValue protected
The ELSE value for the case statement. If null then no ELSE will be included.
Type
string|\Cake\Database\ExpressionInterface|array|null$_values protected
Values that are associated with the conditions in the $_conditions array.
Each value represents the 'true' value for the condition with the corresponding key.
Type
array
© 2005–present The Cake Software Foundation, Inc.
Licensed under the MIT License.
CakePHP is a registered trademark of Cake Software Foundation, Inc.
We are not endorsed by or affiliated with CakePHP.
https://api.cakephp.org/3.9/class-Cake.Database.Expression.CaseExpression.html