Mercurial > dive4elements > river

comparison artifacts/src/main/java/org/dive4elements/river/artifacts/model/minfo/QualityMeasurementFactory.java @ 6358:e1093f75a36f

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Order bed quality data by km.
author Raimund Renkert <rrenkert@intevation.de>
date Tue, 18 Jun 2013 09:09:42 +0200
parents af13ceeba52a
children 6a67a8f01f5b
comparison
equal deleted inserted replaced
6357:673e146e7793 6358:e1093f75a36f
53 "WHERE gw.name = :name AND " + 53 "WHERE gw.name = :name AND " +
54 " st.km IS NOT NULL AND " + 54 " st.km IS NOT NULL AND " +
55 " sp.tiefevon IS NOT NULL AND " + 55 " sp.tiefevon IS NOT NULL AND " +
56 " sp.tiefebis IS NOT NULL AND " + // TODO: Test if char diameter ist null. 56 " sp.tiefebis IS NOT NULL AND " + // TODO: Test if char diameter ist null.
57 " st.km BETWEEN :from - 0.001 AND :to + 0.001 AND " + 57 " st.km BETWEEN :from - 0.001 AND :to + 0.001 AND " +
58 " st.datum BETWEEN :start AND :end"; 58 " st.datum BETWEEN :start AND :end " +
59 "ORDER BY st.km";
59 60
60 private static final String SQL_BEDLOAD_MEASUREMENT = 61 private static final String SQL_BEDLOAD_MEASUREMENT =
61 "SELECT m.km as km," + 62 "SELECT m.km as km," +
62 " m.datum as datum," + 63 " m.datum as datum," +
63 " m.d10 as d10," + 64 " m.d10 as d10," +
80 " JOIN gewaesser gw ON gw.gewaesserid = sn.gewaesserid " + 81 " JOIN gewaesser gw ON gw.gewaesserid = sn.gewaesserid " +
81 "WHERE gw.name = :name AND " + 82 "WHERE gw.name = :name AND " +
82 " m.km IS NOT NULL AND " + 83 " m.km IS NOT NULL AND " +
83 " m.d10 IS NOT NULL AND" + //TODO: Add all other char. diameter. 84 " m.d10 IS NOT NULL AND" + //TODO: Add all other char. diameter.
84 " m.km BETWEEN :from - 0.001 AND :to + 0.001 AND" + 85 " m.km BETWEEN :from - 0.001 AND :to + 0.001 AND" +
85 " m.datum BETWEEN :start AND :end"; 86 " m.datum BETWEEN :start AND :end " +
87 "ORDER BY m.km";
86 88
87 public static final class QualityMeasurementResultTransformer 89 public static final class QualityMeasurementResultTransformer
88 extends BasicTransformerAdapter { 90 extends BasicTransformerAdapter {
89 91
90 public static QualityMeasurementResultTransformer INSTANCE = new QualityMeasurementResultTransformer(); 92 public static QualityMeasurementResultTransformer INSTANCE = new QualityMeasurementResultTransformer();
http://dive4elements.wald.intevation.org