Mongoose Cannot Update Instead Create A New Array

Question

I cannot update my collection even without encountering any error. Can someone help? Please I am troubleshooting this for like 3 hours now.

const product_id = req.body.cartItems.product_id;
      const item = cart.cartItems.find(c => c.product_id == product_id);
      if (item) {
        Cart.findOneAndUpdate({ "user": req.user._id, "cartItems.product_id" : product_id }, {
            "$set": {
              "cartItems.$":{
                ...req.body.cartItems.quantity,
                quantity: item.quantity + req.body.cartItems.quantity
              }
            }
          })
          .exec((error, _cart) => {
          if (error) return res.status(400).json({ error });
          if (_cart) {
            return res.status(201).json({ _cart });
          }
        });

The MODEL:

const mongoose = require('mongoose');

const cartSchema = new mongoose.Schema({
    user: { type: mongoose.Schema.Types.ObjectId, ref: 'User', required: true},
    cartItems: [
        {
            product_id: { type: mongoose.Schema.Types.ObjectId, ref: 'Product', required: true}, // This foreign key to product _id
            quantity: {type: Number,required: true},
            price: {type: Number, required: true}
        }
    ]
}, {timestamps: true});

module.exports = mongoose.model('Cart', cartSchema);

You may now check it @stefOb sorry I'm still a newbie on stackoverflow — Mawty
– Mawty, Commented Apr 7, 2021 at 15:33

stefano · Accepted Answer · 2021-04-07 15:43:29Z

1

You need to use the $[] operator to update all documents inside the cartItems array matching your filter criteria. This operator acts like a placeholder for all items in the array. Considering your coding it would be something like this:

Cart.findOneAndUpdate({ "user": req.user._id, "cartItems.product_id" : product_id }, {
        "$set": {
          "cartItems.$[].quantity": item.quantity + req.body.cartItems.quantity
        }
      }).exec(...)

answered Apr 7, 2021 at 15:43

stefano

3354 silver badges17 bronze badges

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

1 Comment

Mawty Over a year ago

I'll test this thank you so much! Atleast I have the idea now

Showrin Barua · Accepted Answer · 2021-06-23 19:58:02Z

0

const product = req.body.cartItems.product;
const items = cart.cartItems.find((c) => c.product == product);

if (items) {
  Cart.findOneAndUpdate(
    {
      user: req.user._id,
      'cartItems.product': product,
    },
    {
      $set: {
        'cartItems.$': {
          ...req.body.cartItems,
          quantity: items.quantity + req.body.cartItems.quantity,
        },
      },
    }
  ).exec((error, _cart) => {
    if (error) return res.status(400).json({ error });

    if (_cart) {
      res.status(200).json({
        cart: _cart,
      });
    }
  });
}

edited Jun 23, 2021 at 19:58

Showrin Barua

1,8051 gold badge13 silver badges22 bronze badges

answered Jun 23, 2021 at 10:06

Rehan Karol

1

Collectives™ on Stack Overflow

Mongoose Cannot Update Instead Create A New Array

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related