ActionLogFacade.java

package fi.insomnia.bortal.facade;

import java.util.List;

import javax.ejb.LocalBean;
import javax.ejb.Stateless;
import javax.persistence.EntityManager;
import javax.persistence.PersistenceContext;
import javax.persistence.TypedQuery;
import javax.persistence.criteria.CriteriaBuilder;
import javax.persistence.criteria.CriteriaQuery;
import javax.persistence.criteria.Root;

import fi.insomnia.bortal.model.ActionLogMessage;
import fi.insomnia.bortal.model.ActionLogMessageResponse;
import fi.insomnia.bortal.model.ActionLogMessageResponse_;

@Stateless
@LocalBean
public class ActionLogFacade extends GenericFacade<Integer,ActionLogMessage> {

	@PersistenceContext
	private EntityManager em;

	public ActionLogFacade() {
		super(ActionLogMessage.class);
	}

	@Override
	protected EntityManager getEm() {
		return em;
	}

	public List<ActionLogMessage> getAllSortedByTimestamp() {
		CriteriaBuilder cb = getEm().getCriteriaBuilder();
		CriteriaQuery<ActionLogMessage> cq = cb.createQuery(ActionLogMessage.class);
		Root<ActionLogMessage> root = cq.from(ActionLogMessage.class);
		cq.orderBy(cb.desc(root.get("time")));
		
		TypedQuery<ActionLogMessage> tq = em.createQuery(cq);
		tq.setMaxResults(10);
		tq.setFirstResult(0);
		return tq.getResultList();
	}

	public void saveToActionLog(ActionLogMessage alm) {
		em.persist(alm);
		em.flush();
	}
	
	public List<ActionLogMessageResponse> getActionLogMessageResponses(ActionLogMessage alm) {
		CriteriaBuilder cb = getEm().getCriteriaBuilder();
		CriteriaQuery<ActionLogMessageResponse> cq = cb.createQuery(ActionLogMessageResponse.class);
		
		Root<ActionLogMessageResponse> root = cq.from(ActionLogMessageResponse.class);
		cq.where(cb.equal(root.get(ActionLogMessageResponse_.actionLogMessage), alm));
		cq.orderBy(cb.asc(root.get("time")));
		
		TypedQuery<ActionLogMessageResponse> tq = em.createQuery(cq);
		return tq.getResultList();
	}

	public void saveActionLogResponse(ActionLogMessageResponse almr) {
		em.persist(almr);
		em.flush();
	}
}