com.blazebit.persistence.impl.function.groupconcat.MSSQLGroupConcatFunction Maven / Gradle / Ivy
/*
* Copyright 2014 - 2020 Blazebit.
*
* Licensed under the Apache License, Version 2.0 (the "License");
* you may not use this file except in compliance with the License.
* You may obtain a copy of the License at
*
* http://www.apache.org/licenses/LICENSE-2.0
*
* Unless required by applicable law or agreed to in writing, software
* distributed under the License is distributed on an "AS IS" BASIS,
* WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
* See the License for the specific language governing permissions and
* limitations under the License.
*/
package com.blazebit.persistence.impl.function.groupconcat;
import com.blazebit.persistence.impl.function.Order;
import com.blazebit.persistence.parser.util.TypeUtils;
import com.blazebit.persistence.spi.FunctionRenderContext;
import java.util.List;
/**
*
* @author Christian Beikov
* @since 1.0.0
*/
public class MSSQLGroupConcatFunction extends AbstractGroupConcatFunction {
public MSSQLGroupConcatFunction() {
super("string_agg(?1)");
}
@Override
public void render(FunctionRenderContext context, GroupConcat groupConcat) {
StringBuilder sb = new StringBuilder();
if (groupConcat.isDistinct()) {
sb.append("distinct ");
}
sb.append("cast(");
sb.append(groupConcat.getExpression());
sb.append(" as nvarchar(max)), ");
TypeUtils.STRING_CONVERTER.appendTo(groupConcat.getSeparator(), sb);
List orderBys = groupConcat.getOrderBys();
if (orderBys.size() != 0) {
sb.append(") within group (order by ");
render(sb, orderBys.get(0));
for (int i = 1; i < orderBys.size(); i++) {
sb.append(", ");
render(sb, orderBys.get(i));
}
}
renderer.start(context).addParameter(sb.toString()).build();
}
@Override
protected void render(StringBuilder sb, Order order) {
// NOTE: In string_agg SQL Server does not support the nulls clause at all
appendEmulatedOrderByElementWithNulls(sb, order);
}
}