Spring Data Mongodb: remove String from Array

Question

I have a collection named pub. Each document contains a array of strings named cocktails, So that :

{"id" : "0", "name" : "My Beautiful Pub", "cocktails" : ["B52", "SexOnTheBeach", "Negroni"]}

Using Spring mongodb, I would delete every "SexOnTheBeach", so that :

{"id" : "0", "name" : "My Beautiful Pub", "cocktails" : ["B52", "Negroni"]}

... every pub document in my "pub" collection cannot contain the "SexOnTheBeach".

I think I should use the new Update().pull() method, but every update doesn't modify my db.

This mongodb query works perfectly, but I don't know how to translate it!

db.pub.update(
{ },
{ $pull: {  cocktails: "SexOnTheBeach" } },
{ multi: true })

Ty in advance.

Valijon · Accepted Answer · 2020-02-24 20:58:29Z

1

In your @Service class, add:

import org.springframework.data.mongodb.core.MongoTemplate;
import org.springframework.data.mongodb.core.query.Update;
import org.springframework.data.mongodb.core.query.Query;

@Autowired
private MongoTemplate mongoTemplate;

...

mongoTemplate.updateMulti(new Query(), new Update().pull("cocktails", "SexOnTheBeach"), "pub");

answered Feb 24, 2020 at 20:58

Valijon

13.2k4 gold badges40 silver badges74 bronze badges

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

1 Comment

Adriano Bellavita Over a year ago

TY, perfect solution!

Collectives™ on Stack Overflow

Spring Data Mongodb: remove String from Array

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related