• Home
• org.cloudfoundry.identity
• cloudfoundry-identity-server
• 4.30.0
• source code
• PostgresLimitSqlAdapter.java

×

Project download

Many resources are needed to download a project. Please understand that we have to compensate our server costs. Thank you in advance.
Project price only 1 $

You can buy this project and download/modify it how often you want.

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

/*
 * ****************************************************************************
 *     Cloud Foundry
 *     Copyright (c) [2009-2017] Pivotal Software, Inc. 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;

public class PostgresLimitSqlAdapter implements LimitSqlAdapter {
    @Override
    public String getDeleteExpiredQuery(String tablename, String primaryKeyColumn, String expiresColumn, int maxRows) {
        return "DELETE FROM "+
            tablename +
            " WHERE "+
            primaryKeyColumn +
            " = any (array(SELECT " +
            primaryKeyColumn +
            " FROM " +
            tablename +
            " WHERE " +
            expiresColumn +
            " < ? " +
            " ORDER BY " +
            expiresColumn +
            " LIMIT "+maxRows+"))";
    }
}