Mongoose: Unique field if it's not null or an empty string

user_13936253 0
Viewed 1222

So, I have the following schema:

const Players = new mongoose.Schema({
    discordID: {
    type: String,
    unique: true,
    required: function () {
        return typeof this.discordID !== "string" && this.discordID !== null
    }
})

My point is to make discordID unique, but only if it's not null or "".

I heard about sparse, but it doesn't seem to work as I want it to. I get duplication errors every time I'm trying to insert 2+ documents with discordID set to null (I tried sparse: true and index: {sparse: true, unique: true}).

Is there something I can do? I want to keep this validation on the schema level if it's only possible.

mongoose-schema mongoose node.js mongodb
1 Answers

Sparse indexes work for documents that omit the key. The required discordID is included and set to null which is passed onto the data store.

https://docs.mongodb.com/manual/core/index-sparse/

Sparse indexes only contain entries for documents that have the indexed field, even if the index field contains a null value. The index skips over any document that is missing the indexed field.

Set fields to undefined in mongoose for them to be removed before save.

user_13186940
Related