MismatchOrderBy.java

package gov.nysenate.openleg.dao.spotcheck;

/**
 * An Enumeration of spotcheck mismatch fields that can be ordered by.
 *
 * <p>Provides a consistent user friendly constant which maps to
 * columns in SqlSpotCheckReportQuery queries.
 *
 * <p>Sql queries in SqlSpotCheckReportQuery return mismatch contentKey's
 * as an hstore value. To order by keys of an hstore you have to access
 * the key like: <code>key->'print_no'</code>.
 */
public enum MismatchOrderBy {
    /** Common fields */
    STATUS("status"),
    MISMATCH_TYPE("type"),
    DATASOURCE("datasource"),
    REFERENCE_TYPE("reference_type"),
    REFERENCE_DATE("reference_active_date_time"),
    OBSERVED_DATE("observed_date_time"),
    ISSUE("issue_ids"),

    /** Bill fields */
    PRINT_NO("key->'print_no'"),

    /** Calendar Fields */
    CAL_NO("key->'calNo'"),
    CAL_TYPE("key->'type'"),

    /** Agenda Fields */
    AGENDA_NO("key->'agenda_no'"),
    AGENDA_COMMITTEE("key->'committee_name'")
    ;

    private String columnName;

    MismatchOrderBy(String colName) {
        this.columnName = colName;
    }

    public String getColumnName() {
        return columnName;
    }
}