Convert String fields to ObjectID fields in MongoDB using Mongoose

Question

I have a MongoDB database with two schemas - users and posts. It used to look like this:

username: {type: String},
following: {type: [String], ref: 'users'}

user_id: {type: String, ref: 'users'}
comment: {type: String}

But now I've decided to change reference fields' types from String to ObjectId so now I have:

username: {type: String},
following: {type: [Schema.Types.ObjectId], ref: 'users'}

user_id: {type: Schema.Types.ObjectId, ref: 'users'}
comment: {type: String}

But the old data in the database is still stored as Strings. How can I migrate that data properly?

I use Mongoose to query the database from my code.

i think you shoud use model.find({}) all the post documents and after that loop through each docment and doc. user_id = mongoose.Types.ObjectId(doc.user_id); and do doc.save on each document — Asif Saeed
– Asif Saeed, Commented Jan 28, 2017 at 15:46
Why I typically do is convert my old data with mongo shell script — chpopov
– chpopov, Commented Jan 28, 2017 at 16:41

Asif Saeed · Accepted Answer · 2017-01-28 18:08:41Z

3

You should use model.find({}) to fetch all the post documents and after that loop through each document and update each document

doc.user_id = mongoose.Types.ObjectId(doc.user_id); 
doc.save();

answered Jan 28, 2017 at 18:08

Asif Saeed

2,05516 silver badges25 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Rohail Butt · Accepted Answer · 2020-09-15 18:45:41Z

0

You can use model.find({}) to get all documents and loop through the docs and update it.


const media = await Media.find({});
            media.forEach(async (item) => {
            const update = await Media.findOneAndUpdate(
                    { _id: item._id },
                    { user: mongoose.Types.ObjectId(item.user) },
                    { upsert: true }
                );
            });```

answered Sep 15, 2020 at 18:45

Rohail Butt

4473 gold badges7 silver badges23 bronze badges

Collectives™ on Stack Overflow

Convert String fields to ObjectID fields in MongoDB using Mongoose

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related