How to make a mongoose schema attribute unique after the schema is instantiated (already contains data)

Question

I have a mongoose schema,

const loggerSchema = mongoose.Schema(
    {
        // Other ...
        cluster: {
            type: String,
            required: true,
        },
        // ...
    }
)

It currently filled with lots of data. I want to modify the cluster property to be as follows

const loggerSchema = mongoose.Schema(
    {
        // Other ...
        cluster: {
            type: String,
            required: true,
            unique:true
        },
        // ...
    }
)

How do I achieve this without losing any of my data (in DB)? Provided that all existing data contain unique values on cluster attribute.

maybe dup of https://stackoverflow.com/questions/7617002/dealing-with-schema-changes-in-mongoose — Ofir Bi, Sep 20 '21 at 11:28

score 0 · Answer 1 · answered Sep 20 '21 at 11:34

0

If you are sure there are no duplicate values of cluster you can change your schema immediately as you mentioned (if there are dups it will fail to create the unique index on cluster).
Read more about unique option here.

answered Sep 20 '21 at 11:34

Ofir Bi

236
1
2

How to make a mongoose schema attribute unique after the schema is instantiated (already contains data)

1 Answers1