MenuitemFacade.java

package fi.codecrew.moya.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 org.slf4j.Logger;
import org.slf4j.LoggerFactory;

import fi.codecrew.moya.model.Menuitem_;
import fi.codecrew.moya.model.Menuitem;

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

	private static final Logger logger = LoggerFactory
			.getLogger(MenuitemFacade.class);

	public MenuitemFacade() {

		super(Menuitem.class);
	}

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

		try {
			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;
		} catch (Throwable e) {
			logger.warn("Exception menussa" + url, e);
		}
		return null;
	}

}