com.jn.sqlhelper.dialect.internal.limit.SkipLimitHandler Maven / Gradle / Ivy

Show more of this group Show more artifacts with this name
Show all versions of sqlhelper-dialect Show documentation

Database dialects ( supports pagination, UrlParser, SqlStatementParser, WallFilter, BatchExecutor for Test) based Java, you can use it in any ORM framework.

There is a newer version: 5.0.7

Show newest version

package com.jn.sqlhelper.dialect.internal.limit;

import com.jn.sqlhelper.dialect.pagination.RowSelection;

import java.util.Locale;

public class SkipLimitHandler extends AbstractLimitHandler {
    private String firstNKeyword = "FIRST"; // may be: "LIMIT", "FIRST" or "TOP"

    public SkipLimitHandler() {
        this("FIRST");
    }

    public SkipLimitHandler(String firstNKeyword) {
        this.firstNKeyword = firstNKeyword;
    }

    @Override
    public String processSql(String sql,boolean isSubquery, boolean useLimitVariable,RowSelection selection) {
        final boolean hasOffset = LimitHelper.hasFirstRow(selection);
        String sqlLimit = "";
        if (hasOffset) {
            if (useLimitVariable && getDialect().isUseLimitInVariableMode(isSubquery)) {
                sqlLimit = " SKIP ? ";
            } else {
                sqlLimit = " SKIP " + selection.getOffset();
            }
        }
        if (useLimitVariable && getDialect().isUseLimitInVariableMode(isSubquery)) {
            sqlLimit = sqlLimit + " " + firstNKeyword + " ? ";
        } else {
            sqlLimit = sqlLimit + " " + firstNKeyword + " " + getMaxOrLimit(selection) + " ";
        }

        return new StringBuilder(sql.length() + 10)
                .append(sql)
                .insert(sql.toLowerCase(Locale.ROOT).indexOf("select") + 6, sqlLimit).toString();
    }
}