Mercurial > dive4elements > river
comparison flys-artifacts/src/main/java/de/intevation/flys/artifacts/model/FixingsColumnFactory.java @ 2615:b0597a63fe70
More code for the fixings km chart service.
flys-artifacts/trunk@4199 c6561f87-3c4e-4783-a992-168aeb5c3f6f
| author | Sascha L. Teichmann <sascha.teichmann@intevation.de> |
|---|---|
| date | Wed, 04 Apr 2012 18:30:44 +0000 |
| parents | |
| children | 6ed24efc80de |
comparison
equal
deleted
inserted
replaced
| 2614:036e234c2385 | 2615:b0597a63fe70 |
|---|---|
| 1 package de.intevation.flys.artifacts.model; | |
| 2 | |
| 3 import de.intevation.flys.artifacts.model.FixingsOverview.Fixing; | |
| 4 | |
| 5 public class FixingsColumnFactory | |
| 6 { | |
| 7 public static final String CACHE_NAME = "fixing-columns"; | |
| 8 | |
| 9 public static final String SQL_COLUMN_W = | |
| 10 "SELECT wcv.position AS km, wcv.w AS w " + | |
| 11 "FROM wst_column_values wcv " + | |
| 12 "WHERE wst_column_id = :column_id " + | |
| 13 "ORDER by wcv.position"; | |
| 14 | |
| 15 public static final String SQL_COLUMN_Q = | |
| 16 "SELECT wqr.q AS q, r.a AS a, r.b AS b " + | |
| 17 "FROM wst_column_q_ranges wcqr " + | |
| 18 "JOIN wst_q_ranges wqr ON wcqr.wst_q_range_id = wqr.id " + | |
| 19 "JOIN ranges r ON wqr.range_id = r.id " + | |
| 20 "WHERE wcqr.wst_column_id = :column_id ORDER by r.a"; | |
| 21 | |
| 22 public static final FixingsColumnFactory INSTANCE = | |
| 23 new FixingsColumnFactory(); | |
| 24 | |
| 25 private FixingsColumnFactory() { | |
| 26 } | |
| 27 | |
| 28 public FixingsColumn getColumnData(Fixing.Column column) { | |
| 29 // TODO: Implement me! | |
| 30 return null; | |
| 31 } | |
| 32 } | |
| 33 // vim:set ts=4 sw=4 si et sta sts=4 fenc=utf8 : |