Package org.apache.cayenne.exp

## Class FunctionExpressionFactory

- java.lang.Object
- - org.apache.cayenne.exp.FunctionExpressionFactory

-     public class FunctionExpressionFactory
      extends Object

  Collection of factory methods to create function call expressions.
  Since:
    4.0

- - ### Constructor Summary

    Constructors
    Constructor | Description
    --- | ---
    `FunctionExpressionFactory()` |

  - ### Method Summary

    All Methods Static Methods Concrete Methods
    Modifier and Type | Method | Description
    --- | --- | ---
    `static Expression` | `absExp​(String path)` |
    `static Expression` | `absExp​(Expression exp)` |
    `static Expression` | `avgExp​(Expression exp)` |
    `static Expression` | `concatExp​(String... paths)` | Factory method for expression to call CONCAT(string1, string2, ...) function
    `static Expression` | `concatExp​(Expression... expressions)` | Factory method for expression to call CONCAT(string1, string2, ...) function
    `static Expression` | `countDistinctExp​(Expression exp)` |
    `static Expression` | `countExp()` |
    `static Expression` | `countExp​(Expression exp)` |
    `static Expression` | `currentDate()` |
    `static Expression` | `currentTime()` |
    `static Expression` | `currentTimestamp()` |
    `static Expression` | `dayOfMonthExp​(String path)` |
    `static Expression` | `dayOfMonthExp​(Expression exp)` |
    `static Expression` | `dayOfWeekExp​(String path)` |
    `static Expression` | `dayOfWeekExp​(Expression exp)` |
    `static Expression` | `dayOfYearExp​(String path)` |
    `static Expression` | `dayOfYearExp​(Expression exp)` |
    `static Expression` | `hourExp​(String path)` |
    `static Expression` | `hourExp​(Expression exp)` |
    `static Expression` | `lengthExp​(String path)` |
    `static Expression` | `lengthExp​(Expression exp)` |
    `static Expression` | `locateExp​(String substring, String path)` | Call LOCATE(substring, string) function that return position of substring in string or 0 if it is not found.
    `static Expression` | `locateExp​(String substring, Expression exp)` | Call LOCATE(substring, string) function that return position of substring in string or 0 if it is not found.
    `static Expression` | `locateExp​(Expression substring, Expression exp)` | Call LOCATE(substring, string) function that return position of substring in string or 0 if it is not found.
    `static Expression` | `lowerExp​(String path)` |
    `static Expression` | `lowerExp​(Expression exp)` |
    `static Expression` | `maxExp​(Expression exp)` |
    `static Expression` | `minExp​(Expression exp)` |
    `static Expression` | `minuteExp​(String path)` |
    `static Expression` | `minuteExp​(Expression exp)` |
    `static Expression` | `modExp​(String path, Number number)` |
    `static Expression` | `modExp​(Expression exp, Number number)` |
    `static Expression` | `modExp​(Expression exp, Expression number)` |
    `static Expression` | `monthExp​(String path)` |
    `static Expression` | `monthExp​(Expression exp)` |
    `static Expression` | `secondExp​(String path)` |
    `static Expression` | `secondExp​(Expression exp)` |
    `static Expression` | `sqrtExp​(String path)` |
    `static Expression` | `sqrtExp​(Expression exp)` |
    `static Expression` | `substringExp​(String path, int offset, int length)` | Call SUBSTRING(string, offset, length) function
    `static Expression` | `substringExp​(Expression exp, int offset, int length)` | Call SUBSTRING(string, offset, length) function
    `static Expression` | `substringExp​(Expression exp, Expression offset, Expression length)` | Call SUBSTRING(string, offset, length) function
    `static Expression` | `sumExp​(Expression exp)` |
    `static Expression` | `trimExp​(String path)` |
    `static Expression` | `trimExp​(Expression exp)` |
    `static Expression` | `upperExp​(String path)` |
    `static Expression` | `upperExp​(Expression exp)` |
    `static Expression` | `weekExp​(String path)` |
    `static Expression` | `weekExp​(Expression exp)` |
    `static Expression` | `yearExp​(String path)` |
    `static Expression` | `yearExp​(Expression exp)` |

    - ### Methods inherited from class java.lang.Object

      `clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait`

