Spring data MongoDB update multiple fields

Question

Is it possible with Spring-Data-MongoDB to update multiple fields of a document with one query.

For example, I can run this mongo query:

db.customers.update(
  {"firstname": "Max"},
  { 
    $set: {
      "lastname": "Maier",
      "email": "[email protected]"
    }
  }
);

How can we achieve this with code and the spring MongoTemplate? For example here is the code to udpate one value:

Query select = Query.query(Criteria.where("firstname").is("Max"));
        Update updateValue = Update.update("lastname", "Maier");
        UpdateResult updateResult = mongoTemplate.updateFirst(select, updateValue, Customer.class);

It seems that the Update#set method accepts only one (key, value) and no multi-values or list of values.

pvpkiran · Accepted Answer · 2018-06-27 11:59:24Z

15

It seems that the Update#set method accepts only one (key, value) and no multi-values or list of values.

Yes, it accepts only one key and value at a time. But you can do that for many keys and values as you want. It is like a Map, you can add as many keys(unique) and values as you like.

You just need to extend your code a bit

Query select = Query.query(Criteria.where("firstname").is("Max"));
Update update = new Update();
update.set("lastname", "Maier");
update.set("email", "[email protected]");
UpdateResult updateResult = mongoTemplate.findAndModify(select, update, Customer.class);

If you dig deep into findAndModify method, you can understand, behind the scenes it is holding a key value map.

edited Jun 27, 2018 at 11:59

answered Jun 26, 2018 at 8:27

pvpkiran

27.2k13 gold badges106 silver badges149 bronze badges

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

Comments

DCO · Accepted Answer · 2020-05-13 11:24:04Z

6

In my version findAndModifiy does not return UpdateResult. I had to use method updateMulti

Query select = Query.query(Criteria.where("firstname").is("Max"));
Update update = new Update();
update.set("lastname", "Maier");
update.set("email", "[email protected]");
UpdateResult updateResult = mongoTemplate.updateMulti(select, update, Customer.class);

answered May 13, 2020 at 11:24

DCO

1,29014 silver badges26 bronze badges

Comments

Dewfy · Accepted Answer · 2018-06-25 15:03:51Z

3

You need findAndModify. Details and explanations there: https://www.mkyong.com/mongodb/spring-data-mongodb-update-document/

https://docs.mongodb.com/manual/reference/method/db.collection.findAndModify

answered Jun 25, 2018 at 15:03

Dewfy

23.8k13 gold badges78 silver badges126 bronze badges

Comments

abhinav kumar · Accepted Answer · 2020-08-13 19:13:07Z

Below is the equivalent implementation using MongoTemplate for update operation.

For updating multiple fields one doc object

   public Person update(Person person){
        Query query = new Query();
        query.addCriteria(Criteria.where("id").is(person.getId()));
        Update update = new Update();
        update.set("name", person.getName());
        update.set("description", person.getDescription());
        return mongoTemplate.findAndModify(query, update, Person.class);
    }

For updating same changes to multiple doc object based on query match

        Query query = new Query();
        query.addCriteria(Criteria.where("city").is(person.getCity()));
        Update update = new Update();
        update.set("pin", person.getPin());
        update.set("description", person.getDescription());
        mongoTemplate.updateMulti(query, update, Person.class);

Collectives™ on Stack Overflow

Spring data MongoDB update multiple fields

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related