PatientSearchAction.java

package edu.ualberta.med.biobank.common.action.patient;

import java.text.MessageFormat;
import java.util.List;

import org.hibernate.Query;

import edu.ualberta.med.biobank.common.action.Action;
import edu.ualberta.med.biobank.common.action.ActionContext;
import edu.ualberta.med.biobank.common.action.ActionResult;
import edu.ualberta.med.biobank.common.action.exception.ActionException;
import edu.ualberta.med.biobank.common.action.patient.PatientSearchAction.SearchedPatientInfo;
import edu.ualberta.med.biobank.common.peer.PatientPeer;
import edu.ualberta.med.biobank.common.permission.patient.PatientReadPermission;
import edu.ualberta.med.biobank.model.Patient;
import edu.ualberta.med.biobank.model.Study;

public class PatientSearchAction implements Action<SearchedPatientInfo> {
    private static final long serialVersionUID = 1L;

    // @formatter:off
    @SuppressWarnings("nls")
    private static final String PATIENT_INFO_QRY =
        " select p, study, count(cevents)"
            + " from " + Patient.class.getName() + " as p"
            + " LEFT JOIN p." + PatientPeer.STUDY.getName() + " as study"
            + " LEFT JOIN p."
            + PatientPeer.COLLECTION_EVENTS.getName() + " as cevents"
            + " where {0} GROUP BY p";
    @SuppressWarnings("nls")
    private static final String WHERE_FOR_PNUMBER = "p."
        + PatientPeer.PNUMBER.getName() + "=?";
    @SuppressWarnings("nls")
    private static final String WHERE_FOR_ID = "p." + PatientPeer.ID.getName()
        + "=?";
    // @formatter:on

    private String pnumber;
    private Integer patientId;

    public static class SearchedPatientInfo implements ActionResult {
        private static final long serialVersionUID = 1L;
        public Patient patient;
        public Study study;
        public Long ceventsCount;
    }

    public PatientSearchAction(String pnumber) {
        this.pnumber = pnumber;
    }

    public PatientSearchAction(Integer id) {
        this.patientId = id;
    }

    @Override
    public boolean isAllowed(ActionContext context) {
        return new PatientReadPermission(patientId).isAllowed(context);
    }

    @Override
    public SearchedPatientInfo run(ActionContext context)
        throws ActionException {
        String hql = MessageFormat.format(PATIENT_INFO_QRY,
            pnumber == null ? WHERE_FOR_ID : WHERE_FOR_PNUMBER);

        Query query = context.getSession().createQuery(hql);
        query.setParameter(0, pnumber == null ? patientId : pnumber);

        @SuppressWarnings("unchecked")
        List<Object[]> rows = query.list();
        if (rows.size() == 0) {
            return null;
        }
        if (rows.size() == 1) {
            SearchedPatientInfo pinfo = new SearchedPatientInfo();
            Object[] row = rows.get(0);
            pinfo.patient = (Patient) row[0];
            pinfo.study = (Study) row[1];
            pinfo.ceventsCount = (Long) row[2];
            return pinfo;
        }
        throw new ActionException(
            "More than one patient found with pnumber " + pnumber); //$NON-NLS-1$
    }

}