mschaefer@8971: /* Copyright (C) 2017 by Bundesanstalt für Gewässerkunde
mschaefer@8971:  * Software engineering by
mschaefer@8971:  *  Björnsen Beratende Ingenieure GmbH
mschaefer@8971:  *  Dr. Schumacher Ingenieurbüro für Wasser und Umwelt
mschaefer@8971:  *
mschaefer@8971:  * This file is Free Software under the GNU AGPL (>=v3)
mschaefer@8971:  * and comes with ABSOLUTELY NO WARRANTY! Check out the
mschaefer@8971:  * documentation coming with Dive4Elements River for details.
mschaefer@8971:  */
mschaefer@8971: 
mschaefer@8971: package org.dive4elements.river.importer.sinfo.importitem;
mschaefer@8971: 
mschaefer@8971: import java.io.File;
mschaefer@8971: import java.util.List;
mschaefer@8971: 
mschaefer@8971: import org.apache.log4j.Logger;
mschaefer@8971: import org.dive4elements.river.importer.common.AbstractSeriesImport;
mschaefer@8971: import org.dive4elements.river.model.River;
mschaefer@8971: import org.dive4elements.river.model.sinfo.FlowDepthColumn;
mschaefer@8971: import org.dive4elements.river.model.sinfo.FlowDepthValue;
mschaefer@9656: import org.hibernate.Query;
mschaefer@8971: import org.hibernate.Session;
mschaefer@8971: 
mschaefer@8971: /**
mschaefer@8971:  * Imported flow depth data series of a river
mschaefer@8971:  *
mschaefer@8971:  * @author Matthias Schäfer
mschaefer@8971:  *
mschaefer@8971:  */
mschaefer@8971: public class FlowDepthColumnSeriesImport extends AbstractSeriesImport<FlowDepthColumn, FlowDepthValue, FlowDepthKmLineImport> {
mschaefer@8971: 
mschaefer@8971:     /***** FIELDS *****/
mschaefer@8971: 
mschaefer@8971:     private static Logger log = Logger.getLogger(FlowDepthColumnSeriesImport.class);
mschaefer@8971: 
mschaefer@8971:     private int year;
mschaefer@8971: 
mschaefer@8971:     private String sounding_info;
mschaefer@8971: 
mschaefer@8971:     private String evaluation_by;
mschaefer@8971: 
mschaefer@8971:     private final FlowDepthSeriesImport parent;
mschaefer@8971: 
mschaefer@8971:     private final String colName;
mschaefer@8971: 
mschaefer@8971:     private final File relativeFilePath;
mschaefer@8971: 
mschaefer@8971: 
mschaefer@8971:     /***** CONSTRUCTORS *****/
mschaefer@8971: 
mschaefer@8971:     public FlowDepthColumnSeriesImport(final String filename) {
mschaefer@8971:         this(filename, null, null, null);
mschaefer@8971:     }
mschaefer@8971: 
mschaefer@8971:     public FlowDepthColumnSeriesImport(final String filename, final FlowDepthSeriesImport parent, final String colName, final File relativeFilePath) {
mschaefer@8971:         super(filename);
mschaefer@8971:         this.parent = parent;
mschaefer@9656:         final String[] items = (colName == null) ? new String[] {} : colName.split("\\-");
mschaefer@9656:         if (items.length == 2)
mschaefer@9656:             this.colName = items[0].trim() + " - " + items[1].trim();
mschaefer@9656:         else
mschaefer@9656:             this.colName = colName;
mschaefer@8971:         this.relativeFilePath = relativeFilePath;
mschaefer@8971:     }
mschaefer@8971: 
mschaefer@8971: 
mschaefer@8971:     /***** METHODS *****/
mschaefer@8971: 
mschaefer@8971:     public int getYear() {
mschaefer@8971:         return this.year;
mschaefer@8971:     }
mschaefer@8971: 
mschaefer@8971:     public void setYear(final int year) {
mschaefer@8971:         this.year = year;
mschaefer@8971:     }
mschaefer@8971: 
mschaefer@8971:     public String getSounding_info() {
mschaefer@8971:         return this.sounding_info;
mschaefer@8971:     }
mschaefer@8971: 
mschaefer@8971:     public void setSounding_info(final String sounding_info) {
mschaefer@8971:         this.sounding_info = sounding_info;
mschaefer@8971:     }
mschaefer@8971: 
mschaefer@8971:     public String getEvaluation_by() {
mschaefer@8971:         return this.evaluation_by;
mschaefer@8971:     }
mschaefer@8971: 
mschaefer@8971:     public void setEvaluation_by(final String evaluation_by) {
mschaefer@8971:         this.evaluation_by = evaluation_by;
mschaefer@8971:     }
mschaefer@8971: 
mschaefer@8971:     @Override
mschaefer@8971:     public Logger getLog() {
mschaefer@8971:         return log;
mschaefer@8971:     }
mschaefer@8971: 
mschaefer@9656:     private List<FlowDepthColumn> querySeriesItem(final Session session, final River river) {
mschaefer@9656:         final Query query = session.createQuery("FROM FlowDepthColumn WHERE flowDepth=:parent AND lower(name)=:colname");
mschaefer@9656:         query.setParameter("parent", this.parent.getPeer(river));
mschaefer@8971:         query.setParameter("colname", this.colName.toLowerCase());
mschaefer@8971:         return query.list();
mschaefer@8971:     }
mschaefer@8971: 
mschaefer@9656:     @Override
mschaefer@9656:     public List<FlowDepthColumn> querySeriesItem(final Session session, final River river, final boolean doQueryParent) {
mschaefer@9656:         final Query query = session.createQuery("FROM FlowDepthColumn c INNER JOIN c.flowDepth s"
mschaefer@9656:                 + " WHERE s.river=:river AND lower(s.filename)=:filename AND lower(c.name)=:colname");
mschaefer@9656:         query.setParameter("river", river);
mschaefer@9656:         query.setParameter("filename", this.filename.toLowerCase());
mschaefer@9656:         query.setParameter("colname", this.colName.toLowerCase());
mschaefer@9656:         return query.list();
mschaefer@9656:     }
mschaefer@8971: 
mschaefer@8971:     @Override
mschaefer@8971:     public FlowDepthColumn createSeriesItem(final River river) {
mschaefer@8971:         return new FlowDepthColumn(this.parent.getPeer(river), this.colName);
mschaefer@8971:     }
mschaefer@8971: 
mschaefer@8971:     @Override
mschaefer@8971:     protected void logStoreInfo() {
mschaefer@8971:         getLog().info(String.format("Store series column '%s':;'%s'", this.colName, this.relativeFilePath));
mschaefer@8971:     }
mschaefer@8971: }