Mercurial > dive4elements > river
comparison backend/src/main/java/org/dive4elements/river/importer/sinfo/importitem/TkhKmLineImport.java @ 9655:1f57381b3bb5
Importer (s/u-info) extensions: uniform formatting of from-to series names,
warning instead of cancelling in case of missing tkh column values,
detecting, logging and skipping columns with wrong unit
| author | mschaefer |
|---|---|
| date | Mon, 23 Mar 2020 15:16:35 +0100 |
| parents | bf8a9df86f32 |
| children |
comparison
equal
deleted
inserted
replaced
| 9654:8a2a777a8372 | 9655:1f57381b3bb5 |
|---|---|
| 13 import java.util.List; | 13 import java.util.List; |
| 14 | 14 |
| 15 import org.dive4elements.river.importer.common.AbstractKmLineImport; | 15 import org.dive4elements.river.importer.common.AbstractKmLineImport; |
| 16 import org.dive4elements.river.model.sinfo.TkhColumn; | 16 import org.dive4elements.river.model.sinfo.TkhColumn; |
| 17 import org.dive4elements.river.model.sinfo.TkhValue; | 17 import org.dive4elements.river.model.sinfo.TkhValue; |
| 18 import org.hibernate.SQLQuery; | 18 import org.hibernate.Query; |
| 19 import org.hibernate.Session; | 19 import org.hibernate.Session; |
| 20 | 20 |
| 21 /** | 21 /** |
| 22 * Imported Transportkörperhöhe value of a river station. | 22 * Imported Transportkörperhöhe value of a river station. |
| 23 * | 23 * |
| 44 | 44 |
| 45 /***** METHODS *****/ | 45 /***** METHODS *****/ |
| 46 | 46 |
| 47 @Override | 47 @Override |
| 48 protected TkhValue queryValueItem(final Session session, final TkhColumn parent) { | 48 protected TkhValue queryValueItem(final Session session, final TkhColumn parent) { |
| 49 /* | 49 final Query query = session.createQuery("FROM TkhValue WHERE (tkhColumn=:parent)" |
| 50 * final Query query = session.createQuery("FROM TkhValue WHERE (TkhColumn=:parent)" | |
| 51 * + " AND (station BETWEEN (:station-0.0001) AND (:station+0.0001))"); | |
| 52 * query.setParameter("parent", parent); | |
| 53 * query.setParameter("station", this.station); | |
| 54 */ | |
| 55 final SQLQuery query = session.createSQLQuery("SELECT * FROM tkh_values WHERE (tkh_column_id=:parent)" | |
| 56 + " AND (station BETWEEN (:station-0.0001) AND (:station+0.0001))"); | 50 + " AND (station BETWEEN (:station-0.0001) AND (:station+0.0001))"); |
| 57 query.setParameter("parent", parent.getId()).setParameter("station", this.station); | 51 query.setParameter("parent", parent); |
| 52 query.setParameter("station", this.station); | |
| 58 final List rows = query.list(); | 53 final List rows = query.list(); |
| 59 if (!rows.isEmpty()) | 54 if (!rows.isEmpty()) |
| 60 return (TkhValue) rows.get(0); | 55 return (TkhValue) rows.get(0); |
| 61 else | 56 else |
| 62 return null; | 57 return null; |