Rename field in mongoose

Question

I have two JSON objects, In each, there is a firstname field. I want to rename firstname to name, also want to import the existing firstname values to name, using mongoose.

Schema:

const mongoose = require('mongoose');
const Schema = mongoose.Schema;
const user = new Schema({
  firstname:{ type:String },
  lastname:{ type:String },
  username:{ type:String },
  password:{ type:String },
  user_type:{ type:String },
})

module.exports = mongoose.model('user', user)

Data Sample:

_id: "5bf5fbef16a06667027eecc2", firstname: "Hareesh", lastname: "Pitchikala", username: "123", password: "123", user_type: "employer", __v: 0

This question is about Mongoose but it was flagged duplicate and link to MongoDB. Come on, it's not the same — Thinh NV, Sep 16 '20 at 09:41

score 24 · Accepted Answer · edited Jan 24 '21 at 04:53

24

First, you'll need to add name to your schema so it becomes:

const user = new Schema({
    name: { type:String },
    firstname: { type:String }, //keep this for now
    lastname: { type:String },
    username: { type:String },
    password: { type:String },
    user_type: { type:String },
});

Now, in your app code somewhere, you'll need to run this:

User.updateMany({}, { $rename: { firstname: 'name' } }, { multi: true }, function(err, blocks) {
    if(err) { throw err; }
    console.log('done!');
});

Now, you can remove firstname from your schema if you wish.

edited Jan 24 '21 at 04:53

gazdagergo

6,187
1
31
45

answered Nov 23 '18 at 13:39

Alex

37,502
51
204
332

1

Not sure but I have to add `strict:false` to the snippet to get it working: Also it said `DeprecationWarning: collection.update is deprecated. Use updateOne, updateMany, or bulkWrite instead.` So I used `upadateMany` Fullcode: ``` User.updateMany( {}, { $rename: { firstname: 'name' } }, { multi: true, strict: false }, function (error) { if (error) { throw error; } console.log('done!'); } ); ``` – Thinh NV Sep 16 '20 at 09:35
3

`{ multi: true }`will be ignored. From docs: "...MongoDB will update all documents that match filter [...] regardless of the value of the multi option." – samura Jan 23 '22 at 23:01

score 0 · Answer 2 · answered Nov 23 '18 at 13:43

0

Documents can be updated as below:

db.collection.updateMany({},{ $rename: { "firstname": "name" } } );

answered Nov 23 '18 at 13:43

kRiZ

785
8
14

3

this isn't `using mongoose` - which is what the OP requested. – Alex Nov 23 '18 at 13:52
It is using mongoose though... – Torben Nordtorp Sep 20 '21 at 14:53
2

@TorbenNordtorp `db.collection` isn't mongoose syntax, it's the MongoDB driver. – Alex Jan 25 '22 at 12:23

Rename field in mongoose

2 Answers2

Linked