2

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.

MZPL
  • 114
  • 2
  • 8

1 Answers1

1

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.

Matt
  • 68,711
  • 7
  • 155
  • 158
  • This answer is helpful, however, I'm looking for a way to insert fields with null value. I don't want to have missing fields in documents. – MZPL Feb 11 '21 at 10:59
  • 1
    found a dupe with the answer over [here](https://stackoverflow.com/a/43804473/1318694)... [partial indexes](https://docs.mongodb.com/manual/core/index-partial/) – Matt Feb 12 '21 at 01:18