List of usage examples for org.springframework.data.mongodb.core.query Query Query
public Query()
From source file:io.smalldata.ohmageomh.data.repository.MongoDataPointRepositoryImpl.java
private Query newQuery(DataPointSearchCriteria searchCriteria) { Query query = new Query(); query.addCriteria(where("header.user_id").is(searchCriteria.getUserId())); query.addCriteria(where("header.schema_id.namespace").is(searchCriteria.getSchemaNamespace())); query.addCriteria(where("header.schema_id.name").is(searchCriteria.getSchemaName())); query.addCriteria(where("header.schema_id.version.major").is(searchCriteria.getSchemaVersion().getMajor())); query.addCriteria(where("header.schema_id.version.minor").is(searchCriteria.getSchemaVersion().getMinor())); if (searchCriteria.getSchemaVersion().getQualifier().isPresent()) { query.addCriteria(where("header.schema_id.version.qualifier") .is(searchCriteria.getSchemaVersion().getQualifier().get())); } else {//w ww . j a v a 2s . co m query.addCriteria(where("header.schema_id.version.qualifier").exists(false)); } if (searchCriteria.getCreationTimestampRange().isPresent()) { addCreationTimestampCriteria(query, searchCriteria.getCreationTimestampRange().get()); } return query; }
From source file:org.oncoblocks.centromere.mongodb.CentromereMongoRepository.java
/** * {@link RepositoryOperations#count}// w ww . ja va 2s.c om */ public long count(Iterable<QueryCriteria> queryCriterias) { Criteria criteria = MongoQueryUtils.getQueryFromQueryCriteria(queryCriterias); Query query = new Query(); if (criteria != null) { query.addCriteria(criteria); } return mongoOperations.count(query, metadata.getJavaType()); }
From source file:com.comcast.video.dawg.service.park.MongoParkService.java
/** * {@inheritDoc}// ww w . j a va 2 s . c o m */ @Override public List<ChimpsToken> getSavedTokens() { return template.find(new Query(), ChimpsToken.class, ChimpsToken.class.getSimpleName()); }
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:st.malike.service.mongo.DemographicSummaryService.java
public DemographicSummary getDemographicSummaryHistoryByEventAndDateForMin(String event, String date) { try {//from w w w. j a v a 2 s .co 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:org.oncoblocks.centromere.mongodb.GenericMongoRepository.java
/** * {@link RepositoryOperations#findAll}// w w w.j a v a 2s . c o m */ public Page<T> findAll(Pageable pageable) { List<T> entities = mongoOperations.find(new Query().with(pageable), model); long count = count(); return new PageImpl<T>(entities, pageable, count); }
From source file:br.com.ezequieljuliano.argos.template.StandardDAO.java
public long countAll() { return getMongoOperations().count(new Query(), getDomainClass()); }
From source file:com.card.loop.xyz.dao.UserDAO.java
public boolean exists(String username, String password, String type) throws UnknownHostException { boolean ok = false; Query query = new Query(); query.addCriteria(where("username").is(username).and("password").is(password).and("userType").is(type)); ok = user.exists(query, User.class); return ok;// ww w . j a v a2s . com }
From source file:com.card.loop.xyz.dao.LearningObjectDAO.java
public List<LearningObject> searchLO(String title, String subject, Date fromDate, Date toDate, String orderBy) throws UnknownHostException { Query query = new Query(); if (title != null || !"".equals(title)) query.addCriteria(Criteria.where("title").regex(title)); else if (subject != null || !"".equals(subject)) query.addCriteria(Criteria.where("subject").regex(subject)); else if (fromDate != null && toDate != null) query.addCriteria(Criteria.where("uploadDate").gte(fromDate).lte(toDate)); else if (orderBy != null || !"".equals(orderBy)) { switch (orderBy) { case "uploadDate": query.with(new Sort(new Sort.Order(Sort.Direction.DESC, "uploadedDate"))); break; case "downloads": query.with(new Sort(new Sort.Order(Sort.Direction.DESC, "downloads"))); break; case "title": query.with(new Sort(new Sort.Order(Sort.Direction.DESC, "title"))); break; }/* www. j a v a2s . c om*/ } return mongoOps.find(query, LearningObject.class); }
From source file:app.data.local.CollectionBindingRepositoryImpl.java
@Nullable @Override/* w ww.j a v a 2 s . c o m*/ public List<CollectionBinding> findByTags(List<String> tags, @Nullable Pageable pageable) { Query query = new Query(); query.addCriteria(Criteria.where("tags").in(tags)).with(pageable); return mMongoTemplate.find(query, CollectionBinding.class); // // such as [{$project: {key:"$key", count: {$size: {$ifNull: ["$value",[]]}}}}, {$sort: {"count":1}}] // // FIXME: 2016/9/30 [block] waiting for spring-data-mongodb 1.10 release // // https://github.com/spring-projects/spring-data-mongodb/blob/eb1392cc1a0fcf25aa9e636863d36e6fee73e632/src/main/asciidoc/new-features.adoc // // due to $ifNull // List<AggregationOperation> operations = new ArrayList<>(); // operations.add(Aggregation.match(Criteria.where("tags").in(tags))); // // String op = "{ $project : { \"collectionId\" : \"$collectionId\" , \"favorsCount\" : { $size : { \"$ifNull\" : [\"$favors\", []]}}}}"; // // but the result will be modify to ...{ "$ifNull" : [ "$favors" , { }]}... // DBObject dbObject = BasicDBObject.parse(op); // operations.add(new CommonAggregationOperation(dbObject)); //// operations.add(Aggregation.project("collectionId") //// .and(ifNull("favors", new ArrayList<CollectionBinding.Data>())).size().as("favorsCount")); // //operations.add(Aggregation.sort(Sort.Direction.DESC, "favorsCount")); // if (pageable != null) { // operations.add(Aggregation.skip(pageable.getOffset())); // operations.add(Aggregation.limit(pageable.getPageSize())); // } // TypedAggregation<CollectionBinding> aggregation = Aggregation.newAggregation(CollectionBinding.class, operations); // logger.info(aggregation.toString()); //// Aggregation aggregation = Aggregation.newAggregation(operations); // AggregationResults<CollectionBindingTemp> results = // mMongoTemplate.aggregate(aggregation, CollectionBindingTemp.class); // List<CollectionBindingTemp> tempList = results.getMappedResults(); // // List<CollectionBinding> colBindings = new ArrayList<>(tempList.size()); // for (CollectionBindingTemp item : tempList) { // CollectionBinding colBinding = findByCollectionId(item.getCollectionId()); // // colBinding is non-null // colBindings.add(colBinding); // } // return colBindings; }