update a document in mongoDB using JAVA

Question

I'm just starting to learn mongoDB using JAVA. I have the the following document in mongo

{
"_id": {
    "$oid": "513fa587c5d0cf174eb9b1f8"
},
"suitename": "test_suite_name",
"testname": "test_name]",
"milestones": [
    {
        "milestone_id": 45
    }
]
}

I have a compound key on suitename, testname, and milestone_id. I have to process a file which has these three fields. I create a simple DBObject query and check if count != 0

BasicDBObject query = new BasicDBObject();
query.put("suitename", testsuite);
query.put("testname", testcase);
query.put("milestones.milestone_id", SampleProgram.milestone_id);

If count == 0 --> add document in mongo -> this seems to work fine

What I am trying to figure out is: If I have a new value of milestone_id in my file, I just need to add a milestone to some existing document's milestone array. Existing document is determined based on suitename AND testname.

So if milestone_id = 10, the document should look like

{
"_id": {
    "$oid": "513fa587c5d0cf174eb9b1f8"
},
"suitename": "test_suite_name",
"testname": "test_name]",
"milestones": [
    {
        "milestone_id": 45
    },
    {
        "milestone_id": 10
    }

]
}

How can I accomplish this?

Thanks

nutlike · Accepted Answer · 2013-03-12 22:47:27Z

4

This can be accomplished with the $push operator which appends values to an array and the update(…) method.

BasicDBObject query = new BasicDBObject();
query.put("suitename", testsuite);
query.put("testname", testcase);

BasicDBObject push = new BasicDBObject();
push.put("$push",
  new BasicDBObject("milestones",
    new BasicDBObject("milestone_id", SampleProgram.milestone_id)));

yourCollection.update(query, push);

answered Mar 12, 2013 at 22:47

nutlike

4,9851 gold badge27 silver badges33 bronze badges

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

3 Comments

user2162796 Over a year ago

Works great. Can you tell me where you got the API reference for put?

ppeterka Over a year ago

@user2162796 I have the feeling too that the MongoDB page is structured somehow weirdly, but you can find the API docs for the various versions for Java here. All the info can be found in the appropriate "language centers"... (I can't exactly express why I'm frustrated by the structure of the page, but I fell like struggling each time I need something...)

nutlike Over a year ago

@user2162796: Since I knew the right term I just googled for it.

Balwinder Singh · Accepted Answer · 2016-09-13 05:00:18Z

1

BasicDBObject newDocument = new BasicDBObject();
newDocument.append("$set", new BasicDBObject().append("clients", 110));

BasicDBObject searchQuery = new BasicDBObject().append("hosting", "hostB");

collection.update(searchQuery, newDocument);

edited Sep 13, 2016 at 5:00

Balwinder Singh

2,2825 gold badges25 silver badges35 bronze badges

answered Sep 13, 2016 at 4:14

hhc

111 bronze badge

1 Comment

Balwinder Singh Over a year ago

You should explain the answer as well

Collectives™ on Stack Overflow

update a document in mongoDB using JAVA

2 Answers 2

3 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related