@Override public void appendOrderBy(StringBuilder builder, String fieldName, OrderByType orderByType) { builder.append(fieldName).append(" ").append(orderByType.getSqlKeyword()); } }
@Override public void appendOrderBy(StringBuilder builder, String fieldName, OrderByType orderByType) { builder.append(fieldName).append(" ").append(orderByType.getSqlKeyword()); } }
@Override public void appendOrderBy(StringBuilder builder, String fieldName, OrderByType orderByType) { switch (orderByType) { case ASC: case DESC: builder.append(fieldName).append(" ").append(orderByType.getSqlKeyword()); break; case ASC_NULLS_FIRST: builder.append("CASE WHEN ").append(fieldName).append(" IS NULL THEN 0 ELSE 1 END ASC, ") .append(fieldName).append(" ASC"); break; case ASC_NULLS_LAST: builder.append("CASE WHEN ").append(fieldName).append(" IS NULL THEN 0 ELSE 1 END DESC, ") .append(fieldName).append(" ASC"); break; case DESC_NULLS_FIRST: builder.append("CASE WHEN ").append(fieldName).append(" IS NULL THEN 0 ELSE 1 END ASC, ") .append(fieldName).append(" DESC"); break; case DESC_NULLS_LAST: builder.append("CASE WHEN ").append(fieldName).append(" IS NULL THEN 0 ELSE 1 END DESC, ") .append(fieldName).append(" DESC"); break; } } }
@Override public void appendOrderBy(StringBuilder builder, String fieldName, OrderByType orderByType) { switch (orderByType) { case ASC: case DESC: builder.append(fieldName).append(" ").append(orderByType.getSqlKeyword()); break; case ASC_NULLS_FIRST: builder.append("CASE WHEN ").append(fieldName).append(" IS NULL THEN 0 ELSE 1 END ASC, ") .append(fieldName).append(" ASC"); break; case ASC_NULLS_LAST: builder.append("CASE WHEN ").append(fieldName).append(" IS NULL THEN 0 ELSE 1 END DESC, ") .append(fieldName).append(" ASC"); break; case DESC_NULLS_FIRST: builder.append("CASE WHEN ").append(fieldName).append(" IS NULL THEN 0 ELSE 1 END ASC, ") .append(fieldName).append(" DESC"); break; case DESC_NULLS_LAST: builder.append("CASE WHEN ").append(fieldName).append(" IS NULL THEN 0 ELSE 1 END DESC, ") .append(fieldName).append(" DESC"); break; } } }