How to update only specific field on embedded file ini node js and mongodb

Question

I have problem when I want update some field data from document embedded. I cannot update specific field without update whole document. If advanced have suggestion how to the best way to solve this. I really appreciate it.

This my request data:

{
    "userstatus": "tidak aktif",
    "password": "lukeskywalker"
}

This my user Schema (model):

'use strict';
const mongoose = require('mongoose');
const Schema = mongoose.Schema;
const Attributes = new Schema({
  username:{type:String,unique:true,required:true,trim:true},
  email:{type:String,unique:true,required:true,trim:true},
  password:{type:String,required:true},
  hashpassword:{type:String},
  oldpassword:{type:String},
  salt:{type:String},
  usertype:{type:String,enum:['bisnis','personal']},
  userstatus:{type:String,enum:['aktif','tidak aktif','banned'],default:'tidak aktif'}
}, {_id:false});

const UsersSchema = new Schema({
  "type":{type:String, default:'users'},
  "attributes":Attributes
});
module.exports = mongoose.model('Users',UsersSchema);

This my code to edit user document:

//...update user
exports.editUsers = (req, res) => {
  let id = req.params.id;
  let body = req.body;
  let attrTemp = {attributes:{}};

  //...get key
  Object.keys(body).forEach((key) => {
    attrTemp.attributes[key] = body[key];
  });

  UsersModel.findOneAndUpdate(
  {"_id":id, "attributes.username":result.attributes.username},
  attrTemp.attributes,
  (err, result) => {
    if (err) {
      res.json(err);
    };

    res.json(result);
  });
};

This sample code is work when I do like this:

//...update user
    exports.editUsers = (req, res) => {
      let id = req.params.id;
      let body = req.body;
    
      UsersModel.findOneAndUpdate(
        {
          "_id":id, 
          "attributes.username":result.attributes.username
        },
        {
          //...hardcode to sample
          "attributes.userstatus":"tidak aktif",
          "attributes.password":"password"
        },
        (err, result) => {
          if (err) {
            res.json(err);
          };
    
          res.json(result);
        }
      );
    };

I want update only specific field who I send request to update. Not whole of my attributes. How the best way to do this.

Thanks advanced.

If your fields are embedded then you have to $set for each field like you have done in your second example... If you want to $set for the fields being passed then you have to take that fields in "ROOT" document — Ashh
– Ashh, Commented Aug 11, 2018 at 5:39
Can you give me code for sample, because I don't get what you mean. thanks. — Sukma Saputra
– Sukma Saputra, Commented Aug 11, 2018 at 6:13
I mean put your attributes fields in root document of the userSchema instead of embedded in attributes... something like that const UsersSchema = new Schema({ type:{type:String, default:'users'}, username:{type:String,unique:true,required:true,trim:true}, email:{type:String,unique:true,required:true,trim:true}, password:{type:String,required:true}, hashpassword:{type:String}, oldpassword:{type:String}, salt:{type:String}, usertype:{type:String,enum:['bisnis','personal']}, userstatus:{type:String,enum:['aktif','tidak aktif','banned'],default:'tidak aktif'} }); — Ashh
– Ashh, Commented Aug 11, 2018 at 6:21

Sukma Saputra · Accepted Answer · 2018-08-11 07:57:17Z

0

I have the answer from this Node.js - Mongoose - Update nested array with all values in req.body

And this my code:

//...update user
exports.editUsers = (req, res) => {
  let id = req.params.id;
  let body = req.body;
  let updateObj = {$set:{}};

  //...get key
  Object.keys(body).forEach((key) => {
    updateObj.$set['attributes.' + key] = body[key];
  });

  UsersModel.update({'_id':id}, updateObj, (err, result) => {
    if (err) {
      res.json(err);
    }
    res.json(result);
  });
};

Thanks.

answered Aug 11, 2018 at 7:57

Sukma Saputra

1,61919 silver badges34 bronze badges

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

Collectives™ on Stack Overflow

How to update only specific field on embedded file ini node js and mongodb

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related