how to save new record even if same record exist with status false in unique schema using mongoose node js

Question

Need to a save new record even if one record already exists with status false in unique schema using mongoose node js. I have one record along with {status:false} by updating status true to false while deleting that record. Now i try to add a new record. but new record is not crated. because i have apply unique: true in mongoose schema. I need to apply unique : true, but same time need to create new record if it's status false for exist one. So can anyone give some suggestion

Mongoose, nodejs with mongoose-beautiful-unique-validator

//schema model
     var userSchema = new mongoose.Schema({
          userName: {
         type: String,
         required: true,
         unique: true
     })

 //save user function inside module export function
 const user= mongoose.model('userSchema');
 user.userName = fields.username;
 user.save((err, doc) => {
                 if (!err){
                     res.send(true);
                 } else {
                     console.log(err);

                     return;
                 }

              })

Expected result:

  [
   {_id: 12345, userName: 'Uday', status:false},
   {_id: 67894, userName: 'Uday', status:true}
  ]

Actual result: I got duplicate error When i try to save name with Uday with status: true

 [
   {_id: 12345, userName: 'Uday', status:false},
 ]

If my understanding is correct, what you need is composite key on username and status. Please see this ref : https://stackoverflow.com/questions/16061744/mongoose-how-to-define-a-combination-of-fields-to-be-unique you have to create index on these two fields and mark unique true also remove the unique : true from current schema — Vikash_Singh, Apr 04 '19 at 18:26

score 2 · Answer 1 · answered Apr 04 '19 at 13:17

If you want duplicate entries for the username then you need to remove unique: true from schema design, because you can't save the same username twice in same collections.

And if your requirement is just to update status so you can use update query instead of save/insert.

score 0 · Answer 2 · answered Apr 04 '19 at 13:09

0

Your id is alway unique in mongodb. Without same id you only can insert data but same id its not possible.

answered Apr 04 '19 at 13:09

Anupam

201
2
4
11

I don't need same id. i need record with same username – uday s Apr 04 '19 at 13:17
That is not an issue. – Anupam Apr 05 '19 at 06:23

score 0 · Answer 3 · answered Apr 07 '19 at 18:32

Drop the required attribute from your Schema, then you could pass a callback to pre('save', callback) that checks 2 things:

Does the username already exists (just check the return from Model.find({username: usernameToCheck}, callback));
In your callback, check for the status attribute, if its false then throw an exception, else save your document.

how to save new record even if same record exist with status false in unique schema using mongoose node js

3 Answers3