package de.intevation.flys.artifacts.model;

import de.intevation.flys.artifacts.model.FixingsOverview.Fixing;

public class FixingsColumnFactory
{
    public static final String CACHE_NAME = "fixing-columns";

    public static final String SQL_COLUMN_W =
        "SELECT wcv.position AS km, wcv.w AS w " +
        "FROM wst_column_values wcv " +
        "WHERE wst_column_id = :column_id " +
        "ORDER by wcv.position";

    public static final String SQL_COLUMN_Q =
        "SELECT wqr.q AS q, r.a AS a, r.b AS b " +
        "FROM wst_column_q_ranges wcqr " +
        "JOIN wst_q_ranges wqr ON wcqr.wst_q_range_id = wqr.id " +
        "JOIN ranges r         ON wqr.range_id        = r.id " +
        "WHERE wcqr.wst_column_id = :column_id ORDER by r.a";

    public static final FixingsColumnFactory INSTANCE =
        new FixingsColumnFactory();

    private FixingsColumnFactory() {
    }

    public FixingsColumn getColumnData(Fixing.Column column) {
        // TODO: Implement me!
        return null;
    }
}
// vim:set ts=4 sw=4 si et sta sts=4 fenc=utf8 :