Class BetweenExpression
An expression object that represents a SQL BETWEEN snippet
Property Summary
-
$_field protected
string|arrayCake\Database\ExpressionInterfaceThe field name or expression to be used in the left hand side of the operator
-
$_from protected
mixedThe first value in the expression
-
$_to protected
mixedThe second value in the expression
-
$_type protected
mixedThe data type for the from and to arguments
Method Summary
-
__clone() public
Do a deep clone of this expression.
-
__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.
-
_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.
-
getField() public
Returns the field name
-
setField() public
Sets the field name
-
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 callable passing as first parameter the instance of the expression currently being iterated.
Method Detail
__construct() ¶ public
__construct(stringCake\Database\ExpressionInterface $field, mixed $from, mixed $to, string|null $type = null)Constructor
Parameters
-
stringCake\Database\ExpressionInterface$field The field name to compare for values inbetween the range.
-
mixed$from The initial value of the range.
-
mixed$to The ending value in the comparison range.
-
string|null$type optional The data type name to bind the values with.
_bindValue() ¶ protected
_bindValue(mixed $value, Cake\Database\ValueBinder $binder, string $type): stringRegisters a value in the placeholder generator and returns the generated placeholder
Parameters
-
mixed$value The value to bind
-
Cake\Database\ValueBinder$binder The value binder to use
-
string$type The type of $value
Returns
string_castToExpression() ¶ protected
_castToExpression(mixed $value, string|null $type = null): mixedConditionally 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_requiresToExpressionCasting() ¶ protected
_requiresToExpressionCasting(array $types): arrayReturns 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
arraygetField() ¶ public
getField(): string|arrayCake\Database\ExpressionInterfaceReturns the field name
Returns
string|arrayCake\Database\ExpressionInterfacesetField() ¶ public
setField(string|arrayCake\Database\ExpressionInterface $field): voidSets the field name
Parameters
-
string|arrayCake\Database\ExpressionInterface$field The field to compare with.
Returns
voidsql() ¶ public
sql(Cake\Database\ValueBinder $binder): stringConverts the Node into a SQL string fragment.
Parameters
-
Cake\Database\ValueBinder$binder
Returns
stringtraverse() ¶ public
traverse(Closure $callback): $thisIterates over each part of the expression recursively for every level of the expressions tree and executes the $callback callable passing as first parameter the instance of the expression currently being iterated.
Parameters
-
Closure$callback
Returns
$thisProperty Detail
$_field ¶ protected
The field name or expression to be used in the left hand side of the operator
Type
string|arrayCake\Database\ExpressionInterface