MenuitemFacade.java

package fi.insomnia.bortal.facade;

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.insomnia.bortal.model.Menuitem;
import fi.insomnia.bortal.model.Menuitem_;

@Stateless
@LocalBean
public class MenuitemFacade extends IntegerPkGenericFacade<Menuitem> {

	public MenuitemFacade() {

		super(Menuitem.class);
	}

	public Menuitem findOrCreate(String url) {
		if (url == null || url.isEmpty()) {
			return null;
		}

		CriteriaBuilder cb = getEm().getCriteriaBuilder();
		CriteriaQuery<Menuitem> cq = cb.createQuery(Menuitem.class);
		Root<Menuitem> root = cq.from(Menuitem.class);
		cq.where(cb.equal(root.get(Menuitem_.url), url));
		Menuitem ret = super.getSingleNullableResult(getEm().createQuery(cq));
		if (ret == null) {
			ret = new Menuitem();
			ret.setUrl(url);
			create(ret);
		}
		return ret;
	}

}