edu.internet2.middleware.grouper.internal.dao.hib3.Hib3PITConfigDAO Maven / Gradle / Ivy
Go to download
Show more of this group Show more artifacts with this name
Show all versions of grouper Show documentation
Show all versions of grouper Show documentation
Internet2 Groups Management Toolkit
/**
* Copyright 2014 Internet2
*
* 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 edu.internet2.middleware.grouper.internal.dao.hib3;
import java.sql.Timestamp;
import java.util.ArrayList;
import java.util.Collection;
import java.util.HashMap;
import java.util.HashSet;
import java.util.List;
import java.util.Map;
import java.util.Set;
import java.util.regex.Pattern;
import edu.internet2.middleware.grouper.app.config.GrouperConfigurationModuleAttribute;
import edu.internet2.middleware.grouper.cfg.GrouperConfig;
import edu.internet2.middleware.grouper.cfg.dbConfig.ConfigFileMetadata;
import edu.internet2.middleware.grouper.cfg.dbConfig.ConfigFileName;
import edu.internet2.middleware.grouper.cfg.dbConfig.DbConfigEngine;
import edu.internet2.middleware.grouper.cfg.dbConfig.GrouperConfigHibernate;
import edu.internet2.middleware.grouper.cfg.text.GrouperTextContainer;
import edu.internet2.middleware.grouper.hibernate.ByHqlStatic;
import edu.internet2.middleware.grouper.hibernate.HibUtils;
import edu.internet2.middleware.grouper.hibernate.HibernateSession;
import edu.internet2.middleware.grouper.internal.dao.PITConfigDAO;
import edu.internet2.middleware.grouper.internal.dao.QueryOptions;
import edu.internet2.middleware.grouper.internal.dao.QueryPaging;
import edu.internet2.middleware.grouper.internal.dao.QuerySort;
import edu.internet2.middleware.grouper.misc.GrouperDAOFactory;
import edu.internet2.middleware.grouper.pit.PITGrouperConfigHibernate;
import edu.internet2.middleware.grouper.util.GrouperUtil;
import edu.internet2.middleware.grouperClient.collections.MultiKey;
import org.apache.commons.lang3.StringUtils;
public class Hib3PITConfigDAO extends Hib3DAO implements PITConfigDAO {
/**
*
*/
private static final String KLASS = Hib3PITConfigDAO.class.getName();
/**
* @see edu.internet2.middleware.grouper.internal.dao.PITConfigDAO#saveOrUpdate(PITGrouperConfigHibernate)
*/
public void saveOrUpdate(PITGrouperConfigHibernate pitGrouperConfigHibernate) {
HibernateSession.byObjectStatic().saveOrUpdate(pitGrouperConfigHibernate);
}
/**
* @see edu.internet2.middleware.grouper.internal.dao.PITConfigDAO#saveOrUpdate(java.util.Set)
*/
public void saveOrUpdate(Set pitGrouperConfigHibernates) {
HibernateSession.byObjectStatic().saveOrUpdate(pitGrouperConfigHibernates);
}
/**
* @see edu.internet2.middleware.grouper.internal.dao.PITConfigDAO#delete(PITGrouperConfigHibernate)
*/
public void delete(PITGrouperConfigHibernate pitGrouperConfigHibernate) {
HibernateSession.byObjectStatic().delete(pitGrouperConfigHibernate);
}
/**
* reset
* @param hibernateSession
*/
public static void reset(HibernateSession hibernateSession) {//and subjectSourceId != 'g:isa'
hibernateSession.byHql().createQuery("delete from PITGrouperConfigHibernate where sourceId not in (select config.id from GrouperConfigHibernate as config) ").executeUpdate();
}
/**
* @see edu.internet2.middleware.grouper.internal.dao.PITConfigDAO#findBySourceIdActive(java.lang.String, boolean, boolean)
*/
public PITGrouperConfigHibernate findBySourceIdActive(String id, boolean createIfNotFound, boolean exceptionIfNotFound) {
PITGrouperConfigHibernate pitGrouperConfigHibernate = HibernateSession
.byHqlStatic()
.createQuery("select pitGrouperConfigHibernate from PITGrouperConfigHibernate as pitGrouperConfigHibernate where pitGrouperConfigHibernate.sourceId = :id and activeDb = 'T'")
.setCacheable(true).setCacheRegion(KLASS + ".FindBySourceIdActive")
.setString("id", id)
.uniqueResult(PITGrouperConfigHibernate.class);
if (pitGrouperConfigHibernate == null && exceptionIfNotFound) {
throw new RuntimeException("Active PITGrouperConfigHibernate with sourceId=" + id + " not found");
}
return pitGrouperConfigHibernate;
}
/**
* @see edu.internet2.middleware.grouper.internal.dao.PITConfigDAO#findBySourceIdActive(java.lang.String, boolean)
*/
@Override
public PITGrouperConfigHibernate findBySourceIdActive(String id, boolean exceptionIfNotFound) {
return findBySourceIdActive(id, false, exceptionIfNotFound);
}
/**
* @see edu.internet2.middleware.grouper.internal.dao.PITConfigDAO#findBySourceIdsActive(Collection))
*/
@Override
public Set findBySourceIdsActive(Collection ids) {
int idsSize = GrouperUtil.length(ids);
Set results = new HashSet();
if (idsSize == 0) {
return results;
}
List idsList = new ArrayList(ids);
int numberOfBatches = GrouperUtil.batchNumberOfBatches(idsSize, 100);
//if there are more than 100, batch these up and return them
for (int i=0;i currentBatch = GrouperUtil.batchList(idsList, 100, i);
sql.append(" pitGrouperConfigHibernate.sourceId in (");
sql.append(HibUtils.convertToInClause(currentBatch, byHqlStatic));
sql.append(") and activeDb = 'T'");
Set localResult = byHqlStatic.createQuery(sql.toString()).listSet(PITGrouperConfigHibernate.class);
results.addAll(localResult);
}
return results;
}
/**
* @see edu.internet2.middleware.grouper.internal.dao.PITConfigDAO#findByIds(Collection))
*/
@Override
public Set findByIds(Collection ids) {
int idsSize = GrouperUtil.length(ids);
Set results = new HashSet();
if (idsSize == 0) {
return results;
}
List idsList = new ArrayList(ids);
int numberOfBatches = GrouperUtil.batchNumberOfBatches(idsSize, 100);
//if there are more than 100, batch these up and return them
for (int i=0;i currentBatch = GrouperUtil.batchList(idsList, 100, i);
sql.append(" pitGrouperConfigHibernate.id in (");
sql.append(HibUtils.convertToInClause(currentBatch, byHqlStatic));
sql.append(")");
Set localResult = byHqlStatic.createQuery(sql.toString()).listSet(PITGrouperConfigHibernate.class);
results.addAll(localResult);
}
return results;
}
/**
* @see edu.internet2.middleware.grouper.internal.dao.PITConfigDAO#findBySourceIdUnique(java.lang.String, boolean)
*/
public PITGrouperConfigHibernate findBySourceIdUnique(String id, boolean exceptionIfNotFound) {
PITGrouperConfigHibernate pitGrouperConfigHibernate = HibernateSession
.byHqlStatic()
.createQuery("select pitGrouperConfigHibernate from PITGrouperConfigHibernate as pitGrouperConfigHibernate where pitGrouperConfigHibernate.sourceId = :id")
.setCacheable(false).setCacheRegion(KLASS + ".FindBySourceIdUnique")
.setString("id", id)
.uniqueResult(PITGrouperConfigHibernate.class);
if (pitGrouperConfigHibernate == null && exceptionIfNotFound) {
throw new RuntimeException("PITGrouperConfigHibernate with sourceId=" + id + " not found");
}
return pitGrouperConfigHibernate;
}
/**
* @see edu.internet2.middleware.grouper.internal.dao.PITConfigDAO#findBySourceId(java.lang.String, boolean)
*/
public Set findBySourceId(String id, boolean exceptionIfNotFound) {
Set results = HibernateSession
.byHqlStatic()
.createQuery("select pitGrouperConfigHibernate from PITGrouperConfigHibernate as pitGrouperConfigHibernate where pitGrouperConfigHibernate.sourceId = :id")
.setCacheable(false).setCacheRegion(KLASS + ".FindBySourceId")
.setString("id", id)
.listSet(PITGrouperConfigHibernate.class);
if (results.size() == 0 && exceptionIfNotFound) {
throw new RuntimeException("PITGrouperConfigHibernate with sourceId=" + id + " not found");
}
return results;
}
/**
* @see edu.internet2.middleware.grouper.internal.dao.PITConfigDAO#findById(java.lang.String, boolean)
*/
public PITGrouperConfigHibernate findById(String id, boolean exceptionIfNotFound) {
PITGrouperConfigHibernate pit = HibernateSession
.byHqlStatic()
.createQuery("select pit from PITGrouperConfigHibernate as pit where pit.id = :id")
.setCacheable(true).setCacheRegion(KLASS + ".FindById")
.setString("id", id)
.uniqueResult(PITGrouperConfigHibernate.class);
if (pit == null && exceptionIfNotFound) {
throw new RuntimeException("PITGrouperConfigHibernate with id=" + id + " not found");
}
return pit;
}
/**
* @see edu.internet2.middleware.grouper.internal.dao.PITConfigDAO#deleteInactiveRecords(java.sql.Timestamp)
*/
public long deleteInactiveRecords(Timestamp time) {
return HibernateSession.byHqlStatic().createQuery(
"select id from PITGrouperConfigHibernate where endTimeDb is not null and endTimeDb < :time")
.setLong("time", time.getTime() * 1000)
.deleteInBatches(String.class, "PITGrouperConfigHibernate", "id");
}
/**
* @see edu.internet2.middleware.grouper.internal.dao.PITConfigDAO#findActiveDuplicates()
*/
public Set findActiveDuplicates() {
return HibernateSession
.byHqlStatic()
.createQuery("select sourceId from PITGrouperConfigHibernate where active='T' group by sourceId having count(*) > 1")
.setCacheable(false)
.listSet(String.class);
}
/**
* @see edu.internet2.middleware.grouper.internal.dao.PITConfigDAO#delete(java.lang.String)
*/
public void delete(String id) {
HibernateSession.byHqlStatic()
.createQuery("delete from PITGrouperConfigHibernate where id = :id")
.setString("id", id)
.executeUpdate();
}
/**
* @see edu.internet2.middleware.grouper.internal.dao.PITConfigDAO#findMissingActivePITConfigs()
*/
@Override
public Set findMissingActivePITConfigs() {
Set configs = HibernateSession
.byHqlStatic()
.createQuery("select config from GrouperConfigHibernate config where " +
"not exists (select 1 from PITGrouperConfigHibernate pit where config.id = pit.sourceId)")
.setCacheable(false).setCacheRegion(KLASS + ".FindMissingActivePITConfigs")
.listSet(GrouperConfigHibernate.class);
return configs;
}
/**
* @see edu.internet2.middleware.grouper.internal.dao.PITConfigDAO#findMissingInactivePITConfigs()
*/
@Override
public Set findMissingInactivePITConfigs() {
Set pitConfigs = HibernateSession
.byHqlStatic()
.createQuery("select pit from PITGrouperConfigHibernate pit where activeDb = 'T' and " +
"not exists (select 1 from GrouperConfigHibernate config where config.id = pit.sourceId)")
.setCacheable(false).setCacheRegion(KLASS + ".FindMissingInactivePITConfigs")
.listSet(PITGrouperConfigHibernate.class);
return pitConfigs;
}
/**
* @see edu.internet2.middleware.grouper.internal.dao.PITConfigDAO#findPITConfigs(QueryOptions, String)
*/
@Override
public List findPITConfigs(QueryOptions queryOptions, String filter) {
StringBuilder sql = new StringBuilder("select pit from PITGrouperConfigHibernate as pit ");
if (StringUtils.isNotBlank(filter)) {
sql.append(" where lower(pit.configKey) like lower('%"+filter+"%') ");
sql.append(" or lower(pit.configValueDb) like lower('%"+filter+"%') ");
sql.append(" or lower(pit.configValueClobDb) like lower('%"+filter+"%') ");
sql.append(" or lower(pit.previousConfigValueDb) like lower('%"+filter+"%') ");
sql.append(" or lower(pit.previousConfigValueClobDb) like lower('%"+filter+"%') ");
}
if (queryOptions == null) {
queryOptions = new QueryOptions();
}
if (queryOptions.getQueryPaging() == null) {
int defaultHib3AuditEntryPageSize = GrouperConfig.retrieveConfig().propertyValueInt("defaultHib3AuditEntryPageSize", 50);
queryOptions.paging(QueryPaging.page(defaultHib3AuditEntryPageSize, 1, false));
}
if (queryOptions.getQuerySort() == null) {
queryOptions.sort(QuerySort.desc("startTimeDb"));
}
ByHqlStatic byHqlStatic = HibernateSession.byHqlStatic().options(queryOptions)
.setCacheable(true)
.setCacheRegion(KLASS + ".FindPITConfigs");
List pitConfigs = byHqlStatic.createQuery(sql.toString()).list(PITGrouperConfigHibernate.class);
return pitConfigs;
}
/**
* @see edu.internet2.middleware.grouper.internal.dao.PITConfigDAO#revertConfigs(Set, StringBuilder, List, Map)
*/
@Override
public void revertConfigs(Set pitIds, StringBuilder message,
List errorsToDisplay, Map validationErrorsToDisplay) {
Set oldPitConfigs = findByIds(pitIds);
Map configKeyCount = new HashMap();
for (PITGrouperConfigHibernate oldPitConfig: oldPitConfigs) {
if (configKeyCount.containsKey(oldPitConfig.getConfigKey())) {
Integer existingCount = configKeyCount.get(oldPitConfig.getConfigKey());
configKeyCount.put(oldPitConfig.getConfigKey(), existingCount+1);
} else {
configKeyCount.put(oldPitConfig.getConfigKey(), 1);
}
}
String errorMessage = GrouperTextContainer.retrieveFromRequest().getText().get("configurationHistoryRevertErrorDuplicateConfigKeys");
for (String key: configKeyCount.keySet()) {
Integer size = configKeyCount.get(key);
if (size > 1) {
errorsToDisplay.add(errorMessage.replace("#configKey", key));
}
}
if (errorsToDisplay.size() > 0) {
return;
}
int count = 1;
Pattern endOfStringNewlinePattern = Pattern.compile(".*$");
Set configFileNameAndKeys = new HashSet();
for (PITGrouperConfigHibernate oldPitConfig: oldPitConfigs) {
MultiKey configFileNameAndKey = new MultiKey(oldPitConfig.getConfigFileName(), oldPitConfig.getConfigKey());
configFileNameAndKeys.add(configFileNameAndKey);
}
Map> keyToConfigHibernate = GrouperDAOFactory.getFactory().getConfig().findByFileAndKey(configFileNameAndKeys);
for (PITGrouperConfigHibernate oldPitConfig: oldPitConfigs) {
String fullPropertyName = oldPitConfig.getConfigKey();
String propertyNameString = GrouperUtil.stripSuffix(fullPropertyName, ".elConfig");
Set grouperConfigHibernates = keyToConfigHibernate.get(propertyNameString);
String propertyNameStringEl = propertyNameString + ".elConfig";
Set grouperConfigHibernatesEl = keyToConfigHibernate.get(propertyNameStringEl);
if (StringUtils.isBlank(oldPitConfig.getPreviousValue())) {
DbConfigEngine.configurationFileItemDeleteHelper(oldPitConfig.getConfigFileName(),
oldPitConfig.getConfigKey(), true,
count == oldPitConfigs.size(), new ArrayList(), grouperConfigHibernates, grouperConfigHibernatesEl );
} else {
boolean el = oldPitConfig.getConfigKey().endsWith(".elConfig");
StringBuilder localMessage = new StringBuilder();
ConfigFileName configFileName = ConfigFileName.valueOfIgnoreCase(oldPitConfig.getConfigFileName(), false);
ConfigFileMetadata configFileMetadata = configFileName.configFileMetadata();
List actionsPerformed = new ArrayList();
DbConfigEngine.configurationFileAddEditHelper2(configFileName, configFileName.getConfigFileName(),configFileMetadata,
oldPitConfig.getConfigKey(),
el ? "true": "false", oldPitConfig.getPreviousValue(), oldPitConfig.isConfigEncrypted(), message,
new Boolean[] {false},
new Boolean[] {false}, true, "Edited from config history screen", errorsToDisplay, validationErrorsToDisplay, count == oldPitConfigs.size(), actionsPerformed,
grouperConfigHibernates, grouperConfigHibernatesEl );
if (localMessage.length() > 0) {
if(message.length() > 0) {
if (!endOfStringNewlinePattern.matcher(message).matches()) {
message.append("
\n");
}
message.append(localMessage);
}
}
}
count++;
}
}
}
© 2015 - 2024 Weber Informatics LLC | Privacy Policy