/** * Find multiple objects. * * @deprecated use {@link Queries#named} findAll(EntityManager, String, Object[]) */ @Deprecated public static <A> List<A> findAll(EntityManager em, final String queryName, final Tuple<String, ?>... params) { return createNamedQuery(em, queryName, params).getResultList(); }
/** * Run an update (UPDATE or DELETE) query and ensure that at least one row got affected. * * @deprecated use {@link Queries#named} #update(EntityManager, String, Object[]) */ @Deprecated public static boolean runUpdate(EntityManager em, String queryName, Tuple<String, ?>... params) { return createNamedQuery(em, queryName, params).executeUpdate() > 0; }
/** * Execute a <code>COUNT(x)</code> query. * * @deprecated use {@link Queries#named} count(EntityManager, String, Object[]) */ @Deprecated public static long runCountQuery(EntityManager em, String queryName, Tuple<String, ?>... params) { return ((Number) createNamedQuery(em, queryName, params).getSingleResult()).longValue(); }
/** * Find multiple objects with optional pagination. * * @deprecated use {@link Queries#named} findAll(EntityManager, String, Option, Option, Object[]) */ @Deprecated public static <A> List<A> findAll(EntityManager em, final String queryName, Option<Integer> offset, Option<Integer> limit, final Tuple<String, ?>... params) { final Query q = createNamedQuery(em, queryName, params); for (Integer x : offset) q.setFirstResult(x); for (Integer x : limit) q.setMaxResults(x); return q.getResultList(); }
/** * Run a query that should return the first result of it. * * @deprecated use {@link Queries#named} findFirst(EntityManager, String, Object[]) */ @Deprecated public static <A> Option<A> runFirstResultQuery(EntityManager em, String queryName, Tuple<String, ?>... params) { try { return some((A) createNamedQuery(em, queryName, params).setMaxResults(1).getSingleResult()); } catch (NoResultException e) { return none(); } catch (NonUniqueResultException e) { return none(); } }
/** * Find multiple objects. * * @param params * the query parameters * @param toA * map to the desired result object * @deprecated use {@link Queries#named} findAll(EntityManager, String, Object[]) instead */ @Deprecated public static <A, B> List<A> findAll(EntityManager em, final Function<B, A> toA, final String queryName, final Tuple<String, ?>... params) { return mlist((List<B>) createNamedQuery(em, queryName, params).getResultList()).map(toA).value(); }
/** * Run a query (SELECT) that should return a single result. * * @deprecated use {@link Queries#named} #findSingle(EntityManager, String, Object[]) */ @Deprecated public static <A> Option<A> runSingleResultQuery(EntityManager em, String queryName, Tuple<String, ?>... params) { try { return some((A) createNamedQuery(em, queryName, params).getSingleResult()); } catch (NoResultException e) { return none(); } catch (NonUniqueResultException e) { return none(); } }
/** * Find multiple objects with optional pagination. * * @param params * the query parameters * @param toA * map to the desired result object * @deprecated use {@link Queries#named} findAll(EntityManager, String, Option, Option, Object[]) instead */ @Deprecated public static <A, B> List<A> findAll(EntityManager em, final Function<B, A> toA, Option<Integer> offset, Option<Integer> limit, final String queryName, final Tuple<String, ?>... params) { final Query q = createNamedQuery(em, queryName, params); for (Integer x : offset) q.setFirstResult(x); for (Integer x : limit) q.setMaxResults(x); return mlist((List<B>) q.getResultList()).map(toA).value(); }