} else { BasicDBObject update = (BasicDBObject)doc; update.remove(updateKey); collection.updateOne(query, update, new UpdateOptions().upsert(upsert));
protected DBObject buildGetFields(BitSet arrayBits, String embedId, boolean needFull, MetaClass rootMetaClass) { BasicDBObject fieldObject = new BasicDBObject(); // get version from root document fieldObject.put(InternalFieldEnum.VERSION.getDbName(), 1); // get id of all intermediate document String idPath = null; if (arrayBits.cardinality() >= 1) { List<String> embedSegList = helper.getEmbedPathSegs(embedId, rootMetaClass); StringBuilder idPathBuilder = new StringBuilder(); for(int index = 0; index < embedSegList.size(); index++){ String dbFieldName = embedSegList.get(index); idPathBuilder.append(dbFieldName); idPathBuilder.append(EntityIDHelper.DOT); idPathBuilder.append(MetaField.VALUE_KEY); idPathBuilder.append(EntityIDHelper.DOT); idPath = idPathBuilder.toString() + InternalFieldEnum.ID.getDbName(); fieldObject.put(idPath, 1); } } // get leaf document if (needFull) { // since {a.b._i : 1, a.b : 1} only return a.b, we have to remove a.b._i fieldObject.remove(idPath); String embedPath = helper.getEmbedPath(embedId, rootMetaClass); fieldObject.put(embedPath, 1); } return fieldObject; }
protected DBObject buildGetFields(BitSet arrayBits, String embedId, boolean needFull, MetaClass rootMetaClass) { BasicDBObject fieldObject = new BasicDBObject(); // get version from root document fieldObject.put(InternalFieldEnum.VERSION.getDbName(), 1); // get id of all intermediate document String idPath = null; if (arrayBits.cardinality() >= 1) { List<String> embedSegList = helper.getEmbedPathSegs(embedId, rootMetaClass); StringBuilder idPathBuilder = new StringBuilder(); for(int index = 0; index < embedSegList.size(); index++){ String dbFieldName = embedSegList.get(index); idPathBuilder.append(dbFieldName); idPathBuilder.append(FlattenEntityIDHelper.DOT); idPath = idPathBuilder.toString() + InternalFieldEnum.ID.getDbName(); fieldObject.put(idPath, 1); } } // get leaf document if (needFull) { // since {a.b._i : 1, a.b : 1} only return a.b, we have to remove a.b._i fieldObject.remove(idPath); String embedPath = helper.getEmbedPath(embedId, rootMetaClass); fieldObject.put(embedPath, 1); } return fieldObject; }
private void removeParentKey(MongoDocument document, BasicDBObject row) throws TranslatorException { Table source = document.getTable(); Table target = document.getMergeTable(); for (ForeignKey fk:source.getForeignKeys()) { if (fk.getReferenceTableName().equals(target.getName())){ for (int i = 0; i < fk.getColumns().size(); i++) { if (row != null) { row.remove(fk.getColumns().get(i).getName()); } } } } }
/** * Adds a list of clauses to the query as disjunction (logical OR). */ public Query or(BasicDBList clauses) { if (clauses==null || clauses.size()==0) { return this; } if (query.containsField("$or")) { BasicDBList andClauses = new BasicDBList(); andClauses.add(new BasicDBObject("$or", query.remove("$or"))); andClauses.add(new BasicDBObject("$or", clauses)); and(andClauses); } else if (query.containsField("$and")) { BasicDBList andClauses = (BasicDBList) query.get("$and"); andClauses.add(new BasicDBObject("$or", clauses)); } else { query.append("$or", clauses); } return this; }
/** * Adds a list of clauses to the query as disjunction (logical OR). */ public Query or(BasicDBList clauses) { if (clauses==null || clauses.size()==0) { return this; } if (query.containsField("$or")) { BasicDBList andClauses = new BasicDBList(); andClauses.add(new BasicDBObject("$or", query.remove("$or"))); andClauses.add(new BasicDBObject("$or", clauses)); and(andClauses); } else if (query.containsField("$and")) { BasicDBList andClauses = (BasicDBList) query.get("$and"); andClauses.add(new BasicDBObject("$or", clauses)); } else { query.append("$or", clauses); } return this; }
protected DBObject buildGetFields(BitSet arrayBits, String embedId, boolean needFull, MetaClass rootMetaClass) { BasicDBObject fieldObject = new BasicDBObject(); // get version from root document fieldObject.put(InternalFieldEnum.VERSION.getDbName(), 1); // get id of all intermediate document String idPath = null; if (arrayBits.cardinality() >= 1) { List<String> embedSegList = helper.getEmbedPathSegs(embedId, rootMetaClass); StringBuilder idPathBuilder = new StringBuilder(); for(int index = 0; index < embedSegList.size(); index++){ String dbFieldName = embedSegList.get(index); idPathBuilder.append(dbFieldName); idPathBuilder.append(EntityIDHelper.DOT); idPathBuilder.append(MetaField.VALUE_KEY); idPathBuilder.append(EntityIDHelper.DOT); idPath = idPathBuilder.toString() + InternalFieldEnum.ID.getDbName(); fieldObject.put(idPath, 1); } } // get leaf document if (needFull) { // since {a.b._i : 1, a.b : 1} only return a.b, we have to remove a.b._i fieldObject.remove(idPath); String embedPath = helper.getEmbedPath(embedId, rootMetaClass); fieldObject.put(embedPath, 1); } return fieldObject; }
try { while(cursor.hasNext()) { BasicDBObject doc = (BasicDBObject) cursor.next(); BasicDBList scoreList = (BasicDBList) doc.get("scores"); doc.remove("scores"); BasicDBObject hw1 = (BasicDBObject) scoreList.get("2"); double hw1Score = hw1.getDouble("score"); BasicDBObject hw2 = (BasicDBObject) scoreList.get("3"); double hw2Score = hw2.getDouble("score"); if (hw1Score > hw2Score) { scoreList.remove(3); } else { scoreList.remove(2); } doc.put("scores",scoreList); collection.save(doc); System.out.println(doc); } } finally { cursor.close(); } }
insert.remove("_id"); //$NON-NLS-1$ BasicDBObject insertDoc = new BasicDBObject(mongoDoc.getQualifiedName(true), insert); LogManager.logDetail(LogConstants.CTX_CONNECTOR, "update - {\"$match\": {"+match+"}}"); //$NON-NLS-1$ //$NON-NLS-2$
user.remove("socialLinks"); users.save(user);
embedParentObject.remove("_id");
embedParentObject.remove("_id");
for (int i = 0; i < ENTITY_COUNT; i++) { entity.removeField(InternalFieldEnum.ID.getName()); entity.getNode().remove("_id");
for (int i = 0; i < TOTAL_COUNT; i++) { entity.removeField(InternalFieldEnum.ID.getName()); entity.getNode().remove("_id"); persistenceService.create(entity, persistenceContext);
} catch (DuplicateKey key) { if (replaceExisting) { triggerDB.remove("_id"); triggerCollection.update(keyAsDBObject(newTrigger.getKey()), triggerDB); } else {
currentClient.remove("allowedClaimsMask");
embedParentObject.remove("_id");
for (int i = 0; i < CREATE_COUNT; i++) { entity.removeField(InternalFieldEnum.ID.getName()); entity.getNode().remove("_id"); persistenceService.create(entity, persistenceContext);