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.

• 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( string $name , array $args )

_build( string $name , array $params [] , array $types [] , string $return 'string' )

_literalArgumentFunction( string $name , mixed $expression , array $types [] , string $return 'string' )

avg( mixed $expression , array $types [] )

coalesce( array $args , array $types [] )

concat( array $args , array $types [] )

count( mixed $expression , array $types [] )

dateAdd( string $expression , string $value , string $unit , array $types [] )

dateDiff( array $args , array $types [] )

datePart( string $part , string $expression , array $types [] )

dayOfWeek( mixed $expression , array $types [] )

extract( string $part , string $expression , array $types [] )

max( mixed $expression , array $types [] )

min( mixed $expression , array $types [] )

now( string $type 'datetime' )

sum( mixed $expression , array $types [] )

weekday( mixed $expression , array $types [] )