List of usage examples for org.springframework.data.mongodb.core.query Criteria where
public static Criteria where(String key)
From source file:app.data.local.CollectionBindingRepositoryImpl.java
@Nullable @Override//from www. j a va 2s.c om public List<CollectionBinding> findByUid(String uid, @Nullable Pageable pageable) { Query query = new Query(); query.addCriteria(Criteria.where("favors").elemMatch(Criteria.where("uid").is(uid))).with(pageable); return mMongoTemplate.find(query, CollectionBinding.class); }
From source file:org.cbioportal.session_service.domain.internal.SessionRepositoryImpl.java
public List<Session> findBySourceAndTypeAndQuery(String source, String type, String field, String value) { return this.mongoTemplate.find( new Query(Criteria.where("source").is(source).and("type").is(type).and(field).is(value)), Session.class, type); }
From source file:uk.gov.nationalarchives.discovery.taxonomy.common.service.impl.IAViewServiceImpl.java
public List<MongoInformationAssetView> findUntaggedDocumentsBySeriesMongo(String seriesIaid, Integer limit, Integer offset) {//from w w w . ja v a 2s . c o m Query query = Query.query(Criteria.where("series").is(seriesIaid).and("categories").size(0)); query.limit(limit); query.skip(offset); query.with(new Sort(Sort.Direction.ASC, "_id")); return mongoTemplate.find(query, MongoInformationAssetView.class); }
From source file:com.epam.ta.reportportal.database.search.QueryBuilder.java
public static Function<FilterCondition, Criteria> filterConverter(CriteriaMap<?> map) { return filterCondition -> { Optional<CriteriaHolder> criteriaHolder = map .getCriteriaHolderUnchecked(filterCondition.getSearchCriteria()); BusinessRule.expect(criteriaHolder, Preconditions.IS_PRESENT) .verify(ErrorType.INCORRECT_FILTER_PARAMETERS, Suppliers.formattedSupplier( "Filter parameter {} is not defined", filterCondition.getSearchCriteria())); Criteria searchCriteria;/*ww w.j ava 2s . c om*/ if (criteriaHolder.get().isReference()) { searchCriteria = Criteria.where(criteriaHolder.get().getQueryCriteria().concat(REFERENCE_POSTFIX)); } else { searchCriteria = Criteria.where(criteriaHolder.get().getQueryCriteria()); } /* Does FilterCondition contains negative=true? */ if (filterCondition.isNegative()) { searchCriteria = searchCriteria.not(); } filterCondition.getCondition().addCondition(searchCriteria, filterCondition, criteriaHolder.get()); return searchCriteria; }; }
From source file:com.tlantic.integration.authentication.service.security.TokenStoreService.java
@Override public OAuth2RefreshToken readRefreshToken(String accessToken) { Query query = new Query(); query.addCriteria(Criteria.where("tokenId").is(accessToken)); OAuth2AuthenticationRefreshToken token = mongoTemplate.findOne(query, OAuth2AuthenticationRefreshToken.class, "oauth2_refresh_token"); return token.getoAuth2RefreshToken(); }
From source file:com.epam.ta.reportportal.database.dao.ProjectRepositoryCustomImpl.java
@Override public synchronized void clearExternalSystems(String projectId) { Query query = Query.query(Criteria.where(PROJECT_ID).is(projectId)); Project first = mongoTemplate.findOne(query, Project.class); first.getConfiguration().setExternalSystem(Collections.emptyList()); mongoTemplate.save(first);//w w w . ja v a2s. com }
From source file:quanlyhocvu.api.mongodb.DAO.AuthorityDAO.java
/** * generate password and user by class default: user = MaObj, pass = 'admin' * * @param cls// w w w .j a v a 2s. com */ public void generateUserByType(Class cls) { if (cls == GiaoVienDTO.class) { List<GiaoVienDTO> giaoviens = mongoOperation.findAll(GiaoVienDTO.class); if (giaoviens != null) { for (GiaoVienDTO giaovien : giaoviens) { if (giaovien.getmaGiaoVien() != null) { UserDTO user = new UserDTO(giaovien.getmaGiaoVien(), MD5.getMD5("admin"), giaovien.getid()); user.getRoles() .add(mongoOperation.findOne( Query.query(Criteria.where("rolename").is(Authorities.TEACHER.toString())), RoleDTO.class)); try { this.insertUser(user); } catch (Exception ex) { } } } } } else if (cls == StaffDTO.class) { List<StaffDTO> staffs = mongoOperation.findAll(StaffDTO.class); if (staffs != null) { for (StaffDTO staff : staffs) { if (staff.getManhanvien() != null) { UserDTO user = new UserDTO(staff.getManhanvien(), MD5.getMD5("admin"), staff.getid()); user.getRoles() .add(mongoOperation.findOne( Query.query(Criteria.where("rolename").is(Authorities.STAFF.toString())), RoleDTO.class)); try { this.insertUser(user); } catch (Exception ex) { } } } } } else if (cls == HocSinhDTO.class) { List<HocSinhDTO> hocsinhs = mongoOperation.findAll(HocSinhDTO.class); if (hocsinhs != null) { for (HocSinhDTO hocsinh : hocsinhs) { if (hocsinh.getmaHocSinh() != null) { UserDTO user = new UserDTO(hocsinh.getmaHocSinh(), MD5.getMD5("admin"), hocsinh.getid()); user.getRoles() .add(mongoOperation.findOne( Query.query(Criteria.where("rolename").is(Authorities.STUDENT.toString())), RoleDTO.class)); try { this.insertUser(user); } catch (Exception ex) { } } } } } }
From source file:com.comcast.video.dawg.controller.house.filter.FieldCondition.java
/** * {@inheritDoc}/*from w w w. j a v a 2s .c om*/ */ @Override public Criteria toCriteria(boolean negate) { boolean notToUse = negate ? !not : not; Criteria crit = Criteria.where("data." + field); switch (this.op) { case equals: return notToUse ? crit.ne(value) : crit.is(value); case contains: crit = notToUse ? crit.not() : crit; if (array) { return crit.in(value); } else { return crit.regex(".*" + value + ".*"); } case matches: crit = notToUse ? crit.not() : crit; return crit.regex(value); default: return null; } }
From source file:st.malike.service.mongo.DemographicSummaryService.java
public DemographicSummary getDemographicSummaryHistoryByEventAndDateForMin(String event, String date) { try {//from ww w . j a va 2 s . c o m Date startDate = new SimpleDateFormat("yyyy-MM-dd 00:00:00").parse(date); Date endDate = new DateTime(startDate).plusDays(1).toDate(); Query query = new Query(); query.addCriteria(Criteria.where("event").is(event)); query.addCriteria(Criteria.where("dateCreated").gte(startDate).lt(endDate)); return mongoTemplate.findOne(query, DemographicSummary.class, "demographic_summary"); } catch (ParseException ex) { Logger.getLogger(DemographicSummaryService.class.getName()).log(Level.SEVERE, null, ex); } return null; }
From source file:tv.arte.resteventapi.core.querying.mongo.db.AbstractBaseMongoDBQueryBuilder.java
/** * Build a Mongo query based on a field name, {@link QueryOp} and a given value suited for the * provided operation //from w w w. j a v a2s. co m * * @param fieldName The field name (Should never be <code>null</code>) * @param queryOpParamValue A query op / value param * @return A Mongo query based on a field name, {@link QueryOp} and a given value suited for the * provided operation */ protected Criteria buildSimpleCriteria(String fieldName, QueryOpParamValue<?> queryOpParamValue) { Criteria criteria = null; QueryOp paramQueryOp = queryOpParamValue.getQueryOp(); Object paramValue = queryOpParamValue.getValue(); if (paramQueryOp == null) { if (paramValue == null) { criteria = Criteria.where(fieldName).exists(false); } else { criteria = Criteria.where(fieldName).is(paramValue); } } else { switch (paramQueryOp) { case GT: criteria = Criteria.where(fieldName).gt(paramValue); break; case GTE: criteria = Criteria.where(fieldName).gte(paramValue); break; case LT: criteria = Criteria.where(fieldName).lt(paramValue); break; case LTE: criteria = Criteria.where(fieldName).lte(paramValue); break; case NE: criteria = Criteria.where(fieldName).ne(paramValue); break; case IN: criteria = Criteria.where(fieldName).in((Collection<?>) paramValue); break; case NIN: criteria = Criteria.where(fieldName).nin((Collection<?>) paramValue); break; case ALL: criteria = Criteria.where(fieldName).all((Collection<?>) paramValue); break; case ONLY: criteria = new Criteria().andOperator(Criteria.where(fieldName).all((Collection<?>) paramValue), Criteria.where(fieldName).size(((Collection<?>) paramValue).size())); break; default: criteria = new Criteria(); break; } } return criteria; }