Class BetweenExpression

An expression object that represents a SQL BETWEEN snippet

Properties summary

  • $_field protected
    string|array|\Cake\Database\ExpressionInterface

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

  • $_from protected
    mixed

    The first value in the expression

  • $_to protected
    mixed

    The second value in the expression

  • $_type protected
    mixed

    The 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 expression to its string representation

  • 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

__clone() public

__clone()

Do a deep clone of this expression.

__construct() public

__construct(mixed $field, mixed $from, mixed $to, mixed $type)

Constructor

Parameters

string|\Cake\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, mixed $generator, mixed $type)

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

Parameters

mixed $value

The value to bind

\Cake\Database\ValueBinder $generator

The value binder to use

string $type

The type of $value

Returns

string

generated placeholder

_castToExpression() protected

_castToExpression(mixed $value, ?string $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|null $type optional

The type name

Returns

mixed

_requiresToExpressionCasting() protected

_requiresToExpressionCasting(array $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

array

getField() public

getField()

Returns the field name

Returns

string|array|\Cake\Database\ExpressionInterface

setField() public

setField(mixed $field)

Sets the field name

Parameters

string|array|\Cake\Database\ExpressionInterface $field

The field to compare with.

sql() public

sql(\Cake\Database\ValueBinder $generator)

Converts the expression to its string representation

Parameters

\Cake\Database\ValueBinder $generator

Placeholder generator object

Returns

string

traverse() public

traverse(\Closure $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

\Closure $visitor

The callable to apply to all nodes.

Returns

$this

Property Detail

$_field protected

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

Type

string|array|\Cake\Database\ExpressionInterface

$_from protected

The first value in the expression

Type

mixed

$_to protected

The second value in the expression

Type

mixed

$_type protected

The data type for the from and to arguments

Type

mixed

© 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/4.1/class-Cake.Database.Expression.BetweenExpression.html