MongoTemplate pull query

Question

I am trying to remove one Item from an array of an embedded field in mongoDb. Array is type of string like the below one.

{
   _id: 1,
   fruits: [ "apples", "pears", "oranges", "grapes", "bananas" ],
   vegetables: [ "carrots", "celery", "squash", "carrots" ]
}
{
   _id: 2,
   fruits: [ "plums", "kiwis", "oranges", "bananas", "apples" ],
   vegetables: [ "broccoli", "zucchini", "carrots", "onions" ]
}

I just wanted to remove the carrots from the embedded array vegetables. using mongo shell, the below query works

db.stores.update(
    { },
    { $pull: { vegetables: "carrots" },
    { multi: true }
)

Now I needed to perform this using mongoTemplate in spring, I tried with the below answer but it wont remove the element MongoTemplate pull subdocument. Can anyone suggest How I to achieve this using mongoTemplate in spring project

I still wonder how does the given query worked w.r.t. given sample documents !! Because `vegetables` is a field of type array in the actual document but not a subdocument to `fruits`. To be said they both are individual fields - you've to try { `$pull: { vegetables: "carrots" } ` — whoami - fakeFaceTrueSoul, Nov 25 '19 at 20:26
@srinivasay Sorry , my mistake. I edited the question, thanks. — Sameesh, Nov 26 '19 at 02:22
Possible duplicate of https://stackoverflow.com/questions/27152868/mongotemplate-pull-subdocument — krishna Prasad, Nov 26 '19 at 05:06

score 1 · Accepted Answer · answered Nov 26 '19 at 04:59

You can simply use the below query to pull any string in the array of vegetables object:

mongoTemplate.updateMulti(new Query(), new Update().pull("vegetables", "squash"), "stores");

In the above query, squash will be pulled after execution. For details, I have also added find query on stores collections after and before the above query as :

    List<Stores> storesList = mongoTemplate.find(new Query(), Stores.class);
    for(Stores stores : storesList) {
      System.out.println(stores.toString());
    }
    mongoTemplate.updateMulti(new Query(), new Update().pull("vegetables", "squash"), "stores");
    List<Stores> afterModificationStoresList = mongoTemplate.find(new Query(), Stores.class);
    for(Stores stores : afterModificationStoresList) {
      System.out.println(stores.toString());
    }

The output is as below :

2019-11-26 10:19:57.947 DEBUG 7321 --- [           main] o.s.data.mongodb.core.MongoTemplate      : find using query: { } fields: Document{{}} for class: class sample.data.mongo.models.Stores in collection: stores
Stores{id='1.0', fruits=[apples, pears, oranges, grapes, bananas], vegetables=[celery, squash]}
Stores{id='2.0', fruits=[plums, kiwis, oranges, bananas, apples], vegetables=[broccoli, zucchini, onions]}

2019-11-26 10:19:57.975 DEBUG 7321 --- [           main] o.s.data.mongodb.core.MongoTemplate      : Calling update using query: { } and update: { "$pull" : { "vegetables" : "squash" } } in collection: stores

2019-11-26 10:19:57.985 DEBUG 7321 --- [           main] o.s.data.mongodb.core.MongoTemplate      : find using query: { } fields: Document{{}} for class: class sample.data.mongo.models.Stores in collection: stores
Stores{id='1.0', fruits=[apples, pears, oranges, grapes, bananas], vegetables=[celery]}
Stores{id='2.0', fruits=[plums, kiwis, oranges, bananas, apples], vegetables=[broccoli, zucchini, onions]}

For code details, kinldy visit by Github repo: https://github.com/krishnaiitd/learningJava/blob/master/spring-boot-sample-data-mongodb/src/main/java/sample/data/mongo/main/Application.java#L126

MongoTemplate pull query

1 Answers1