Mercurial > dive4elements > river
comparison artifacts/src/main/java/org/dive4elements/river/artifacts/model/sq/MeasurementFactory.java @ 7704:a877d2680a4a
SQ relation: only take sieve which have values at all.
| author | Sascha L. Teichmann <teichmann@intevation.de> |
|---|---|
| date | Tue, 17 Dec 2013 17:59:37 +0100 |
| parents | 7efeaa2058e1 |
| children | 0737573aa9ac |
comparison
equal
deleted
inserted
replaced
| 7703:5484818087de | 7704:a877d2680a4a |
|---|---|
| 114 "COALESCE(gs.RSIEB11, 0) + COALESCE(gs.RSIEB12, 0) +" + | 114 "COALESCE(gs.RSIEB11, 0) + COALESCE(gs.RSIEB12, 0) +" + |
| 115 "COALESCE(gs.RSIEB13, 0) + COALESCE(gs.RSIEB14, 0) +" + | 115 "COALESCE(gs.RSIEB13, 0) + COALESCE(gs.RSIEB14, 0) +" + |
| 116 "COALESCE(gs.RSIEB15, 0) + COALESCE(gs.RSIEB16, 0) +" + | 116 "COALESCE(gs.RSIEB15, 0) + COALESCE(gs.RSIEB16, 0) +" + |
| 117 "COALESCE(gs.RSIEB17, 0) + COALESCE(gs.RSIEB18, 0) +" + | 117 "COALESCE(gs.RSIEB17, 0) + COALESCE(gs.RSIEB18, 0) +" + |
| 118 "COALESCE(gs.RSIEB19, 0) + COALESCE(gs.RSIEB20, 0) +" + | 118 "COALESCE(gs.RSIEB19, 0) + COALESCE(gs.RSIEB20, 0) +" + |
| 119 "COALESCE(gs.RSIEB21, 0) + COALESCE(gs.REST, 0)) >= 0 " + | 119 "COALESCE(gs.RSIEB21, 0) + COALESCE(gs.REST, 0)) > 0 " + |
| 120 "ORDER BY " + | 120 "ORDER BY " + |
| 121 "m.DATUM, g.UFERABST, g.GLOTRECHTEID, gp.LFDNR"; | 121 "m.DATUM, g.UFERABST, g.GLOTRECHTEID, gp.LFDNR"; |
| 122 | 122 |
| 123 private static final int index(String s) { | 123 private static final int index(String s) { |
| 124 return Integer.parseInt(s.substring(s.length()-2))-1; | 124 return Integer.parseInt(s.substring(s.length()-2))-1; |
| 152 for (int i = 0; i < tuple.length; ++i) { | 152 for (int i = 0; i < tuple.length; ++i) { |
| 153 nextLine[i] = tuple[i] != null ? tuple[i].toString() : ""; | 153 nextLine[i] = tuple[i] != null ? tuple[i].toString() : ""; |
| 154 } | 154 } |
| 155 rawWriter.writeNext(nextLine); | 155 rawWriter.writeNext(nextLine); |
| 156 } | 156 } |
| 157 } | 157 } // class CSVTransformer |
| 158 | 158 |
| 159 public static class FractionsTransformer extends CSVTransformer { | 159 public static class FractionsTransformer extends CSVTransformer { |
| 160 | 160 |
| 161 private static final long serialVersionUID = 1L; | 161 private static final long serialVersionUID = 1L; |
| 162 | 162 |