Update mongodb document that has multiple arrays of embedded documents using mongoose

Question

Say i have a document that looks like this:

{
  "personId": 13998272,
  "address": [
    {
      "addressType": "HOME",
      "streetNo": 21,
      "addressLine1": "LORRAINE AVENUE",
      "addressLine2": "EDGEWATER",
      "city": "KINGSTON",
      "parish": "ST ANDREW",
      "country": "JAMAICA",
      "qScore": 0.9,
      "modifiedDate": "2019-02-17 15:24:19"
    }
  ],
  "phone": [
    {
      "originalNumber": "+18767842983",
      "phoneNumberIFormat": "+18768514679",
      "phoneNumberLFormat": "8768514679",
      "qualityScore": 0.8,
      "dataSource": "PERSON",
      "modifiedDate": "2018-12-17 09:42:31"
    }
  ],
  "email": [
    {
      "emailAddress": "[email protected]",
      "dataSource": "FINACLE",
      "qualityScore": 0.89,
      "modifiedDate": "2018-12-17 09:38:41"
    }
  ]
}

My schema is defined in the code snippet below for reference:

const contactSchema = new mongoose.Schema({
  pid: Number,
  address: [
    new mongoose.Schema({
      addressType: String,
      streetNo: String,
      addressLine1: String,
      addressLine2: String,
      city: String,
      parish: String,
      country: String,
      qScore: String,
      modifiedDate: String
    })
  ],
  phone: [
    new mongoose.Schema({
      originalNumber: String,
      phoneNumberIFormat: String,
      phoneNumberLFormat: String,
      qualityScore: Number,
      dataSource: String,
      modifiedDate: String
    })
  ],
  email: [
    new mongoose.Schema({
      emailAddress: String,
      dataSource: String,
      qualityScore: Number,
      modifiedDate: String
    })
  ]
});

How would update each array of embedded documents without overwriting the others?

Say a request is with and address and email object but not phone, how would I handle that?

O'Dane Brissett · Accepted Answer · 2019-02-27 17:35:28Z

3

You can try this ..

Get the structure of the contact object then the check to see what properties were sent in the req.body and build out the query accordingly.

N.B: You must have some validation to check the request body to ensure no unwanted properties are sent. You can use a package like Joi

   
const getContact = await contact.findOne({ id: req.params.id });

let query = { $addToSet: {} };
  for (let key in req.body) {
    if (getContact[key] && getContact[key] !== req.body[key])// if the field we have in req.body exists, we're gonna update it
      query.$addToSet[key] = req.body[key];
  }

  const contact = await Customer.findOneAndUpdate(
    { pid: req.params.id },
    query,
    {new: true}
  );

edited Feb 27, 2019 at 17:35

O'Dane Brissett

1,2811 gold badge10 silver badges24 bronze badges

answered Feb 27, 2019 at 17:02

superrcoop

4215 silver badges13 bronze badges

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

1 Comment

O'Dane Brissett Over a year ago

This is exactly what I'm look for. Thanks

MatteoPHRE · Accepted Answer · 2019-02-27 08:31:12Z

3

With mongoose, you can use $push to push object to array. The query will be like:

(saving an address and an email, querying on pid)

db.getCollection("contactSchema").update({"pid":1}, {$push: {email: emailToPush, 
address:addressToPush}})

{"pid":1} is the pid of the object you want to update;

{$push: {email: emailToPush, address:addressToPush}} is the object you want to push on each array

Then you have to filter the body of the request with a middleware or something like that. I usually use a middleware to check if the request is correct, like:

EDIT:

const buildQuery = (requestBody) => {
    let query = {$push: {}};
    Object.keys(requestBody).map(key => {
        query.$push[key] = requestBody[key];
    });
}

This will build your query object (the second parameter of the update function).

edited Feb 27, 2019 at 8:31

answered Feb 26, 2019 at 17:32

MatteoPHRE

3894 silver badges12 bronze badges

2 Comments

O'Dane Brissett Over a year ago

What if the request only consist of address or only phone or only email and so no? How do i dynamically handle each request not knowing what exactly what will be in the body?

O'Dane Brissett Over a year ago

Great! This should work.. But why not use addToSet instead of push?

Collectives™ on Stack Overflow

Update mongodb document that has multiple arrays of embedded documents using mongoose

2 Answers 2

1 Comment

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related