/** * @param path String path * @return year(path) function expression */ public static Expression yearExp(String path) { return extractExp(path, ASTExtract.DateTimePart.YEAR); }
/** * Call LOCATE(substring, string) function that return position * of substring in string or 0 if it is not found. * * @param substring object path value * @param exp string expression * @return LOCATE() call expression */ public static Expression locateExp(String substring, Expression exp) { return locateExp(new ASTScalar(substring), exp); }
/** * @see FunctionExpressionFactory#lengthExp(Expression) */ public Property<Integer> length() { return create(FunctionExpressionFactory.lengthExp(getExpression()), Integer.class); }
/** * @see FunctionExpressionFactory#countExp(Expression) */ public Property<Long> count() { return create(FunctionExpressionFactory.countExp(getExpression()), Long.class); }
/** * @see FunctionExpressionFactory#lowerExp(Expression) */ public Property<String> lower() { return create(FunctionExpressionFactory.lowerExp(getExpression()), String.class); }
/** * @see FunctionExpressionFactory#minExp(Expression) */ public Property<E> min() { return create(FunctionExpressionFactory.minExp(getExpression()), getType()); }
/** * @see FunctionExpressionFactory#absExp(Expression) */ public Property<E> abs() { return create(FunctionExpressionFactory.absExp(getExpression()), getType()); }
/** * @see FunctionExpressionFactory#maxExp(Expression) */ public Property<E> max() { return create(FunctionExpressionFactory.maxExp(getExpression()), getType()); }
/** * @see FunctionExpressionFactory#avgExp(Expression) */ public Property<E> avg() { return create(FunctionExpressionFactory.avgExp(getExpression()), getType()); }
return create(FunctionExpressionFactory.concatExp(exp), String.class);
/** * Call LOCATE(substring, string) function that return position * of substring in string or 0 if it is not found. * * @param substring object path value * @param path object path * @return LOCATE() call expression */ public static Expression locateExp(String substring, String path) { return locateExp(new ASTScalar(substring), new ASTObjPath(path)); }
/** * @param path String path * @return minute(path) function expression */ public static Expression minuteExp(String path) { return extractExp(path, ASTExtract.DateTimePart.MINUTE); }
/** * @see FunctionExpressionFactory#locateExp(String, Expression) */ public Property<Integer> locate(String string) { return create(FunctionExpressionFactory.locateExp(ExpressionFactory.wrapScalarValue(string), getExpression()), Integer.class); }
/** * @param exp date/timestamp expression * @return dayOfWeek(exp) function expression */ public static Expression dayOfWeekExp(Expression exp) { return extractExp(exp, ASTExtract.DateTimePart.DAY_OF_WEEK); }
/** * @see FunctionExpressionFactory#locateExp(Expression, Expression) */ public Property<Integer> locate(Property<? extends String> property) { return create(FunctionExpressionFactory.locateExp(property.getExpression(), getExpression()), Integer.class); }
/** * @param exp date/timestamp expression * @return minute(exp) function expression */ public static Expression minuteExp(Expression exp) { return extractExp(exp, ASTExtract.DateTimePart.MINUTE); }
/** * @param path String path * @return week(path) function expression */ public static Expression weekExp(String path) { return extractExp(path, ASTExtract.DateTimePart.WEEK); }
/** * @param exp date/timestamp expression * @return dayOfYear(exp) function expression */ public static Expression dayOfYearExp(Expression exp) { return extractExp(exp, ASTExtract.DateTimePart.DAY_OF_YEAR); }
/** * @param path String path * @return dayOfMonth(path) function expression, synonym for day() */ public static Expression dayOfMonthExp(String path) { return extractExp(path, ASTExtract.DateTimePart.DAY_OF_MONTH); }
/** * @param path String path * @return dayOfWeek(path) function expression */ public static Expression dayOfWeekExp(String path) { return extractExp(path, ASTExtract.DateTimePart.DAY_OF_WEEK); }