spring data MongoRepository check if a document exists before inserting by querying with entire document

Question

I am trying to create a webservice which receives a json object and performs some action based on whether the object already exists as a document in my mongodb or not. If the document already exists, I have to just perform my action. If it doesn't i have to insert it first and then perform the action.

Using spring data MongoRepository or MongoTemplate, how do I check if a document already exists - using the entire document I am about to insert? I cannot use _id here. If the entire document already exists, I don't have to insert a new document. But if at least one field is different, I have to enter a new document.

Eg:

@Document (collection = "foo")
class Foo {

   @Id
   String id;
   String name;
   List<Address> address   
   ... many more attributes
}

If I get a request using an object of Foo without _id, how do I check if this already exists as a document in my mongodb collection?

Thanks!

Ruturaj Patil · Accepted Answer · 2014-10-11 04:54:25Z

1

I think this is what you need: Finding and modifying documents You can specify all fields that must match i.e. must be unique for all documents in the query and set upsert option to true as follows:

Query query = new Query(Criteria.where("firstName").is("Ruturaj"));
Person p = mongoTemplate.findAndModify(query, update, new FindAndModifyOptions().returnNew(true).upsert(true), Person.class);

answered Oct 11, 2014 at 4:54

Ruturaj Patil

6081 gold badge10 silver badges26 bronze badges

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

Comments

coder · Accepted Answer · 2014-07-04 06:52:58Z

0

Why don't you index your collection on some field? Assuming you have name in all documents, query the db by name and if you dont get any result, add it. If you get a result compare it with what you have in the request. Best thing to do for comparing these 2 is to override equals method. Convert the request body into an object of the document and compare this with what you get from DB. If you cannot determine what will be passed in the request, you might have to query the DB based on whatever field is passed.

answered Jul 4, 2014 at 6:52

coder

1,9615 gold badges30 silver badges44 bronze badges

Collectives™ on Stack Overflow

spring data MongoRepository check if a document exists before inserting by querying with entire document

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related