Examples with AggregateFilterStep org.jooq.AggregateFilterStep used on opensource projects

Example 1 with AggregateFilterStep

use of org.jooq.AggregateFilterStep in project jOOQ by jOOQ.

the class DefaultParseContext method parseJSONArrayAggFunctionIf.

private final AggregateFilterStep<?> parseJSONArrayAggFunctionIf() {
    boolean jsonb = false;
    if (parseFunctionNameIf("JSON_ARRAYAGG", "JSON_AGG", "JSON_GROUP_ARRAY") || (jsonb = parseFunctionNameIf("JSONB_AGG"))) {
        AggregateFilterStep<?> result;
        JSONArrayAggOrderByStep<?> s1;
        JSONArrayAggNullStep<?> s2;
        JSONArrayAggReturningStep<?> s3;
        JSONOnNull onNull;
        DataType<?> returning;
        parse('(');
        result = s3 = s2 = s1 = jsonb ? jsonbArrayAgg(parseField()) : jsonArrayAgg(parseField());
        if (parseKeywordIf("ORDER BY"))
            result = s3 = s2 = s1.orderBy(parseList(',', c -> c.parseSortField()));
        if ((onNull = parseJSONNullTypeIf()) != null)
            result = s3 = onNull == ABSENT_ON_NULL ? s2.absentOnNull() : s2.nullOnNull();
        if ((returning = parseJSONReturningIf()) != null)
            result = s3.returning(returning);
        parse(')');
        return result;
    }
    return null;
}