Class ArraySizeMethod

  • All Implemented Interfaces:
    SQLMethod

    public class ArraySizeMethod
    extends java.lang.Object
    implements SQLMethod
    Method for evaluating {arrExpr1}.size(). Returns a NumericExpression. Equates to a sub-query on the table for the array returning the COUNT(*) of the number of elements. Something like
     SELECT COUNT(*) FROM ARRTABLE A0_SUB WHERE A0_SUB.OWNER_ID_OID = A0.OWNER_ID
     
    where A0 is the candidate table in the outer query, and ARRTABLE is the join table (if using join collection) or the element table (if using FK array).
    • Constructor Detail

      • ArraySizeMethod

        public ArraySizeMethod()
    • Method Detail

      • getExpression

        public SQLExpression getExpression​(SQLStatement stmt,
                                           SQLExpression expr,
                                           java.util.List<SQLExpression> args)
        Description copied from interface: SQLMethod
        Return the expression for this SQL function.
        Specified by:
        getExpression in interface SQLMethod
        Parameters:
        stmt - SQLStatement that this expression is for
        expr - The expression that it is invoked on
        args - Arguments passed in
        Returns:
        The SQL expression using the SQL function