ApprovalFacade.java

package fi.codecrew.moya.facade;

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

import fi.codecrew.moya.beans.EventBeanLocal;
import fi.codecrew.moya.model.Approval;
import fi.codecrew.moya.model.Approval_;

@Stateless
@LocalBean
public class ApprovalFacade extends IntegerPkGenericFacade<Approval> {

	@EJB
	private EventBeanLocal eventbean;

	public ApprovalFacade() {
		super(Approval.class);
	}

	public Approval findOrCreate(String approvalName) {
		Approval ret = find(approvalName);
		if (ret == null)
		{
			ret = new Approval();
			ret.setEvent(eventbean.getCurrentEvent());
			ret.setName(approvalName);
			ret.setDescription("Automagically created");
			create(ret);
		}
		return ret;
	}

	public Approval find(String approvalName)
	{
		CriteriaBuilder cb = getEm().getCriteriaBuilder();
		CriteriaQuery<Approval> cq = cb.createQuery(Approval.class);
		Root<Approval> root = cq.from(Approval.class);

		cq.where(cb.equal(root.get(Approval_.event), eventbean.getCurrentEvent()),
				cb.equal(root.get(Approval_.name), approvalName)
				);

		return super.getSingleNullableResult(getEm().createQuery(cq));

	}
}