Mercurial > dive4elements > river
comparison artifacts/src/main/java/org/dive4elements/river/artifacts/model/minfo/QualityMeasurementFactory.java @ 8856:5e38e2924c07 3.2.x
Fix code style.
| author | Tom Gottfried <tom@intevation.de> |
|---|---|
| date | Thu, 18 Jan 2018 20:12:01 +0100 |
| parents | 5855f919cbd6 |
| children | 0a5239a1e46e |
comparison
equal
deleted
inserted
replaced
| 8855:d7c005e12af0 | 8856:5e38e2924c07 |
|---|---|
| 22 import org.dive4elements.river.artifacts.model.RiverFactory; | 22 import org.dive4elements.river.artifacts.model.RiverFactory; |
| 23 | 23 |
| 24 | 24 |
| 25 public class QualityMeasurementFactory { | 25 public class QualityMeasurementFactory { |
| 26 | 26 |
| 27 private static Logger log = Logger.getLogger(QualityMeasurementFactory.class); | 27 private static Logger log = Logger.getLogger( |
| 28 QualityMeasurementFactory.class); | |
| 28 | 29 |
| 29 private static final String SQL_BED_MEASUREMENT = | 30 private static final String SQL_BED_MEASUREMENT = |
| 30 "SELECT dat.km as km," + | 31 "SELECT dat.km as km," + |
| 31 " dat.datum as datum," + | 32 " dat.datum as datum," + |
| 32 " sp.tiefevon as depth1," + | 33 " sp.tiefevon as depth1," + |
| 53 " JOIN sohlprobe sp ON sp.sohltestid = dat.sohltestid " + | 54 " JOIN sohlprobe sp ON sp.sohltestid = dat.sohltestid " + |
| 54 " JOIN siebanalyse sa ON sa.sohlprobeid = sp.sohlprobeid " + | 55 " JOIN siebanalyse sa ON sa.sohlprobeid = sp.sohlprobeid " + |
| 55 "WHERE gw.name = :name AND " + | 56 "WHERE gw.name = :name AND " + |
| 56 " dat.km IS NOT NULL AND " + | 57 " dat.km IS NOT NULL AND " + |
| 57 " sp.tiefevon IS NOT NULL AND " + | 58 " sp.tiefevon IS NOT NULL AND " + |
| 58 " sp.tiefebis IS NOT NULL AND " + // TODO: Test if char diameter ist null. | 59 " sp.tiefebis IS NOT NULL AND " + |
| 59 " dat.km BETWEEN :from - 0.001 AND :to + 0.001 "; | 60 " dat.km BETWEEN :from - 0.001 AND :to + 0.001 "; |
| 61 // TODO: Test if char diameter ist null. | |
| 60 | 62 |
| 61 private static final String SQL_BEDLOAD_MEASUREMENT = | 63 private static final String SQL_BEDLOAD_MEASUREMENT = |
| 62 "SELECT dat.km as km," + | 64 "SELECT dat.km as km," + |
| 63 " dat.datum as datum," + | 65 " dat.datum as datum," + |
| 64 " dat.dm as dm," + | 66 " dat.dm as dm," + |