RemoveDuplicateOfflineSessions.java
/*
* Copyright 2018 Red Hat, Inc. and/or its affiliates
* and other contributors as indicated by the @author tags.
*
* 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 org.keycloak.connections.jpa.updater.liquibase.custom;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.util.HashSet;
import java.util.Objects;
import java.util.Set;
import java.util.concurrent.atomic.AtomicInteger;
import java.util.stream.Collectors;
import java.util.stream.IntStream;
import liquibase.exception.CustomChangeException;
import liquibase.statement.core.DeleteStatement;
import liquibase.structure.core.Column;
/**
*
* @author hmlnarik
*/
public class RemoveDuplicateOfflineSessions extends CustomKeycloakTask {
private static class Key {
private final String userSessionId;
private final String clientId;
private final String offlineFlag;
public Key(String userSessionId, String clientId, String offlineFlag) {
this.userSessionId = userSessionId;
this.clientId = clientId;
this.offlineFlag = offlineFlag;
}
@Override
public int hashCode() {
int hash = 7;
hash = 73 * hash + Objects.hashCode(this.userSessionId);
hash = 73 * hash + Objects.hashCode(this.clientId);
hash = 73 * hash + Objects.hashCode(this.offlineFlag);
return hash;
}
@Override
public boolean equals(Object obj) {
if (this == obj) {
return true;
}
if (obj == null) {
return false;
}
if (getClass() != obj.getClass()) {
return false;
}
final Key other = (Key) obj;
return Objects.equals(this.userSessionId, other.userSessionId)
&& Objects.equals(this.clientId, other.clientId)
&& Objects.equals(this.offlineFlag, other.offlineFlag);
}
}
@Override
protected void generateStatementsImpl() throws CustomChangeException {
Set<String> clientSessionIdsToDelete = new HashSet<>();
String tableName = getTableName("OFFLINE_CLIENT_SESSION");
String colClientSessionId = database.correctObjectName("CLIENT_SESSION_ID", Column.class);
try (PreparedStatement ps = connection.prepareStatement(String.format(
"SELECT t.CLIENT_SESSION_ID, t.USER_SESSION_ID, t.CLIENT_ID, t.OFFLINE_FLAG" +
" FROM %1$s t," +
" (SELECT USER_SESSION_ID, CLIENT_ID, OFFLINE_FLAG" +
" FROM %1$s" +
" GROUP BY USER_SESSION_ID, CLIENT_ID, OFFLINE_FLAG" +
" HAVING COUNT(*) > 1) t1" +
" WHERE t.USER_SESSION_ID = t1.USER_SESSION_ID" +
" AND t.CLIENT_ID = t1.CLIENT_ID" +
" AND t.OFFLINE_FLAG = t1.OFFLINE_FLAG" +
" ORDER BY t.USER_SESSION_ID, t.CLIENT_ID, t.OFFLINE_FLAG", tableName));
ResultSet resultSet = ps.executeQuery()
) {
// Find out all offending duplicates, keep first row only
Key origKey = new Key(null, null, null);
while (resultSet.next()) {
String clientSessionId = resultSet.getString(1);
Key key = new Key(resultSet.getString(2), resultSet.getString(3), resultSet.getString(4));
if (key.equals(origKey)) {
clientSessionIdsToDelete.add(clientSessionId);
} else {
origKey = key;
}
}
} catch (Exception e) {
throw new CustomChangeException(getTaskId() + ": Exception when updating data from previous version", e);
}
AtomicInteger ai = new AtomicInteger();
clientSessionIdsToDelete.stream()
.collect(Collectors.groupingByConcurrent(id -> ai.getAndIncrement() / 20, Collectors.toList())) // Split into chunks of at most 20 items
.values().stream()
.map(ids -> new DeleteStatement(null, null, "OFFLINE_CLIENT_SESSION")
.setWhere(":name IN (" + ids.stream().map(id -> "?").collect(Collectors.joining(",")) + ")")
.addWhereColumnName(colClientSessionId)
.addWhereParameters(ids.toArray())
)
.forEach(statements::add);
}
@Override
protected String getTaskId() {
return "Leave only single offline session per user and client";
}
}