sascha@2615: package de.intevation.flys.artifacts.model;
sascha@2615: 
sascha@2615: import de.intevation.flys.artifacts.model.FixingsOverview.Fixing;
sascha@2615: 
sascha@2615: public class FixingsColumnFactory
sascha@2615: {
sascha@2615:     public static final String CACHE_NAME = "fixing-columns";
sascha@2615: 
sascha@2615:     public static final String SQL_COLUMN_W =
sascha@2615:         "SELECT wcv.position AS km, wcv.w AS w " +
sascha@2615:         "FROM wst_column_values wcv " +
sascha@2615:         "WHERE wst_column_id = :column_id " +
sascha@2615:         "ORDER by wcv.position";
sascha@2615: 
sascha@2615:     public static final String SQL_COLUMN_Q =
sascha@2615:         "SELECT wqr.q AS q, r.a AS a, r.b AS b " +
sascha@2615:         "FROM wst_column_q_ranges wcqr " +
sascha@2615:         "JOIN wst_q_ranges wqr ON wcqr.wst_q_range_id = wqr.id " +
sascha@2615:         "JOIN ranges r         ON wqr.range_id        = r.id " +
sascha@2615:         "WHERE wcqr.wst_column_id = :column_id ORDER by r.a";
sascha@2615: 
sascha@2615:     public static final FixingsColumnFactory INSTANCE =
sascha@2615:         new FixingsColumnFactory();
sascha@2615: 
sascha@2615:     private FixingsColumnFactory() {
sascha@2615:     }
sascha@2615: 
sascha@2615:     public FixingsColumn getColumnData(Fixing.Column column) {
sascha@2615:         // TODO: Implement me!
sascha@2615:         return null;
sascha@2615:     }
sascha@2615: }
sascha@2615: // vim:set ts=4 sw=4 si et sta sts=4 fenc=utf8 :