Mercurial > dive4elements > river

comparison backend/src/main/java/org/dive4elements/river/importer/sinfo/importitem/DepthEvolutionSeriesImport.java @ 9657:a79881a892c9

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Importer (s/u-info) extensions: depth-evolution: corrected directory name Bezug_aktueller_GlW, detecting and logging of wrong units, then cancelling, various checks of the plausibility of the meta data year values and cancelling in case of errors, detecting and logging missing change values, skipping those lines
author mschaefer
date Mon, 23 Mar 2020 15:26:50 +0100
parents 4c5eeaff554c
children
comparison
equal deleted inserted replaced
9656:31549fdfaf4f 9657:a79881a892c9
16 import org.dive4elements.river.importer.common.AbstractSeriesImport; 16 import org.dive4elements.river.importer.common.AbstractSeriesImport;
17 import org.dive4elements.river.model.River; 17 import org.dive4elements.river.model.River;
18 import org.dive4elements.river.model.sinfo.DepthEvolution; 18 import org.dive4elements.river.model.sinfo.DepthEvolution;
19 import org.dive4elements.river.model.sinfo.DepthEvolution.Group; 19 import org.dive4elements.river.model.sinfo.DepthEvolution.Group;
20 import org.dive4elements.river.model.sinfo.DepthEvolutionValue; 20 import org.dive4elements.river.model.sinfo.DepthEvolutionValue;
21 import org.hibernate.SQLQuery; 21 import org.hibernate.Query;
22 import org.hibernate.Session; 22 import org.hibernate.Session;
23 23
24 /** 24 /**
25 * Imported depth evolution data series of a river 25 * Imported depth evolution data series of a river
26 * 26 *
63 63
64 public void setStart_year(final Integer start_year) { 64 public void setStart_year(final Integer start_year) {
65 this.start_year = start_year; 65 this.start_year = start_year;
66 } 66 }
67 67
68 public Integer getStart_year() {
69 return this.start_year;
70 }
71
68 public void setReference_year(final Integer reference_year) { 72 public void setReference_year(final Integer reference_year) {
69 this.reference_year = reference_year; 73 this.reference_year = reference_year;
74 }
75
76 public Integer getReference_year() {
77 return this.reference_year;
70 } 78 }
71 79
72 public void setCurr_sounding(final String curr_sounding) { 80 public void setCurr_sounding(final String curr_sounding) {
73 this.curr_sounding = curr_sounding; 81 this.curr_sounding = curr_sounding;
74 } 82 }
89 public Logger getLog() { 97 public Logger getLog() {
90 return log; 98 return log;
91 } 99 }
92 100
93 @Override 101 @Override
94 public List<DepthEvolution> querySeriesItem(final Session session, final River river) { 102 public List<DepthEvolution> querySeriesItem(final Session session, final River river, final boolean doQueryParent) {
95 /* 103 final Query query = session.createQuery("FROM DepthEvolution WHERE river=:river AND lower(filename)=:filename");
96 * final Query query = session.createQuery("FROM DepthEvolution WHERE river=:river AND lower(filename)=:filename"); 104 query.setParameter("river", river);
97 * query.setParameter("river", river); 105 query.setParameter("filename", this.filename.toLowerCase());
98 * query.setParameter("filename", this.filename.toLowerCase());
99 */
100 final SQLQuery query = session.createSQLQuery("SELECT * FROM depth_evolution WHERE (river_id=:river) AND (lower(filename)=:filename)");
101 query.setParameter("river", river.getId());
102 query.setParameter("filename", getFilename().toLowerCase());
103 return query.list(); 106 return query.list();
104 } 107 }
105 108
106 109
107 @Override 110 @Override
http://dive4elements.wald.intevation.org