Refine search
@Override public void doRun() { LOG.debug("Starting alarm callbacks migration"); final DBObject selection = QueryBuilder.start("id").exists(true).get(); final DBObject modifications = new BasicDBObject("$unset", new BasicDBObject("id", "")); this.dbCollection.updateMulti(selection, modifications); LOG.debug("Done with alarm callbacks migration"); }
/** * Creates a new query with a document key * * @param key MongoDB document key * @return {@code this} */ public static QueryBuilder start(final String key) { return (new QueryBuilder()).put(key); }
@Override public List<Stream> loadAllWithConfiguredAlertConditions() { final DBObject query = QueryBuilder.start().and( QueryBuilder.start(StreamImpl.EMBEDDED_ALERT_CONDITIONS).exists(true).get(), QueryBuilder.start(StreamImpl.EMBEDDED_ALERT_CONDITIONS).not().size(0).get() ).get(); return loadAll(query); }
@Override public void grantToAllUsers(RealmModel realm, RoleModel role) { DBObject query = new QueryBuilder() .and("realmId").is(realm.getId()) .get(); DBObject update = new QueryBuilder() .and("$push").is(new BasicDBObject("roleIds", role.getId())) .get(); int count = getMongoStore().updateEntities(MongoUserEntity.class, query, update, invocationContext); }
private void loadConfigurationRecord() { DBObject q = new QueryBuilder().put("type").is(RecordType.configuration.name()).get(); DBObject configRecord = getMongeezCollection().findOne(q); if (configRecord == null) { if (getMongeezCollection().count() > 0L) { // We have pre-existing records, so don't assume that they support the latest features configRecord = new BasicDBObject() .append("type", RecordType.configuration.name()) .append("supportResourcePath", false); } else { configRecord = new BasicDBObject() .append("type", RecordType.configuration.name()) .append("supportResourcePath", true); } getMongeezCollection().insert(configRecord, WriteConcern.SAFE); } Object supportResourcePath = configRecord.get("supportResourcePath"); changeSetAttributes = new ArrayList<ChangeSetAttribute>(); changeSetAttributes.add(ChangeSetAttribute.file); changeSetAttributes.add(ChangeSetAttribute.changeId); changeSetAttributes.add(ChangeSetAttribute.author); if (Boolean.TRUE.equals(supportResourcePath)) { changeSetAttributes.add(ChangeSetAttribute.resourcePath); } }
if(config.maintain_following_collection){ coll = this.following; proj = new BasicDBObject(USER_ID_KEY, false).append(EDGE_PEER_KEY, true); fof_id_key = EDGE_PEER_KEY; fof_id_query = QueryBuilder.start(); fof_id_query = fof_id_query.put(EDGE_OWNER_KEY); fof_id_query = fof_id_query.in(friend_ids.toArray()); } else { proj = new BasicDBObject(USER_ID_KEY, false).append(EDGE_OWNER_KEY, true); fof_id_key = EDGE_OWNER_KEY; fof_id_query = QueryBuilder.start(); fof_id_query = fof_id_query.put(EDGE_PEER_KEY); fof_id_query = fof_id_query.in(friend_ids.toArray()); DBCursor fof_ids_cursor = coll.find(fof_id_query.get(), proj);
QueryBuilder query = getByKeyQuery(updateOp.key); BasicDBObject setUpdates = new BasicDBObject(); BasicDBObject incUpdates = new BasicDBObject(); BasicDBObject unsetUpdates = new BasicDBObject(); query.and(k).exists(op.value); DBObject oldNode = dbCollection.findAndModify(query.get(), null /*fields*/, null /*sort*/, false /*remove*/, update, false /*returnNew*/,
private void addTypeToUntypedRecords() { DBObject q = new QueryBuilder().put("type").exists(false).get(); BasicDBObject o = new BasicDBObject("$set", new BasicDBObject("type", RecordType.changeSetExecution.name())); getMongeezCollection().update(q, o, false, true, WriteConcern.SAFE); }
.start(SiteMemberData.FIELD_SITE_ID).exists(Boolean.TRUE); if (siteId != null) queryObjBuilder.and(SiteMemberData.FIELD_SITE_ID).is(siteId); queryObjBuilder.and(SiteMemberData.FIELD_CREATION_STATE) .is(state.toString()); queryObjBuilder.and(SiteMemberData.FIELD_USERNAME).is(username); queryObjBuilder.and(SiteMemberData.FIELD_ROLE).in(roles); BasicDBObject query = (BasicDBObject) queryObjBuilder.get(); // Need query.put(SiteData.FIELD_RANDOMIZER, new BasicDBObject("$gte", Integer.valueOf(random))); DBObject result = siteMembersCollection.findOne(query); if (result == null) result = siteMembersCollection.findOne(); query.put(SiteData.FIELD_RANDOMIZER, new BasicDBObject("$lt", random)); result = siteMembersCollection.findOne(query);
Pattern firstNamePattern = Pattern.compile("(?i:" + firstName + "$)"); Pattern lastNamePattern = Pattern.compile("(?i:^" + lastName + ")"); nameBuilder = new QueryBuilder().and( new QueryBuilder().put("firstName").regex(firstNamePattern).get(), new QueryBuilder().put("lastName").regex(lastNamePattern).get() ); } else { nameBuilder = new QueryBuilder().or( new QueryBuilder().put("firstName").regex(caseInsensitivePattern).get(), new QueryBuilder().put("lastName").regex(caseInsensitivePattern).get() ); QueryBuilder builder = new QueryBuilder().and( new QueryBuilder().and("realmId").is(realm.getId()).get(), new QueryBuilder().and("serviceAccountClientLink").is(null).get(), new QueryBuilder().or( new QueryBuilder().put("username").regex(caseInsensitivePattern).get(), new QueryBuilder().put("email").regex(caseInsensitivePattern).get(), nameBuilder.get() ).get() ); DBObject sort = new BasicDBObject("username", 1); List<MongoUserEntity> users = getMongoStore().loadEntities(MongoUserEntity.class, builder.get(), sort, firstResult, maxResults, invocationContext); return convertUserEntities(realm, users);
BasicDBObject pull = (BasicDBObject)visitor.getPullQuery().get(rowInfo.mergedTableName); if(this.queryMatch.keySet().isEmpty()) { queryMatch = QueryBuilder.start(rowInfo.getId(doc)).exists(true).get(); pull = new BasicDBObject(rowInfo.getId(doc), pull != null ? pull : new BasicDBObject()); LogManager.logInfo(LogConstants.CTX_CONNECTOR, "update - {\"$match\": {"+this.queryMatch+"}}"); //$NON-NLS-1$ //$NON-NLS-2$ LogManager.logInfo(LogConstants.CTX_CONNECTOR, "update - {\"$pull\": {"+pull+"}}"); //$NON-NLS-1$ //$NON-NLS-2$ WriteResult result = collection.update(this.queryMatch, new BasicDBObject("$pull", pull), false, true, //$NON-NLS-1$ WriteConcern.ACKNOWLEDGED); executionResults.add(result); LogManager.logDetail(LogConstants.CTX_CONNECTOR, "update - {\"$match\": {"+m+"}}"); //$NON-NLS-1$ //$NON-NLS-2$ LogManager.logDetail(LogConstants.CTX_CONNECTOR, "update - {\"$set\": {"+u+"}}"); //$NON-NLS-1$ //$NON-NLS-2$ WriteResult result = collection.update(m, new BasicDBObject("$set", u), false, true, WriteConcern.ACKNOWLEDGED); //$NON-NLS-1$ executionResults.add(result); queryMatch = QueryBuilder.start(rowInfo.getId(doc)).exists(true).get(); BasicDBObject u = new BasicDBObject(rowInfo.getId(doc), ""); //$NON-NLS-1$ LogManager.logInfo(LogConstants.CTX_CONNECTOR, "update - {\"$match\": {"+this.queryMatch+"}}"); //$NON-NLS-1$ //$NON-NLS-2$ LogManager.logInfo(LogConstants.CTX_CONNECTOR, "update - {\"$unset\": {"+u+"}}"); //$NON-NLS-1$ //$NON-NLS-2$ WriteResult result = collection.update(this.queryMatch, new BasicDBObject("$unset", u), false, true, WriteConcern.ACKNOWLEDGED); //$NON-NLS-1$ executionResults.add(result);
@Override public List<User> getFriendsOfFriendsQuery(final User user) { // Get the _ids of all the user's friends. List<String> friend_ids = getFriendIdsUsingQuery(user); if (friend_ids.size() == 0) // The user is not following anyone, will not have any friends of friends. return new ArrayList<User>(); Set<String> fof_ids = getFriendsOfUsersQuery(user, friend_ids); if (fof_ids.size() == 0) { // None of the friends were following anyone, no friends of friends. return new ArrayList<User>(); } // Get the actual users. QueryBuilder fof_users_query = new QueryBuilder(); fof_users_query = fof_users_query.put(USER_ID_KEY); fof_users_query = fof_users_query.in(fof_ids.toArray()); DBCursor users_cursor = this.users.find(fof_users_query.get()); List<User> result = getUsersFromCursor(users_cursor, USER_ID_KEY); return result; }
protected Document parseQuery(final Query originalQuery) { QueryBuilder builder = new QueryBuilder(); if (originalQuery != null) { builder.or(new QueryBuilder().and("_id").is(mongoIds.get(0)).get()); } else { builder.or(new QueryBuilder().and("_id").in(mongoIds).get()); builder.or(new BasicDBObject(DocumentToVariantConverter.ANNOTATION_FIELD + '.' + DocumentToVariantAnnotationConverter.GENE_SO_FIELD, new BasicDBObject("$in", gnSo))); if (!nonGeneRegionFilter) { builder.and(DocumentToVariantConverter.RELEASE_FIELD).lessThanEquals(release); QueryBuilder annotationQueryBuilder = new QueryBuilder(); parseAnnotationQueryParams(query, annotationQueryBuilder); DBObject annotationQuery = annotationQueryBuilder.get(); if (!annotationQuery.keySet().isEmpty()) { builder.and(annotationQuery); QueryBuilder studyQueryBuilder = new QueryBuilder(); final StudyConfiguration defaultStudyConfiguration = parseStudyQueryParams(query, studyQueryBuilder); if (builder.get().keySet().isEmpty()) { builder = studyQueryBuilder; } else { builder.and(studyQueryBuilder.get()); Document mongoQuery = new Document(builder.get().toMap()); logger.debug("MongoDB Query = {}", mongoQuery.toJson(new JsonWriterSettings(JsonMode.SHELL, false)));
BasicDBObject document = new BasicDBObject(); QueryBuilder qb = new QueryBuilder(); qb.or(new QueryBuilder().put("starting_date").is(null).put("ending_date").is(null).get(), new QueryBuilder().put("starting_date").lessThanEquals("ending_date").get()); document.putAll(qb.get()); DBCursor cursor = getDbCollection().find(document)
@Override public List<ApplicationAdditionalDataDTO> findApplicationAdditionalData(String applicationSystemId, String aoId, ApplicationFilterParameters filterParameters) { DBObject orgFilter = filterByOrganization(filterParameters); DBObject query = QueryBuilder.start().and(queryByPreference(filterParameters, Lists.newArrayList(aoId)).get(), newOIdExistDBObject(), new BasicDBObject(FIELD_APPLICATION_SYSTEM_ID, applicationSystemId), QueryBuilder.start(FIELD_APPLICATION_STATE).in(Lists.newArrayList( Application.State.ACTIVE.toString(), Application.State.INCOMPLETE.toString())).get(), orgFilter).get(); DBObject keys = generateKeysDBObject(DBObjectToAdditionalDataDTO.KEYS); SearchResults<ApplicationAdditionalDataDTO> results = searchListing(query, keys, null, 0, 0, new DBObjectToAdditionalDataDTO(), false); return results.searchResultsList; }
@Override public BasicDBObject getInstruction() throws TranslatorException { DBObject object = QueryBuilder.start(getDocumentName()).exists("true").notEquals(null).get(); //$NON-NLS-1$ LogManager.logDetail(LogConstants.CTX_CONNECTOR, "{\"$match\": {"+object.toString()+"}}"); //$NON-NLS-1$ //$NON-NLS-2$ return new BasicDBObject("$match", object); //$NON-NLS-1$ } }
private void addRealmCodeSecret() { DBCollection realms = db.getCollection("realms"); DBObject query = new QueryBuilder() .and("codeSecret").is(null).get(); DBCursor objects = realms.find(query); while (objects.hasNext()) { DBObject object = objects.next(); object.put("codeSecret", KeycloakModelUtils.generateCodeSecret()); realms.save(object); log.debugv("Added realm.codeSecret, id={0}", object.get("id")); } }
int i = 0; for (Region region : regions) { DBObject regionObject = new BasicDBObject(); i++; builder.or(objects);
private DBCursor query(String token) { DBObject query; DBObject queryKeys; DBObject orderBy; QueryBuilder queryBuilder = QueryBuilder.start().put("t.dataset").is("PSJD"); if (StringUtils.isNotBlank(token)) { queryBuilder.put("_id").lessThan(token); } query = queryBuilder.get(); queryKeys = QueryBuilder.start("p").elemMatch(QueryBuilder.start("n").is("metadata/BWmeta-2.1.0").get()).get(); orderBy = QueryBuilder.start("_id").is(-1).get(); return collection.find(query, queryKeys).sort(orderBy); }
@Override public CloseableIteration<Statement, QueryEvaluationException> queryIntervalEquals(final TemporalInterval query, final StatementConstraints constraints) throws QueryEvaluationException { final QueryBuilder qb = QueryBuilder.start(INTERVAL_START) .is(query.getHasBeginning().getAsDateTime().toDate()) .and(INTERVAL_END) .is(query.getHasEnd().getAsDateTime().toDate()); return withConstraints(constraints, qb.get()); }