Mercurial > dive4elements > river
comparison flys-artifacts/src/main/java/de/intevation/flys/artifacts/model/WstValueTable.java @ 327:e09634fbf6bc
Moved the query complexity of creating a w/q value table into view
'wst_value_table' and used this instead.
flys-artifacts/trunk@1724 c6561f87-3c4e-4783-a992-168aeb5c3f6f
| author | Sascha L. Teichmann <sascha.teichmann@intevation.de> |
|---|---|
| date | Mon, 18 Apr 2011 16:01:23 +0000 |
| parents | 07eba6d3b4a5 |
| children | 64cfbd631f29 |
comparison
equal
deleted
inserted
replaced
| 326:07eba6d3b4a5 | 327:e09634fbf6bc |
|---|---|
| 24 implements Serializable | 24 implements Serializable |
| 25 { | 25 { |
| 26 | 26 |
| 27 // TODO: put this into a property file | 27 // TODO: put this into a property file |
| 28 public static final String SQL_POS_WQ = | 28 public static final String SQL_POS_WQ = |
| 29 "SELECT wcv.position AS position," + | 29 "SELECT position, w, q, column_pos" + |
| 30 " w," + | 30 " FROM wst_value_table" + |
| 31 " (SELECT q" + | 31 " WHERE wst_id = :wst_id"; |
| 32 " FROM wst_column_q_ranges wcqr" + | |
| 33 " JOIN wst_q_ranges wqr" + | |
| 34 " ON wcqr.wst_q_range_id = wqr.id" + | |
| 35 " JOIN ranges r" + | |
| 36 " ON r.id = wqr.range_id" + | |
| 37 " WHERE wcqr.wst_column_id = wc.id" + | |
| 38 " AND wcv.position BETWEEN r.a AND r.b) AS q," + | |
| 39 " wc.position AS column_pos " + | |
| 40 "FROM wst_column_values wcv" + | |
| 41 " JOIN wst_columns wc" + | |
| 42 " ON wcv.wst_column_id = wc.id" + | |
| 43 " JOIN wsts w" + | |
| 44 " ON wc.wst_id = w.id " + | |
| 45 "WHERE w.id = :wst_id" + | |
| 46 "ORDER BY wcv.position ASC," + | |
| 47 " wc.position DESC"; | |
| 48 | 32 |
| 49 public static class Column | 33 public static class Column |
| 50 implements Serializable | 34 implements Serializable |
| 51 { | 35 { |
| 52 protected String name; | 36 protected String name; |