NodeJS, Mongoose - Duplicate entries when inserting data

Question

I have NodeJS with Mongoose and I'm accessing an API to retrieve data. I have a Schema as follows.

var dataSchema = new Schema({
  id:Number,
  name:String
));

And I'm using the following code to insert.

  var d = Data.find({id:data.id}, function(error, curr_data) {
    if(curr_data.length == 0) { // check to make sure only unique entries are entered
      console.log("      Inserting : " + curr_data.name);
      new Data(data).save();
    }
  });

But when I check my Mongo DB, I can still see duplicate entries.

Is there anther way?

Matt Fletcher · Accepted Answer · 2014-10-05 20:55:02Z

2

You can use Mongo's built-in count() method to check if the row exists and from that conditionally save the model:

Data.count({id: data.id}, function (err, count) {
  if (!count) {
    console.log("Inserting " + curr_data.name);
    new Data(data).save();
  }
  else {
    // Handle err.
    console.log('Already Exists');
  }
});

edited Oct 5, 2014 at 20:55

Matt Fletcher

9,4008 gold badges45 silver badges61 bronze badges

answered Apr 13, 2013 at 13:55

THE ONLY ONE

2,1901 gold badge12 silver badges6 bronze badges

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

1 Comment

Matt Fletcher Over a year ago

You can use the exact same thing with .findOne too, which is slightly less memorable but does offer you the full returned db row that you can access properties on if it is a duplicate.

Brett · Accepted Answer · 2013-04-11 06:36:53Z

-1

You do not need to add an id to your schema, Mongoose creates an ObjectId for you.

"Mongoose assigns each of your schemas an _id field by default if one is not passed into the Schema constructor. The type assiged is an ObjectId to coincide with MongoDBs default behavior. If you don't want an _id added to your schema at all, you may disable it using this option." - From the Mongoose docs

If you do want to specify your own id you can do the following to ensure that no duplicates are created:

var dataSchema = new Schema({
  id: {
    type: Number,
    index: {
      unique: true
    }
  },
  name: String
},
{ _id: false });

answered Apr 11, 2013 at 6:36

Brett

3,8853 gold badges26 silver badges28 bronze badges

1 Comment

Kivylius Over a year ago

[Error: document must have an _id before saving]

Collectives™ on Stack Overflow

NodeJS, Mongoose - Duplicate entries when inserting data

2 Answers 2

1 Comment

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related