Class FunctionsBuilder
Contains methods related to generating FunctionExpression objects with most commonly used SQL functions. This acts as a factory for FunctionExpression objects.
Method Summary
-
__call() public
Magic method dispatcher to create custom SQL function calls -
_build() protected
Returns a new instance of a FunctionExpression. This is used for generating arbitrary function calls in the final SQL string.
-
_literalArgumentFunction() protected
Helper function to build a function expression that only takes one literal argument.
-
avg() public
Returns a FunctionExpression representing a call to SQL AVG function. -
coalesce() public
Returns a FunctionExpression representing a call to SQL COALESCE function. -
concat() public
Returns a FunctionExpression representing a string concatenation -
count() public
Returns a FunctionExpression representing a call to SQL COUNT function. -
dateAdd() public
Add the time unit to the date expression -
dateDiff() public
Returns a FunctionExpression representing the difference in days between two dates.
-
datePart() public
Returns the specified date part from the SQL expression. -
dayOfWeek() public
Returns a FunctionExpression representing a call to SQL WEEKDAY function. 1 - Sunday, 2 - Monday, 3 - Tuesday...
-
extract() public
Returns the specified date part from the SQL expression. -
max() public
Returns a FunctionExpression representing a call to SQL MAX function. -
min() public
Returns a FunctionExpression representing a call to SQL MIN function. -
now() public
Returns a FunctionExpression representing a call that will return the current date and time. By default it returns both date and time, but you can also make it generate only the date or only the time.
-
rand() public
Returns a FunctionExpression representing a call to SQL RAND function. -
sum() public
Returns a FunctionExpression representing a call to SQL SUM function. -
weekday() public
Returns a FunctionExpression representing a call to SQL WEEKDAY function. 1 - Sunday, 2 - Monday, 3 - Tuesday...
Method Detail
__call() public ¶
__call( string $name , array $args )
Magic method dispatcher to create custom SQL function calls
Parameters
- string $name
- the SQL function name to construct
- array $args
list with up to 3 arguments, first one being an array with parameters for the SQL function, the second one a list of types to bind to those params, and the third one the return type of the function
Returns
_build() protected ¶
_build( string $name , array $params = [] , array $types = [] , string $return = 'string' )
Returns a new instance of a FunctionExpression. This is used for generating arbitrary function calls in the final SQL string.
Parameters
- string $name
- the name of the SQL function to constructed
- array $params optional []
- list of params to be passed to the function
- array $types optional []
- list of types for each function param
- string $return optional 'string'
- The return type of the function expression
Returns
_literalArgumentFunction() protected ¶
_literalArgumentFunction( string $name , mixed $expression , array $types = [] , string $return = 'string' )
Helper function to build a function expression that only takes one literal argument.
Parameters
- string $name
- name of the function to build
- mixed $expression
- the function argument
- array $types optional []
- list of types to bind to the arguments
- string $return optional 'string'
- The return type for the function
Returns
avg() public ¶
avg( mixed $expression , array $types = [] )
Returns a FunctionExpression representing a call to SQL AVG function.
Parameters
- mixed $expression
- the function argument
- array $types optional []
- list of types to bind to the arguments
Returns
coalesce() public ¶
coalesce( array $args , array $types = [] )
Returns a FunctionExpression representing a call to SQL COALESCE function.
Parameters
- array $args
- List of expressions to evaluate as function parameters
- array $types optional []
- list of types to bind to the arguments
Returns
concat() public ¶
concat( array $args , array $types = [] )
Returns a FunctionExpression representing a string concatenation
Parameters
- array $args
- List of strings or expressions to concatenate
- array $types optional []
- list of types to bind to the arguments
Returns
count() public ¶
count( mixed $expression , array $types = [] )
Returns a FunctionExpression representing a call to SQL COUNT function.
Parameters
- mixed $expression
- the function argument
- array $types optional []
- list of types to bind to the arguments
Returns
dateAdd() public ¶
dateAdd( string $expression , string $value , string $unit , array $types = [] )
Add the time unit to the date expression
Parameters
- string $expression
- Expression to obtain the date part from.
- string $value
- Value to be added. Use negative to subtract.
- string $unit
- Unit of the value e.g. hour or day.
- array $types optional []
- list of types to bind to the arguments
Returns
dateDiff() public ¶
dateDiff( array $args , array $types = [] )
Returns a FunctionExpression representing the difference in days between two dates.
Parameters
- array $args
- List of expressions to obtain the difference in days.
- array $types optional []
- list of types to bind to the arguments
Returns
datePart() public ¶
datePart( string $part , string $expression , array $types = [] )
Returns the specified date part from the SQL expression.
Parameters
- string $part
- Part of the date to return.
- string $expression
- Expression to obtain the date part from.
- array $types optional []
- list of types to bind to the arguments
Returns
dayOfWeek() public ¶
dayOfWeek( mixed $expression , array $types = [] )
Returns a FunctionExpression representing a call to SQL WEEKDAY function. 1 - Sunday, 2 - Monday, 3 - Tuesday...
Parameters
- mixed $expression
- the function argument
- array $types optional []
- list of types to bind to the arguments
Returns
extract() public ¶
extract( string $part , string $expression , array $types = [] )
Returns the specified date part from the SQL expression.
Parameters
- string $part
- Part of the date to return.
- string $expression
- Expression to obtain the date part from.
- array $types optional []
- list of types to bind to the arguments
Returns
max() public ¶
max( mixed $expression , array $types = [] )
Returns a FunctionExpression representing a call to SQL MAX function.
Parameters
- mixed $expression
- the function argument
- array $types optional []
- list of types to bind to the arguments
Returns
min() public ¶
min( mixed $expression , array $types = [] )
Returns a FunctionExpression representing a call to SQL MIN function.
Parameters
- mixed $expression
- the function argument
- array $types optional []
- list of types to bind to the arguments
Returns
now() public ¶
now( string $type = 'datetime' )
Returns a FunctionExpression representing a call that will return the current date and time. By default it returns both date and time, but you can also make it generate only the date or only the time.
Parameters
- string $type optional 'datetime'
- (datetime|date|time)
Returns
rand() public ¶
rand( )
Returns a FunctionExpression representing a call to SQL RAND function.
Returns
sum() public ¶
sum( mixed $expression , array $types = [] )
Returns a FunctionExpression representing a call to SQL SUM function.
Parameters
- mixed $expression
- the function argument
- array $types optional []
- list of types to bind to the arguments
Returns
weekday() public ¶
weekday( mixed $expression , array $types = [] )
Returns a FunctionExpression representing a call to SQL WEEKDAY function. 1 - Sunday, 2 - Monday, 3 - Tuesday...
Parameters
- mixed $expression
- the function argument
- array $types optional []
- list of types to bind to the arguments