@Override public Bucket findByName(String bucketName) { try { return cbf.create(em, Bucket.class) .where("id").eq(bucketName) .where("deleted").eqExpression("false") .getSingleResult(); } catch (NoResultException ex) { return null; } }
private void prepareWhere(CriteriaBuilder<?> cb, E example, List<Property<Object>> properties, boolean useLikeOperator) { Iterator<Property<Object>> iterator = properties.iterator(); while (iterator.hasNext()) { Property<Object> property = iterator.next(); String name = property.getName(); if (useLikeOperator && property.getJavaClass().getName().equals(String.class.getName())) { cb.where(name).like(false).value(property.getValue(example)).noEscape(); } else { cb.where(name).eq(property.getValue(example)); } } }
@Override public <T> List<T> findByAccountIdAndStorageName(long accountId, String storageName, EntityViewSetting<T, ? extends QueryBuilder<T,?>> setting) { CriteriaBuilder<Bucket> cb = cbf.create(em, Bucket.class) .from(Bucket.class) .where("owner.id").eq(accountId) .where("deleted").eqExpression("false") .where("storage.id.name").eq(storageName); return evm.applySetting(setting, cb).getResultList(); }
@Override public Account findById(long accountId) { try { return cbf.create(em, Account.class) .where("id").eq(accountId) .getSingleResult(); } catch (NoResultException ex) { return null; } }
@Override public <T> List<T> findByAccountId(long accountId, EntityViewSetting<T, ? extends QueryBuilder<T,?>> setting) { CriteriaBuilder<Bucket> cb = cbf.create(em, Bucket.class) .where("owner.id").eq(accountId) .where("deleted").eqExpression("false"); return evm.applySetting(setting, cb).getResultList(); }
@Override public void removeById(UpdateContext context, Object id) { UpdateCriteriaBuilder<?> updateCb = context.getEntityViewManager().getCriteriaBuilderFactory().update(context.getEntityManager(), ownerEntityClass, "e"); for (Map.Entry<String, String> entry : removeByIdMappings.entrySet()) { updateCb.setExpression(entry.getKey(), "NULL"); updateCb.where(entry.getValue()).eq(id); } updateCb.executeUpdate(); }
@Override public <T> T findByName(String bucketName, EntityViewSetting<T, ? extends QueryBuilder<T,?>> setting) { try { CriteriaBuilder<Bucket> cb = cbf.create(em, Bucket.class) .where("id").eq(bucketName) .where("deleted").eqExpression("false"); return evm.applySetting(setting, cb).getSingleResult(); } catch (NoResultException ex) { return null; } }
@Override public <T> T findById(WeblinkId weblinkId, EntityViewSetting<T, ? extends QueryBuilder<T,?>> setting) { try { CriteriaBuilder<Weblink> cb = cbf.create(em, Weblink.class) .where("id").eq(weblinkId); return evm.applySetting(setting, cb).getSingleResult(); } catch (NoResultException ex) { return null; } }
@Override public <T> List<T> findAllByAccountId(Long accountId, EntityViewSetting<T, ? extends QueryBuilder<T, ?>> setting) { CriteriaBuilder<WeblinkSecurityGroup> cb = cbf.create(em, WeblinkSecurityGroup.class) .where("owner.id").eq(accountId); return evm.applySetting(setting, cb).getResultList(); }
@Override public V findBy(PK pk) { CriteriaBuilder<E> cb = createCriteriaBuilder(); List<V> result = context.getEntityViewManager().applySetting( createSetting(), cb.where(idAttribute()).eq(pk) ).getResultList(); return result.isEmpty() ? null : result.get(0); }
@Override public <T> List<T> findAllByWeblinkGroup(String weblinkGroupId, EntityViewSetting<T, ? extends QueryBuilder<T, ?>> setting) { CriteriaBuilder<Weblink> cb = cbf.create(em, Weblink.class) .where("id.weblinkGroupId").eq(weblinkGroupId); return evm.applySetting(setting, cb).getResultList(); }
@Override public <T> List<T> findByAccountId(long accountId, EntityViewSetting<T, ? extends QueryBuilder<T,?>> setting) { CriteriaBuilder<WeblinkGroup> cb = cbf.create(em, WeblinkGroup.class) .where("owner.id").eq(accountId); return evm.applySetting(setting, cb).getResultList(); }
public V findOne(ID id) { Assert.notNull(id, ID_MUST_NOT_BE_NULL); CriteriaBuilder<?> cb = cbf.create(entityManager, getDomainClass()) .where(getIdAttribute()).eq(id); TypedQuery<V> findOneQuery = evm.applySetting(setting, cb).getQuery(); applyQueryHints(findOneQuery); return findOneQuery.getSingleResult(); }
@Override public <T> T findByName(String weblinkGroupName, EntityViewSetting<T, ? extends QueryBuilder<T,?>> setting) { try { CriteriaBuilder<WeblinkGroup> cb = cbf.create(em, WeblinkGroup.class) .where("id").eq(weblinkGroupName); return evm.applySetting(setting, cb).getSingleResult(); } catch (NoResultException ex) { return null; } }
@Override public boolean exists(ID id) { Assert.notNull(id, ID_MUST_NOT_BE_NULL); TypedQuery<Long> existsQuery = cbf.create(entityManager, Long.class) .from(getDomainClass()) .select("COUNT(*)") .where(getIdAttribute()).eq(id) .getQuery(); applyRepositoryMethodMetadata(existsQuery); return existsQuery.getSingleResult() > 0; }
public <T> T getCatByName(String name, EntityViewSetting<T, CriteriaBuilder<T>> setting) { CriteriaBuilder<Cat> cb = cbf.create(emHolder.getEntityManager(), Cat.class) .where("name").eq(name); return evm.applySetting(setting, cb).getSingleResult(); }
public <T> T getCatByName(String name, EntityViewSetting<T, CriteriaBuilder<T>> setting) { CriteriaBuilder<Cat> cb = cbf.create(emHolder.getEntityManager(), Cat.class) .where("name").eq(name); return evm.applySetting(setting, cb).getSingleResult(); }
public <T> T getCatByName(String name, EntityViewSetting<T, CriteriaBuilder<T>> setting) { CriteriaBuilder<Cat> cb = cbf.create(emHolder.getEntityManager(), Cat.class) .where("name").eq(name); return evm.applySetting(setting, cb).getSingleResult(); }
public <T> T getCatByName(String name, EntityViewSetting<T, CriteriaBuilder<T>> setting) { CriteriaBuilder<Cat> cb = cbf.create(emHolder.getEntityManager(), Cat.class) .where("name").eq(name); return evm.applySetting(setting, cb).getSingleResult(); }