Mercurial > dive4elements > river
comparison backend/src/main/java/org/dive4elements/river/model/sinfo/CollisionAggregateValue.java @ 9152:8d4e7e08dbc0
Fixed query semicolon
| author | mschaefer |
|---|---|
| date | Thu, 14 Jun 2018 16:58:35 +0200 |
| parents | 623b51bf03d7 |
| children | 38e8febd11b6 |
comparison
equal
deleted
inserted
replaced
| 9149:5be112fba832 | 9152:8d4e7e08dbc0 |
|---|---|
| 104 + " MIN(event_date) AS date_min, MAX(event_date) AS date_max," | 104 + " MIN(event_date) AS date_min, MAX(event_date) AS date_max," |
| 105 + " AVG(gauge_w) AS gauge_w" | 105 + " AVG(gauge_w) AS gauge_w" |
| 106 + " FROM collision_values v INNER JOIN collision s ON v.collision_id=s.id" | 106 + " FROM collision_values v INNER JOIN collision s ON v.collision_id=s.id" |
| 107 + " WHERE (collision_id=:parent)" | 107 + " WHERE (collision_id=:parent)" |
| 108 + " AND (station BETWEEN (:kmLo - 0.0001) AND (:kmHi + 0.0001))" | 108 + " AND (station BETWEEN (:kmLo - 0.0001) AND (:kmHi + 0.0001))" |
| 109 + " GROUP BY FLOOR(station+0.4999);").addScalar("station", StandardBasicTypes.DOUBLE) | 109 + " GROUP BY FLOOR(station+0.4999)").addScalar("station", StandardBasicTypes.DOUBLE) |
| 110 .addScalar("count", StandardBasicTypes.INTEGER).addScalar("date_min", StandardBasicTypes.DATE) | 110 .addScalar("count", StandardBasicTypes.INTEGER).addScalar("date_min", StandardBasicTypes.DATE) |
| 111 .addScalar("date_max", StandardBasicTypes.DATE).addScalar("gauge_w", StandardBasicTypes.DOUBLE); | 111 .addScalar("date_max", StandardBasicTypes.DATE).addScalar("gauge_w", StandardBasicTypes.DOUBLE); |
| 112 query.setInteger("parent", parent.getId()); | 112 query.setInteger("parent", parent.getId()); |
| 113 query.setDouble("kmLo", new Double(kmLo)); | 113 query.setDouble("kmLo", new Double(kmLo)); |
| 114 query.setDouble("kmHi", new Double(kmHi)); | 114 query.setDouble("kmHi", new Double(kmHi)); |