ApiApplicationInstanceFacade.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 fi.codecrew.moya.model.ApiApplication;
import fi.codecrew.moya.model.ApiApplicationInstance;
import fi.codecrew.moya.model.ApiApplicationInstance_;

@Stateless
@LocalBean
public class ApiApplicationInstanceFacade extends IntegerPkGenericFacade<ApiApplicationInstance> {

	public ApiApplicationInstanceFacade() {
		super(ApiApplicationInstance.class);

	}

	public ApiApplicationInstance findInstance(ApiApplication app, String userId) {
		CriteriaBuilder cb = getEm().getCriteriaBuilder();
		CriteriaQuery<ApiApplicationInstance> q = cb.createQuery(ApiApplicationInstance.class);
		Root<ApiApplicationInstance> root = q.from(ApiApplicationInstance.class);
		q.where(cb.equal(root.get(ApiApplicationInstance_.application), app),
				cb.equal(root.get(ApiApplicationInstance_.authname), userId));

		return super.getSingleNullableResult(getEm().createQuery(q));
	}
}