Add object to an array in java mongodb

Question

I need to add an object to an array nested inside an other object in the most "best practice way".

The problem is that I don´t want to pull up the whole array from the db just to add an new object. There must be a better way to do this like just adding the new object to the array by a query?

As for now Im pulling up a Business object with included posts, adding the new post and then updating the Business object.

public interface BusinessRepository extends MongoRepository<Business, String> {

    @Query(value="{ 'id' : ?0 }", fields="{ 'posts' : 1 }")
    Business findOneIncludeOnlyPosts(String id, Pageable pageable);
}

What I want to achieve is something like this:

@Query(value="{ SOME QUERY }")
void putPostInBusinessPosts(String id, Post post);

Is it possible or do I have to do it the more expensive way?

Using:

spring-boot 1.3.5
mongo-java-driver 3.2.2

Ori Dar · Accepted Answer · 2016-07-08 09:14:16Z

11

You can't achieve it using a MongoRepository. You will have to use MongoTemplate for that.

I don't regard it to be more expensive, but more verbose maybe.

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

...

Update update = new Update();
update.addToSet("posts", post);
Criteria criteria = Criteria.where("_id").is(id);
template.updateFirst(Query.query(criteria), update, "business");

Assuming business is the name of the collection.

answered Jul 8, 2016 at 9:14

Ori Dar

19.1k5 gold badges61 silver badges76 bronze badges

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

4 Comments

0xRLA Over a year ago

Thx for your reply. Is there a way I could use both MongoRepository and MongoTemplate trough the BusinessRepository interface?

Ori Dar Over a year ago

You can do it by having a custom repository implementation and injecting a MongoTemplate into it

Ori Dar Over a year ago

BTW, you should use update.push instead of update.addToSet if you want to trigger $push.

Raj Kumar Over a year ago

how will mongotemplate know that to which collection it need to save ?

Collectives™ on Stack Overflow

Add object to an array in java mongodb

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related