com.blazebit.persistence.impl.function.pageposition.PagePositionFunction 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.pageposition;
import com.blazebit.persistence.spi.FunctionRenderContext;
import com.blazebit.persistence.spi.JpqlFunction;
import com.blazebit.persistence.spi.TemplateRenderer;
/**
*
* @author Christian Beikov
* @since 1.0.0
*/
public class PagePositionFunction implements JpqlFunction {
public static final String FUNCTION_NAME = "page_position";
protected final TemplateRenderer renderer;
public PagePositionFunction() {
this.renderer = new TemplateRenderer("(select base1_.rownumber_ from (select " + getRownumFunction()
+ " as rownumber_, base_.* from ?1 base_) base1_ where ?2 = base1_.?3)");
}
public PagePositionFunction(String template) {
this.renderer = new TemplateRenderer(template);
}
protected String getRownumFunction() {
return "row_number() over ()";
}
@Override
public boolean hasArguments() {
return true;
}
@Override
public boolean hasParenthesesIfNoArguments() {
return true;
}
@Override
public Class getReturnType(Class firstArgumentType) {
return Long.class;
}
@Override
public void render(FunctionRenderContext context) {
if (context.getArgumentsSize() != 2) {
throw new RuntimeException("The page position function needs exactly two arguments and ! args=" + context);
}
String subquery = context.getArgument(0);
String subqueryStart = "(select ";
int fromIndex;
if (!startsWithIgnoreCase(subquery, subqueryStart)) {
throw new IllegalArgumentException("Expected a subquery as the second parameter but was: " + subquery);
} else if ((fromIndex = subquery.toLowerCase().indexOf(" from ")) < 1) {
throw new IllegalArgumentException("Expected a subquery as the second parameter but was: " + subquery);
}
String id = subquery.substring(subqueryStart.length(), fromIndex);
if (id.indexOf(',') > -1) {
throw new IllegalArgumentException("Expected a subquery with a simple id but it was composite: " + subquery);
}
int dotIndex = id.indexOf('.');
if (dotIndex < 0) {
throw new IllegalArgumentException("Expected that the id is fully qualified but it isn't: " + id);
}
String idName = id.substring(dotIndex + 1);
renderPagePosition(context, idName);
}
protected void renderPagePosition(FunctionRenderContext functionRenderContext, String idName) {
renderer.start(functionRenderContext).addArgument(0).addArgument(1).addParameter(idName).build();
}
private boolean startsWithIgnoreCase(String s1, String s2) {
return s1.regionMatches(true, 0, s2, 0, s2.length());
}
}