@Override public <T extends Enum<T>> Path<T> createEnumPath( Class<T> type, PathMetadata<?> metadata) { return new EnumPath<T>(type, metadata); }
/** * @param <A> * @param path * @return */ @SuppressWarnings("unchecked") public <A extends Enum<A>> EnumPath<A> get(EnumPath<A> path) { EnumPath<A> newPath = getEnum(toString(path), (Class<A>)path.getType()); return addMetadataOf(newPath, path); }
private List<MenuEntity> findMenuByType(MenuTypeEnum typeEnum) { QMenuEntity entity = QMenuEntity.menuEntity; BooleanExpression ex = entity.status.eq(StatusEnum.STATUS_VALID); if(typeEnum!=null){ ex = ex.and(entity.type.eq(typeEnum)); } JPAQuery query = new JPAQuery(entityManager); List<MenuEntity> list = query.from(entity) .where( ex ) .list(entity); return list; }
public List<MTemplateEntity> findCustomTemplates(MObjectEntity belongMObject, MTemplateTypeEnum templateType, Boolean isSystem) { QMTemplateEntity obj = QMTemplateEntity.mTemplateEntity; JPAQuery query = new JPAQuery(entityManager); List<MTemplateEntity> templateList = query.from(obj) .where(obj.isSystem.eq(isSystem) .and(obj.belongMObject.eq(belongMObject)) .and(obj.templateType.eq(templateType)) ) .orderBy(obj.isSystem.desc()) .orderBy(obj.templateType.asc()) .orderBy(obj.sort.asc()) .list(obj); return templateList; }
public List<MTemplateEntity> findTemplateAll(MObjectEntity belongMObject) { QMTemplateEntity obj = QMTemplateEntity.mTemplateEntity; JPAQuery query = new JPAQuery(entityManager); List<MTemplateEntity> templateList = query.from(obj) .where(obj.belongMObject.eq(belongMObject) ) .orderBy(obj.isSystem.desc()) .orderBy(obj.templateType.asc()) .orderBy(obj.sort.asc()) .list(obj); return templateList; } }
@Test @Ignore // isn't a valid JPQL query public void Subquery_UniqueResult() { QCat cat2 = new QCat("cat2"); BooleanExpression exists = new JPASubQuery().from(cat2).where(cat2.eyecolor.isNotNull()).exists(); assertNotNull(query().from(cat) .where(cat.breed.eq(0).not()) .singleResult(new QCatSummary(cat.breed.count(), exists))); }
@Test @NoBatooJPA public void Any_In3() { QEmployee employee = QEmployee.employee; assertFalse(query().from(employee).where( employee.jobFunctions.any().in(JobFunction.CODER, JobFunction.CONSULTANT)) .list(employee).isEmpty()); }
@Override public List<MirrorPropertyEntity> findByTypeEnumAndIsEnable(MTypeEnum typeEnum, boolean isEnable) { JPAQuery query = new JPAQuery(entityManager); QMirrorPropertyEntity mirrorProperty = new QMirrorPropertyEntity("mpro"); List<MirrorPropertyEntity> list = query.from(mirrorProperty) .where(mirrorProperty.metaProperty.typeEnum.eq(typeEnum) .and(mirrorProperty.metaProperty.isEnable.eq(isEnable)) ) .list(mirrorProperty); return list; }
@Test public void order() { session.save(new Note(NoteType.A)); session.save(new Note(NoteType.B)); session.flush(); assertEquals( Arrays.asList(null, NoteType.A, NoteType.B, NoteType.TYPE1), session.from($(n)).orderBy($(n.getType()).asc()).list($(n.getType()))); }
private List<MenuEntity> findUserMenuByType(MenuTypeEnum typeEnum, List<RoleEntity> roleList) { QUrlResourcesEntity entity = QUrlResourcesEntity.urlResourcesEntity; BooleanExpression ex = entity.belongRole.isNotNull(); if(roleList != null) { ex = entity.belongRole.in(roleList); } if(typeEnum!=null){ ex = ex.and(entity.menu.type.eq(typeEnum)); } JPAQuery query = new JPAQuery(entityManager); List<UrlResourcesEntity> list = query.from(entity) .where( ex ) .list(entity); List<MenuEntity> menuList = new ArrayList<>(); for (UrlResourcesEntity urlResourcesEntity : list) { if(typeEnum==null){ menuList.add(urlResourcesEntity.getMenu()); }else if (urlResourcesEntity.getMenu().getType() == typeEnum) { menuList.add(urlResourcesEntity.getMenu()); } } return menuList; }
/** * @param <A> * @param property * @param type * @return */ protected <A extends Enum<A>> EnumPath<A> createEnum(String property, Class<A> type) { return add(new EnumPath<A>(type, forProperty(property))); }
@Test public void DocoExamples910_2() throws Exception { query().from(cat) .groupBy(cat.color) .having(cat.color.in(Color.TABBY, Color.BLACK)) .select(cat.color, cat.weight.sum(), cat.count()).parse(); }
@Override public List<MirrorPropertyEntity> findByBelongMObjectAndControllerTypeAndIsEnable(MObjectEntity belongMObject, MControllerTypeEnum controllerTypeEnum, boolean isEnable) { JPAQuery query = new JPAQuery(entityManager); QMirrorPropertyEntity mirrorProperty = new QMirrorPropertyEntity("mpro"); List<MirrorPropertyEntity> list = query.from(mirrorProperty) .where(mirrorProperty.rootMObject.eq(belongMObject) .and(mirrorProperty.belongMObject.eq(belongMObject)) .and(mirrorProperty.controllerType.eq(controllerTypeEnum)) ) .list(mirrorProperty); return list; }
@Test public void List_ElementCollection_Of_Enum() { QEmployee employee = QEmployee.employee; //QJobFunction jobFunction = QJobFunction.jobFunction; EnumPath<JobFunction> jobFunction = new EnumPath<JobFunction>(JobFunction.class, "jf"); List<JobFunction> jobFunctions = query().from(employee) .innerJoin(employee.jobFunctions, jobFunction).list(jobFunction); assertEquals(4, jobFunctions.size()); }
@Test public void Simple_BooleanOperation_ElementCollection() { QEmployee employee = QEmployee.employee; Predicate predicate = employee.jobFunctions.any().eq(JobFunction.CODER); assertMatches("exists \\(select 1\n" + "from Employee employee.*\n" + " inner join employee.*.jobFunctions as employee_jobFunctions.*\n" + "where employee.* = employee and employee_jobFunctions.* = \\?1\\)", serialize(predicate)); }