Mercurial > dive4elements > river
view flys-backend/src/main/java/de/intevation/flys/importer/ImportSQRelation.java @ 3662:0d27d02b1208
backend: Completed the error messages of the importer.
flys-backend/trunk@5266 c6561f87-3c4e-4783-a992-168aeb5c3f6f
author | Sascha L. Teichmann <sascha.teichmann@intevation.de> |
---|---|
date | Fri, 24 Aug 2012 15:47:31 +0000 |
parents | cc8fc6b29649 |
children | a5b003595d6c |
line wrap: on
line source
package de.intevation.flys.importer; import java.sql.SQLException; import java.util.ArrayList; import java.util.List; import org.apache.log4j.Logger; import org.hibernate.Query; import org.hibernate.Session; import org.hibernate.exception.ConstraintViolationException; import de.intevation.flys.model.River; import de.intevation.flys.model.SQRelation; import de.intevation.flys.model.TimeInterval; public class ImportSQRelation { private static Logger log = Logger.getLogger(ImportSQRelation.class); private ImportTimeInterval timeInterval; private String description; private List<ImportSQRelationValue> values; private SQRelation peer; public ImportSQRelation() { this.values = new ArrayList<ImportSQRelationValue>(); } public void storeDependencies(River river) throws SQLException, ConstraintViolationException { log.info("store dependencies"); SQRelation peer = getPeer(river); timeInterval.getPeer(); int count = 0; for (ImportSQRelationValue value: values) { try { value.storeDependencies(peer); count++; } catch (SQLException sqle) { log.warn("ISQ: Unable to store sq relation value.", sqle); } catch (ConstraintViolationException cve) { log.warn("ISQ: Unable to store sq relation value.", cve); } } log.info("stored " + count + " sq relation values."); } public SQRelation getPeer(River river) { log.debug("getPeer()"); if (peer == null) { TimeInterval timeInter = timeInterval.getPeer(); if (timeInter == null) { log.warn("ISQ: Cannot determine sq relation without time interval"); return null; } Session session = ImporterSession.getInstance().getDatabaseSession(); Query query = session.createQuery( "FROM SQRelation WHERE river=:river AND timeInterval=:timeInter" ); query.setParameter("river", river); query.setParameter("timeInter", timeInter); List<SQRelation> sq = query.list(); if (sq.isEmpty()) { log.info("create new SQ relation '" + description + "'"); peer = new SQRelation( river, timeInter, description ); session.save(peer); } else { peer = sq.get(0); } } return peer; } public void setDescription(String description) { this.description = description; } public void setTimeInterval(ImportTimeInterval timeInterval) { this.timeInterval = timeInterval; } public void addValue(ImportSQRelationValue value) { if (value != null) { this.values.add(value); } } } // vim:set ts=4 sw=4 si et sta sts=4 fenc=utf8 :