MongoDB: how to insert document without repeat

Question

Suppose I already have some data in database:

{
   id: 001,
   title: "title_1"
}
{
   id: 002,
   title: "title_2"
}
{
   id: 003,
   title: "title_3"
}

then I want to insert some new documents:

{
   id: 003    // id repeat
   title: "title_4"
}
{
   id: 004
   title: "title_5"
}

but I don't want to insert the { id:003 } item, because some guy in the database already has the same id.

So, how can I let the MongoDB ignore the repeat value(with specified key) item when I insert new data?

If it is okay to overwrite (but not add a new record) save works. Do you not want to overwrite? — Paul Draper
– Paul Draper, Commented Oct 31, 2013 at 8:35
It would be helpful if you would provide your expected final collection results. — WiredPrairie
– WiredPrairie, Commented Oct 31, 2013 at 11:16

Jhanvi · Accepted Answer · 2013-10-31 08:44:20Z

2

For this you have to create unique index on id. You have to try like this:

 db.collection.ensureIndex( { id: 1 }, { unique: true } )

answered Oct 31, 2013 at 8:44

Jhanvi

5,1599 gold badges34 silver badges41 bronze badges

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

Comments

hope_is_grim · Accepted Answer · 2013-10-31 08:34:21Z

0

I think you could use a Unique Index

answered Oct 31, 2013 at 8:34

hope_is_grim

1,94415 silver badges25 bronze badges

Comments

Salvador Dali · Accepted Answer · 2013-10-31 08:53:51Z

0

Apart from putting this as unique index as it was suggested earlier, you can just insert them with a different key. Instead of id key as you already have, you can insert them with unique primary key _id (you can use your own unique _id field if you want so http://docs.mongodb.org/manual/core/document/#the-id-field)

edited Oct 31, 2013 at 8:53

answered Oct 31, 2013 at 8:34

Salvador Dali

224k151 gold badges727 silver badges766 bronze badges

Collectives™ on Stack Overflow

MongoDB: how to insert document without repeat

3 Answers 3

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related