org.n52.proxy.db.da.InsertRepository Maven / Gradle / Ivy
Go to download
Show more of this group Show more artifacts with this name
Show all versions of proxy-dao Show documentation
Show all versions of proxy-dao Show documentation
REST SPI Implementation for SOS Proxy.
/*
* Copyright (C) 2013-2017 52°North Initiative for Geospatial Open Source
* Software GmbH
*
* This program is free software; you can redistribute it and/or modify it
* under the terms of the GNU General Public License version 2 as published
* by the Free Software Foundation.
*
* If the program is linked with libraries which are licensed under one of
* the following licenses, the combination of the program with the linked
* library is not considered a "derivative work" of the program:
*
* - Apache License, version 2.0
* - Apache Software License, version 1.0
* - GNU Lesser General Public License, version 3
* - Mozilla Public License, versions 1.0, 1.1 and 2.0
* - Common Development and Distribution License (CDDL), version 1.0
*
* Therefore the distribution of the program linked with libraries licensed
* under the aforementioned licenses, is permitted by the copyright holders
* if the distribution is compliant with both the GNU General Public License
* version 2 and the aforementioned licenses.
*
* This program is distributed in the hope that it will be useful, but
* WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY
* or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License
* for more details.
*/
package org.n52.proxy.db.da;
import static java.util.stream.Collectors.toSet;
import java.util.Collection;
import java.util.Set;
import org.hibernate.HibernateException;
import org.hibernate.Session;
import org.hibernate.Transaction;
import org.slf4j.Logger;
import org.slf4j.LoggerFactory;
import org.n52.proxy.config.DataSourceConfiguration;
import org.n52.proxy.db.beans.ProxyServiceEntity;
import org.n52.proxy.db.beans.RelatedFeatureEntity;
import org.n52.proxy.db.beans.RelatedFeatureRoleEntity;
import org.n52.proxy.db.dao.ProxyCategoryDao;
import org.n52.proxy.db.dao.ProxyDataDao;
import org.n52.proxy.db.dao.ProxyDatasetDao;
import org.n52.proxy.db.dao.ProxyFeatureDao;
import org.n52.proxy.db.dao.ProxyOfferingDao;
import org.n52.proxy.db.dao.ProxyPhenomenonDao;
import org.n52.proxy.db.dao.ProxyProcedureDao;
import org.n52.proxy.db.dao.ProxyRelatedFeatureDao;
import org.n52.proxy.db.dao.ProxyRelatedFeatureRoleDao;
import org.n52.proxy.db.dao.ProxyServiceDao;
import org.n52.series.db.beans.CategoryEntity;
import org.n52.series.db.beans.DataEntity;
import org.n52.series.db.beans.DatasetEntity;
import org.n52.series.db.beans.FeatureEntity;
import org.n52.series.db.beans.OfferingEntity;
import org.n52.series.db.beans.PhenomenonEntity;
import org.n52.series.db.beans.ProcedureEntity;
import org.n52.series.db.da.SessionAwareRepository;
public class InsertRepository extends SessionAwareRepository {
private static final Logger LOGGER = LoggerFactory.getLogger(InsertRepository.class);
public synchronized Set getIdsForService(ProxyServiceEntity service) {
Session session = getSession();
try {
return new ProxyDatasetDao<>(session).getIdsForService(service);
} finally {
returnSession(session);
}
}
public void cleanUp(ProxyServiceEntity service, Set datasetIds) {
Session session = getSession();
try {
Transaction transaction = session.beginTransaction();
new ProxyDatasetDao<>(session).removeDatasets(datasetIds);
new ProxyCategoryDao(session).clearUnusedForService(service);
new ProxyOfferingDao(session).clearUnusedForService(service);
new ProxyProcedureDao(session).clearUnusedForService(service);
new ProxyFeatureDao(session).clearUnusedForService(service);
new ProxyPhenomenonDao(session).clearUnusedForService(service);
new ProxyRelatedFeatureDao(session).clearUnusedForService(service);
new ProxyDataDao<>(session).clearUnusedForService(service);
session.flush();
transaction.commit();
} finally {
returnSession(session);
}
}
public void removeNonMatchingServices(Set configuredServices) {
Session session = getSession();
try {
new ProxyServiceDao(session)
.getAllServices().stream()
.filter(service -> !isConfigured(configuredServices, service))
.forEach(this::removeService);
} finally {
returnSession(session);
}
}
private void removeService(ProxyServiceEntity service) {
Session session = getSession();
try {
Transaction transaction = session.beginTransaction();
new ProxyDatasetDao<>(session).removeAllOfService(service);
new ProxyDataDao<>(session).clearUnusedForService(service);
new ProxyCategoryDao(session).clearUnusedForService(service);
new ProxyOfferingDao(session).clearUnusedForService(service);
new ProxyProcedureDao(session).clearUnusedForService(service);
new ProxyFeatureDao(session).clearUnusedForService(service);
new ProxyPhenomenonDao(session).clearUnusedForService(service);
new ProxyRelatedFeatureDao(session).clearUnusedForService(service);
new ProxyServiceDao(session).deleteInstance(service);
new ProxyDataDao<>(session).clearUnusedForService(service);
session.flush();
transaction.commit();
} finally {
returnSession(session);
}
}
public ProxyServiceEntity insertService(ProxyServiceEntity service) {
Session session = getSession();
try {
Transaction transaction = session.beginTransaction();
ProxyServiceEntity insertedService = insertService(service, session);
session.flush();
transaction.commit();
return insertedService;
} finally {
returnSession(session);
}
}
private ProxyServiceEntity insertService(ProxyServiceEntity service, Session session) {
return new ProxyServiceDao(session).getOrInsertInstance(service);
}
private OfferingEntity insertOffering(OfferingEntity offering, Session session) {
return new ProxyOfferingDao(session).getOrInsertInstance(offering);
}
public synchronized DatasetEntity insertDataset(DatasetEntity dataset) {
Session session = getSession();
Transaction transaction = null;
try {
transaction = session.beginTransaction();
ProcedureEntity procedure = insertProcedure(dataset.getProcedure(), session);
CategoryEntity category = insertCategory(dataset.getCategory(), session);
OfferingEntity offering = insertOffering(dataset.getOffering(), session);
FeatureEntity feature = insertFeature(dataset.getFeature(), session);
PhenomenonEntity phenomenon = insertPhenomenon(dataset.getPhenomenon(), session);
DatasetEntity inserted
= insertDataset(dataset, category, procedure, offering, feature, phenomenon, session);
session.flush();
transaction.commit();
return inserted;
} catch (HibernateException e) {
if (transaction != null) {
transaction.rollback();
}
LOGGER.error("Error occured while saving dataset: ", e);
} finally {
returnSession(session);
}
return null;
}
private DatasetEntity insertDataset(DatasetEntity dataset, CategoryEntity category, ProcedureEntity procedure,
OfferingEntity offering, FeatureEntity feature, PhenomenonEntity phenomenon,
Session session) {
dataset.setCategory(category);
dataset.setProcedure(procedure);
dataset.setOffering(offering);
dataset.setFeature(feature);
dataset.setPhenomenon(phenomenon);
if (dataset.getUnit() != null) {
dataset.getUnit().setService(dataset.getService());
}
return new ProxyDatasetDao<>(session).getOrInsertInstance(dataset);
}
public synchronized void insertRelatedFeature(Collection relatedFeatures) {
Session session = getSession();
try {
Transaction transaction = session.beginTransaction();
relatedFeatures.forEach(relatedFeature -> insertRelatedFeature(relatedFeature, session));
session.flush();
transaction.commit();
} catch (HibernateException e) {
LOGGER.error("Error occured while saving related feature", e);
} finally {
returnSession(session);
}
}
private RelatedFeatureEntity insertRelatedFeature(RelatedFeatureEntity relatedFeature, Session session) {
// insert related feature roles
Set roles = relatedFeature.getRelatedFeatureRoles().stream()
.map(relatedFeatureRole -> insertRelatedFeatureRole(relatedFeatureRole, session))
.collect(toSet());
relatedFeature.setRelatedFeatureRoles(roles);
// insert offerings
Set offerings = relatedFeature.getOfferings().stream()
.map(offering -> insertOffering(offering, session)).collect(toSet());
relatedFeature.setOfferings(offerings);
return new ProxyRelatedFeatureDao(session).getOrInsertInstance(relatedFeature);
}
private ProcedureEntity insertProcedure(ProcedureEntity procedure, Session session) {
return new ProxyProcedureDao(session).getOrInsertInstance(procedure);
}
private CategoryEntity insertCategory(CategoryEntity category, Session session) {
return new ProxyCategoryDao(session).getOrInsertInstance(category);
}
private FeatureEntity insertFeature(FeatureEntity feature, Session session) {
return new ProxyFeatureDao(session).getOrInsertInstance(feature);
}
private PhenomenonEntity insertPhenomenon(PhenomenonEntity phenomenon, Session session) {
return new ProxyPhenomenonDao(session).getOrInsertInstance(phenomenon);
}
private RelatedFeatureRoleEntity insertRelatedFeatureRole(RelatedFeatureRoleEntity relatedFeatureRole,
Session session) {
return new ProxyRelatedFeatureRoleDao(session).getOrInsertInstance(relatedFeatureRole);
}
protected boolean isConfigured(Set configuredServices, ProxyServiceEntity service) {
return configuredServices.stream().anyMatch(configuration -> equals(configuration, service));
}
protected boolean equals(DataSourceConfiguration configuration, ProxyServiceEntity service) {
return configuration.getUrl().equals(service.getUrl()) &&
configuration.getItemName().equals(service.getName());
}
public void insertData(DatasetEntity dataset, DataEntity data) {
data.setSeriesPkid(dataset.getPkid());
Session session = getSession();
Transaction transaction = null;
try {
transaction = session.beginTransaction();
new ProxyDataDao<>(session).getOrInsertInstance(data);
session.flush();
transaction.commit();
} catch (HibernateException e) {
LOGGER.error("Error occured while saving data", e);
if (transaction != null) {
transaction.rollback();
}
} finally {
returnSession(session);
}
}
}
© 2015 - 2025 Weber Informatics LLC | Privacy Policy