ReaderEventFacade.java

package fi.insomnia.bortal.facade;

import java.util.List;

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

import fi.insomnia.bortal.model.Reader;
import fi.insomnia.bortal.model.ReaderEvent;
import fi.insomnia.bortal.model.ReaderEvent_;

@Stateless
@LocalBean
public class ReaderEventFacade extends IntegerPkGenericFacade<ReaderEvent> {

	public ReaderEventFacade() {
		super(ReaderEvent.class);
	}

	public List<ReaderEvent> findLastEvents(Reader reader, int count) {

		CriteriaBuilder cb = getEm().getCriteriaBuilder();
		CriteriaQuery<ReaderEvent> cq = cb.createQuery(ReaderEvent.class);
		Root<ReaderEvent> root = cq.from(ReaderEvent.class);

		cq.where(cb.equal(root.get(ReaderEvent_.reader), reader));
		cq.orderBy(cb.desc(root.get(ReaderEvent_.time)));

		TypedQuery<ReaderEvent> q = getEm().createQuery(cq);
		q.setMaxResults(count);
		return q.getResultList();
	}
}