- - ### Constructor Detail

    - #### FunctionExpressionFactory

          public FunctionExpressionFactory()

  - ### Method Detail

    - #### substringExp

          public static Expression substringExp​(Expression exp,
                                                int offset,
                                                int length)

      Call SUBSTRING(string, offset, length) function
      Parameters:
        `exp` - expression that must evaluate to string
        `offset` - start offset of substring
        `length` - length of substring
      Returns:
        SUBSTRING() call expression

    - #### substringExp

          public static Expression substringExp​(String path,
                                                int offset,
                                                int length)

      Call SUBSTRING(string, offset, length) function
      Parameters:
        `path` - Object path value
        `offset` - start offset of substring
        `length` - length of substring
      Returns:
        SUBSTRING() call expression

    - #### substringExp

          public static Expression substringExp​(Expression exp,
                                                Expression offset,
                                                Expression length)

      Call SUBSTRING(string, offset, length) function
      Parameters:
        `exp` - expression that must evaluate to string
        `offset` - start offset of substring must evaluate to int
        `length` - length of substring must evaluate to int
      Returns:
        SUBSTRING() call expression

    - #### trimExp

          public static Expression trimExp​(Expression exp)

      Parameters:
        `exp` - string expression to trim
      Returns:
        TRIM() call expression

    - #### trimExp

          public static Expression trimExp​(String path)

      Parameters:
        `path` - object path value
      Returns:
        TRIM() call expression

    - #### lowerExp

          public static Expression lowerExp​(Expression exp)

      Parameters:
        `exp` - string expression
      Returns:
        LOWER() call expression

    - #### lowerExp

          public static Expression lowerExp​(String path)

      Parameters:
        `path` - object path value
      Returns:
        LOWER() call expression

    - #### upperExp

          public static Expression upperExp​(Expression exp)

      Parameters:
        `exp` - string expression
      Returns:
        UPPER() call expression

    - #### upperExp

          public static Expression upperExp​(String path)

      Parameters:
        `path` - object path value
      Returns:
        UPPER() call expression

    - #### lengthExp

          public static Expression lengthExp​(Expression exp)

      Parameters:
        `exp` - string expression
      Returns:
        LENGTH() call expression

    - #### lengthExp

          public static Expression lengthExp​(String path)

      Parameters:
        `path` - object path value
      Returns:
        LENGTH() call expression

    - #### locateExp

          public static Expression locateExp​(String substring,
                                             Expression exp)

      Call LOCATE(substring, string) function that return position of substring in string or 0 if it is not found.
      Parameters:
        `substring` - object path value
        `exp` - string expression
      Returns:
        LOCATE() call expression

    - #### locateExp

          public static Expression locateExp​(String substring,
                                             String path)

      Call LOCATE(substring, string) function that return position of substring in string or 0 if it is not found.
      Parameters:
        `substring` - object path value
        `path` - object path
      Returns:
        LOCATE() call expression

    - #### locateExp

          public static Expression locateExp​(Expression substring,
                                             Expression exp)

      Call LOCATE(substring, string) function that return position of substring in string or 0 if it is not found.
      Parameters:
        `substring` - string expression
        `exp` - string expression
      Returns:
        LOCATE() call expression

    - #### absExp

          public static Expression absExp​(Expression exp)

      Parameters:
        `exp` - numeric expression
      Returns:
        ABS() call expression

    - #### absExp

          public static Expression absExp​(String path)

      Parameters:
        `path` - object path value
      Returns:
        ABS() call expression

    - #### sqrtExp

          public static Expression sqrtExp​(Expression exp)

      Parameters:
        `exp` - numeric expression
      Returns:
        SQRT() call expression

    - #### sqrtExp

          public static Expression sqrtExp​(String path)

      Parameters:
        `path` - object path value
      Returns:
        SQRT() call expression

    - #### modExp

          public static Expression modExp​(Expression exp,
                                          Number number)

      Parameters:
        `exp` - numeric expression
        `number` - divisor
      Returns:
        MOD() call expression

    - #### modExp

          public static Expression modExp​(String path,
                                          Number number)

      Parameters:
        `path` - object path value
        `number` - divisor
      Returns:
        MOD() call expression

    - #### modExp

          public static Expression modExp​(Expression exp,
                                          Expression number)

      Parameters:
        `exp` - object path value
        `number` - numeric expression
      Returns:
        MOD() call expression

    - #### concatExp

          public static Expression concatExp​(Expression... expressions)

      Factory method for expression to call CONCAT(string1, string2, ...) function

      Can be used like:

            Expression concat = concatExp(SomeClass.POPERTY_1.getPath(), SomeClass.PROPERTY_2.getPath());

      SQL generation note:

      - if DB supports CONCAT function with vararg then it will be used
      - if DB supports CONCAT function with two args but also supports concat operator, then operator (eg ||) will be used
      - if DB supports only CONCAT function with two args then it will be used what can lead to SQL exception if used with more than two arguments

      Currently only known DB with limited concatenation functionality is Openbase.

      Parameters:
        `expressions` - array of expressions
      Returns:
        CONCAT() call expression

    - #### concatExp

          public static Expression concatExp​(String... paths)

      Factory method for expression to call CONCAT(string1, string2, ...) function

      Can be used like:

            Expression concat = concatExp("property1", "property2");

      SQL generation note:

      - if DB supports CONCAT function with vararg then it will be used
      - if DB supports CONCAT function with two args but also supports concat operator, then operator (eg ||) will be used
      - if DB supports only CONCAT function with two args then it will be used what can lead to SQL exception if used with more than two arguments

      Currently only Openbase DB has limited concatenation functionality.

      Parameters:
        `paths` - array of paths
      Returns:
        CONCAT() call expression

    - #### countExp

          public static Expression countExp()

      Returns:
        Expression COUNT(*)

    - #### countExp

          public static Expression countExp​(Expression exp)

      Returns:
        Expression COUNT(exp)

    - #### countDistinctExp

          public static Expression countDistinctExp​(Expression exp)

      Returns:
        Expression COUNT(DISTINCT(exp))
      Since:
        4.1

    - #### minExp

          public static Expression minExp​(Expression exp)

      Returns:
        Expression MIN(exp)

    - #### maxExp

          public static Expression maxExp​(Expression exp)

      Returns:
        Expression MAX(exp)

    - #### avgExp

          public static Expression avgExp​(Expression exp)

      Returns:
        Expression AVG(exp)

    - #### sumExp

          public static Expression sumExp​(Expression exp)

      Returns:
        SUM(exp) expression

    - #### currentDate

          public static Expression currentDate()

      Returns:
        CURRENT_DATE expression

    - #### currentTime

          public static Expression currentTime()

      Returns:
        CURRENT_TIME expression

    - #### currentTimestamp

          public static Expression currentTimestamp()

      Returns:
        CURRENT_TIMESTAMP expression

    - #### yearExp

          public static Expression yearExp​(Expression exp)

      Parameters:
        `exp` - date/timestamp expression
      Returns:
        year(exp) function expression

    - #### yearExp

          public static Expression yearExp​(String path)

      Parameters:
        `path` - String path
      Returns:
        year(path) function expression

    - #### monthExp

          public static Expression monthExp​(Expression exp)

      Parameters:
        `exp` - date/timestamp expression
      Returns:
        month(exp) function expression

    - #### monthExp

          public static Expression monthExp​(String path)

      Parameters:
        `path` - String path
      Returns:
        month(path) function expression

    - #### weekExp

          public static Expression weekExp​(Expression exp)

      Parameters:
        `exp` - date/timestamp expression
      Returns:
        week(exp) function expression

    - #### weekExp

          public static Expression weekExp​(String path)

      Parameters:
        `path` - String path
      Returns:
        week(path) function expression

    - #### dayOfYearExp

          public static Expression dayOfYearExp​(Expression exp)

      Parameters:
        `exp` - date/timestamp expression
      Returns:
        dayOfYear(exp) function expression

    - #### dayOfYearExp

          public static Expression dayOfYearExp​(String path)

      Parameters:
        `path` - String path
      Returns:
        dayOfYear(path) function expression

    - #### dayOfMonthExp

          public static Expression dayOfMonthExp​(Expression exp)

      Parameters:
        `exp` - date/timestamp expression
      Returns:
        dayOfMonth(exp) function expression, synonym for day()

    - #### dayOfMonthExp

          public static Expression dayOfMonthExp​(String path)

      Parameters:
        `path` - String path
      Returns:
        dayOfMonth(path) function expression, synonym for day()

    - #### dayOfWeekExp

          public static Expression dayOfWeekExp​(Expression exp)

      Parameters:
        `exp` - date/timestamp expression
      Returns:
        dayOfWeek(exp) function expression

    - #### dayOfWeekExp

          public static Expression dayOfWeekExp​(String path)

      Parameters:
        `path` - String path
      Returns:
        dayOfWeek(path) function expression

    - #### hourExp

          public static Expression hourExp​(Expression exp)

      Parameters:
        `exp` - date/timestamp expression
      Returns:
        hour(exp) function expression

    - #### hourExp

          public static Expression hourExp​(String path)

      Parameters:
        `path` - String path
      Returns:
        hour(path) function expression

    - #### minuteExp

          public static Expression minuteExp​(Expression exp)

      Parameters:
        `exp` - date/timestamp expression
      Returns:
        minute(exp) function expression

    - #### minuteExp

          public static Expression minuteExp​(String path)

      Parameters:
        `path` - String path
      Returns:
        minute(path) function expression

    - #### secondExp

          public static Expression secondExp​(Expression exp)

      Parameters:
        `exp` - date/timestamp expression
      Returns:
        second(exp) function expression

    - #### secondExp

          public static Expression secondExp​(String path)

      Parameters:
        `path` - String path
      Returns:
        second(path) function expression