How to Insert Dynamic Fields to a Document In MongoDB Java Driver

Question

 {
      "_id" : ObjectId("5888ae5f1495062544ac7951"),
      "site" : "gfhfh",
      "keywords" : {
        "keyword 1" : {
          "dailyranks" : {
            "2017-01-28" : {
              "rank" : 1,
            }
         **Dynamic data should add here by date ** 
          } 
        } 
      }
    }

I have tried to insert keyword rank by date. I want to add keyword rank each day. but it doesn't insert only update date and values. I have used following code in java.

for (DBObject dbo : result) {
            DBObject keywordlist = (DBObject) dbo.get("keywords");
            BasicDBObject a = new BasicDBObject();
            for (String keyword : keywordlist.keySet()) {
                DBObject rank = getRank();
                BasicDBObject rankdate = new BasicDBObject(date, rank);
                BasicDBObject aa = new BasicDBObject("dailyranks", rankdate);
                a.append(keyword, aa);
            }
            coll.update(dbo, new BasicDBObject("$set", new BasicDBObject("keywords", a)), true, false);
}

s7vr · Accepted Answer · 2017-01-26 17:12:16Z

1

Looks like you need an embedded array for both keywords and dailyranks.

"keywords": [{
    "keyword 1": {
        "dailyranks": [{
            "2017-01-28": {
                "rank": 1,
            }
        }]
    }
}]

After you have this structure, you'll use $push operator to insert new rank into embedded doc array.

You'll use $set if you trying to replace the entire embedded array.

answered Jan 26, 2017 at 17:12

s7vr

76.2k12 gold badges118 silver badges135 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to Insert Dynamic Fields to a Document In MongoDB Java Driver

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related