Mercurial > dive4elements > river
comparison artifacts/src/main/java/org/dive4elements/river/artifacts/model/minfo/BedOverview.java @ 8780:85f36f9f1bd3
Issue1854: Adapt statement to QualityMeasurementFactory
| author | Tom Gottfried <tom@intevation.de> |
|---|---|
| date | Mon, 07 Dec 2015 17:03:34 +0100 |
| parents | 50ff99266e0e |
| children | 0a5239a1e46e |
comparison
equal
deleted
inserted
replaced
| 8779:50ff99266e0e | 8780:85f36f9f1bd3 |
|---|---|
| 88 public static final String SQL_SQ = | 88 public static final String SQL_SQ = |
| 89 "SELECT" + | 89 "SELECT" + |
| 90 " so.km AS km," + | 90 " so.km AS km," + |
| 91 " so.datum AS datum " + | 91 " so.datum AS datum " + |
| 92 "FROM sohltest so " + | 92 "FROM sohltest so " + |
| 93 " JOIN station s" + | 93 " JOIN station s ON so.stationid = s.stationid " + |
| 94 " ON so.stationid = s.stationid " + | 94 " JOIN gewaesser g ON s.gewaesserid = g.gewaesserid " + |
| 95 " JOIN gewaesser g " + | 95 " JOIN sohlprobe sp ON sp.sohltestid = so.sohltestid " + |
| 96 " ON s.gewaesserid = g.gewaesserid " + | 96 " JOIN siebanalyse sa ON sa.sohlprobeid = sp.sohlprobeid " + |
| 97 "WHERE" + | 97 "WHERE" + |
| 98 " g.name = :name" + | 98 " g.name = :name" + |
| 99 " AND so.km IS NOT NULL" + | 99 " AND so.km IS NOT NULL" + |
| 100 " AND so.km BETWEEN :from AND :to " + | 100 " AND so.km BETWEEN :from AND :to " + |
| 101 "ORDER by" + | 101 " AND sp.tiefevon IS NOT NULL " + |
| 102 " so.km, so.datum"; | 102 " AND sp.tiefebis IS NOT NULL " + |
| 103 "ORDER BY so.km, so.datum"; | |
| 103 | 104 |
| 104 protected String riverName; | 105 protected String riverName; |
| 105 protected String SeddbRiverName; | 106 protected String SeddbRiverName; |
| 106 | 107 |
| 107 protected KMIndex<List<Date>> entries; | 108 protected KMIndex<List<Date>> entries; |