Feature Request: Allow Unique in Array Schema Definition

[ccravens]

The following page states currently supported Schema types: http://mongoosejs.com/docs/schematypes.html

One feature that would be nice is for Mongoose to enforce uniqueness in Arrays, which could guarantee unique values in an array in Mongoose, like the $addToSet functionality in the Mongo database query language.

Current Issue

I can only define an array to hold a list of values, which allows multiple instances of the same value. The following code example demonstrates the issue.

var schema = mongoose.Schema({
friends : [{type : mongoose.Schema.Types.ObjectId, ref : 'User' }]
})

model = new mongoose.model('User')

model['friends'].push(ObjectId('12345'))
model['friends'].push(ObjectId('12345'))

model.save()

Mongo document now looks like:
{friends:[ObjectId('12345'),ObjectId('12345')]}

Suggested Fix

Enhance the schema model to allow unique attribute for an array, which internally uses the Set() object in Mongoose. Then once save() is called, mongoose will convert the set to an array and use the "$addToSet" mongodb operator that will ensure values are unique in the array. Something like the following code snippet would be desired:

var schema = mongoose.Schema({
friends : [{type : mongoose.Schema.Types.ObjectId, ref : 'User', unique: true }]
})
model = new mongoose.model('User')

model['friends'].push(ObjectId('12345'))
model['friends'].push(ObjectId('12345'))

model.save()

Mongo document now looks like:
{friends:[ObjectId('12345')]}

Current Method

Currently it is being suggested to create a seperate update() function with the "$addToSet" parameter, which seems to be more work and burden on the developer than it should be. Please refer to the following:

https://groups.google.com/forum/#!topic/mongoose-orm/QSpr_7rtEYY
http://stackoverflow.com/questions/15921700/mongoose-unique-values-in-nested-array-of-objects

[BlueAccords]

+1
Also, just wondering but how difficult would it be to implement this?

[vkarpov15]

Pretty difficult actually, mongoose would have to do a lot to make this work, because $addToSet doesn't work well with document arrays. For example, there is no good way to, say, $addToSet a user object to an array called users while enforcing that the username property should be unique. This would make the API a bit unwieldy, because unique would only work as expected for regular arrays, but not work right for document arrays.

[yonib05]

+1
I can imagine it would be a bit complex and inefficient on the querying side but it still would be nice to have.

[trycontrolmymind]

+1
It would be very nice to do it

[forl]

+1
Nice feature to have!

[ianmin2]

+1

 That'd be a really awesome feature, especially for use with sub-schemas /documents such that each has it's own distinct scope.  
 Somebody please add it.

[amit3vr]

+1

[faizalpribadi]

+1, but since now, it's a good way, if you handle it with code

[maximilianschmid]

+1

[nubitech]

+1

[klaaz0r]

+1

[fauria]

+1

[scombat]

+1

[toymachiner62]

👍

[strafe89]

+1

[0xc00010ff]

bump! ✊

[antonsamarsky]

+1

[antonlvovych]

+1

[nitindhar7]

+1

[raphaklaus]

+1

[bshikhar13]

+1

[evgeniedasaev]

+1

[Sonivaibhav26]

+1

[jpetitte]

+1

[rraghav13]

+1

[robertleeplummerjr]

+1

[Trenrod]

+1

[pashoo2]

+1

[januszhou]

+1

[andrewstec]

+1

[vkarpov15]

Use the mongoose-unique-array plugin and mongoose 4.10 for this behavior

[vkarpov15]

Check out http://thecodebarbarian.com/whats-new-in-mongoose-4.10-unique-in-arrays.html if you're eager to get started 👍

[Pei116]

Does that plugin work with Document.findByIdAndUpdate()?

[vkarpov15]

@Pei116 no unfortunately it only works for save() right now