Mongodb ensure one array field unique

Question

I am trying to make email as unique. I tried using 'unique' and 'dropDups', but it doesn't work. Any idea what I should use?

var custSchema = new Schema({ 
  "username": String,
  "Password": String,
  "email": {["Type": String,
             "Value": { type : String, lowercase: true, unique: true, dropDups: true}]
})

Example of csv data:

        username       Password            Email
                                      Type     Value
User1:   test1        asdub**jhas    Primary   test1@user1.com
User2:   test2        3kjnn**8man    Primary   Pract@test.com
User3:   test3        dsffs**as97    Primary   test1@user1.com

In this example case, there would be only two users added to the database: User1 and User2, because User3 has the same email address as User1.

Thanks for helping.

score 0 · Answer 1 · answered Mar 09 '18 at 06:28

0

Create an Index for email.Value with option unique: true and this will help us in preventing the insert of duplicate values for email Id.

db.collection_name.createIndex({"email.Value":1}, {unique:true})

References:

CreateIndex

Another SO Question

answered Mar 09 '18 at 06:28

Clement Amarnath

5,301
1
21
34

i put this one in my Schema.js, but it complains about not finding 'db'. – Vincent YC. Lin Mar 09 '18 at 17:41
This syntax is for Mongodb shell, you have to modify the query so that it suits your programming language – Clement Amarnath Mar 10 '18 at 05:47

score 0 · Answer 2 · answered Mar 09 '18 at 17:43

0

There might be some other solution that can fix this. But after I tried defining 'Email' as

"Email": [
{"Type": String,
  "Value": { type : String, lowercase: true, index: {unique: true, dropDups: true}}
}]

it works fine.

answered Mar 09 '18 at 17:43

Vincent YC. Lin

11
1

Yours and mine are the same approach ie, having unique index. – Clement Amarnath Mar 10 '18 at 05:50

Mongodb ensure one array field unique

2 Answers2