org.cloudfoundry.identity.uaa.resources.jdbc.SQLServerLimitSqlAdapter Maven / Gradle / Ivy

Go to download

Show more of this group Show more artifacts with this name
Show all versions of cloudfoundry-identity-server Show documentation

The newest version!

/*******************************************************************************
 *
 *     Copyright (c) [2016] Cloud Foundry Foundation. All Rights Reserved.
 *
 *     This product is licensed to you under the Apache License, Version 2.0 (the "License").
 *     You may not use this product except in compliance with the License.
 *
 *     This product includes a number of subcomponents with
 *     separate copyright notices and license terms. Your use of these
 *     subcomponents is subject to the terms and conditions of the
 *     subcomponent's license, as noted in the LICENSE file.
 *******************************************************************************/
package org.cloudfoundry.identity.uaa.resources.jdbc;

import java.util.regex.Matcher;
import java.util.regex.Pattern;

public class SQLServerLimitSqlAdapter implements LimitSqlAdapter {

    @Override
    public String getLimitSql(String sql, int index, int size) {
        Pattern p = Pattern.compile(".+order\\s+by\\s+\\w+(\\s+asc|\\s+desc)?([\\s,]*\\w+(\\s+asc|\\s+desc)?)*\\s*$", Pattern.CASE_INSENSITIVE | Pattern.DOTALL);
        Matcher m = p.matcher(sql);
        if (m.matches()) {
            return sql + " OFFSET " + index + " ROWS FETCH NEXT " + size + " ROWS ONLY;";
        } else {
            return sql + " ORDER BY 1 OFFSET " + index + " ROWS FETCH NEXT " + size + " ROWS ONLY;";
        }
    }

    @Override
    public String getDeleteExpiredQuery(String tablename, String primaryKeyColumn, String expiresColumn, int maxRows) {
        return "DELETE FROM " +
            tablename +
            " WHERE " +
            primaryKeyColumn+" IN " +
            "(SELECT TOP " + maxRows +
            " " + primaryKeyColumn +
            " FROM " + tablename +
            " WHERE " + expiresColumn + " < ?" +
            " ORDER BY "+ expiresColumn + ")";
    }

}