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

Example 1 with GroupConcatSeparatorStep

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

the class DefaultParseContext method parseSpecialAggregateFunctionIf.

private final Field<?> parseSpecialAggregateFunctionIf() {
    if (parseFunctionNameIf("GROUP_CONCAT")) {
        parse('(');
        GroupConcatOrderByStep s1;
        GroupConcatSeparatorStep s2;
        AggregateFunction<String> s3;
        if (parseKeywordIf("DISTINCT"))
            s1 = DSL.groupConcatDistinct(parseField());
        else
            s1 = DSL.groupConcat(parseField());
        if (parseKeywordIf("ORDER BY"))
            s2 = s1.orderBy(parseList(',', c -> c.parseSortField()));
        else
            s2 = s1;
        if (parseKeywordIf("SEPARATOR"))
            s3 = s2.separator(parseStringLiteral());
        else
            s3 = s2;
        parse(')');
        return s3;
    }
    return null;
}