Mercurial > dive4elements > river
comparison artifacts/src/main/java/org/dive4elements/river/artifacts/model/minfo/QualityMeasurementFactory.java @ 7630:3da531976039
issue1043: Fetch 'dm'-values in QualityMeasurementFactory.
| author | Felix Wolfsteller <felix.wolfsteller@intevation.de> |
|---|---|
| date | Mon, 02 Dec 2013 14:43:43 +0100 |
| parents | dbaa31354b58 |
| children | e4606eae8ea5 |
comparison
equal
deleted
inserted
replaced
| 7629:1e509612445f | 7630:3da531976039 |
|---|---|
| 29 "SELECT st.km as km," + | 29 "SELECT st.km as km," + |
| 30 " st.datum as datum," + | 30 " st.datum as datum," + |
| 31 " sp.tiefevon as depth1," + | 31 " sp.tiefevon as depth1," + |
| 32 " sp.tiefebis as depth2," + | 32 " sp.tiefebis as depth2," + |
| 33 " sa.d10 as d10," + | 33 " sa.d10 as d10," + |
| 34 " sa.dm as dm," + | |
| 34 " sa.d16 as d16," + | 35 " sa.d16 as d16," + |
| 35 " sa.d20 as d20," + | 36 " sa.d20 as d20," + |
| 36 " sa.d25 as d25," + | 37 " sa.d25 as d25," + |
| 37 " sa.d30 as d30," + | 38 " sa.d30 as d30," + |
| 38 " sa.d40 as d40," + | 39 " sa.d40 as d40," + |
| 59 "ORDER BY st.km"; | 60 "ORDER BY st.km"; |
| 60 | 61 |
| 61 private static final String SQL_BEDLOAD_MEASUREMENT = | 62 private static final String SQL_BEDLOAD_MEASUREMENT = |
| 62 "SELECT m.km as km," + | 63 "SELECT m.km as km," + |
| 63 " m.datum as datum," + | 64 " m.datum as datum," + |
| 65 " m.dm as dm," + | |
| 64 " m.d10 as d10," + | 66 " m.d10 as d10," + |
| 65 " m.d16 as d16," + | 67 " m.d16 as d16," + |
| 66 " m.d20 as d20," + | 68 " m.d20 as d20," + |
| 67 " m.d25 as d25," + | 69 " m.d25 as d25," + |
| 68 " m.d30 as d30," + | 70 " m.d30 as d30," + |
| 141 String statement | 143 String statement |
| 142 ) { | 144 ) { |
| 143 SQLQuery query = session.createSQLQuery(statement) | 145 SQLQuery query = session.createSQLQuery(statement) |
| 144 .addScalar("km", StandardBasicTypes.DOUBLE) | 146 .addScalar("km", StandardBasicTypes.DOUBLE) |
| 145 .addScalar("datum", StandardBasicTypes.DATE) | 147 .addScalar("datum", StandardBasicTypes.DATE) |
| 148 .addScalar("dm", StandardBasicTypes.DOUBLE) | |
| 146 .addScalar("d10", StandardBasicTypes.DOUBLE) | 149 .addScalar("d10", StandardBasicTypes.DOUBLE) |
| 147 .addScalar("d16", StandardBasicTypes.DOUBLE) | 150 .addScalar("d16", StandardBasicTypes.DOUBLE) |
| 148 .addScalar("d20", StandardBasicTypes.DOUBLE) | 151 .addScalar("d20", StandardBasicTypes.DOUBLE) |
| 149 .addScalar("d25", StandardBasicTypes.DOUBLE) | 152 .addScalar("d25", StandardBasicTypes.DOUBLE) |
| 150 .addScalar("d30", StandardBasicTypes.DOUBLE) | 153 .addScalar("d30", StandardBasicTypes.DOUBLE) |