MongoDB Schema Array Issue

Question

When I update balance, I need to keep paymentCost and Date information as a Array. But I see only one payments info in everytime.

This is my user Model:

const userSchema = new Schema({
    username:{
        type: String,
        require: true
    },
    email: {
        type: String,
        required: true,
        unique: true,
    },
    password: {
        type: String,
        require: true,
    },
    balance: {
        type: Number,
        require: false,
    },
    payments: [{paymentCost: Number, paymentDate: Date}],
    date: {
        type: Date,
        default: Date.now()

    }
})

and this is my update function:

User.findOneAndUpdate(
    { _id: user._id }, 
            { $set: { "balance" : currentBalance, "payments":{"paymentDate": productCost, "paymentDate":date}}},

   async function (error, success) {
         if (error) {
            return callback({
                message: "Balance not updated"
            })
         } else {
            user = await User.findOne({email});
            return callback(null, {...user.toJSON()})
             console.log(success);
         }
     });

And I see every time below output:

Only one payments information keeps in time, how can I keep all of them in Array?

Naim Biswas · Accepted Answer · 2022-07-19 14:21:07Z

1

$set is going to replace your current value instated of use $set you can try $push it will push your last object last on array and also if your want your last pushed object shoud be on first your can use the $pop

answered Jul 19, 2022 at 14:21

Naim Biswas

881 silver badge6 bronze badges

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

3 Comments

hobik Over a year ago

When I replace set with push I get this error: message: "Balance not updated". I used like this { $push: { "balance" : currentBalance, "payments":{"paymentDate": productCost, "paymentDate":date}}},

Naim Biswas Over a year ago

You can have to set your update query like that

your find query their {         $set: {            your value         },         $push: {             your pushed object their            }     }

hobik Over a year ago

It works now thank you. I changed as your suggestion { $set: { "balance" : currentBalance}, $push: { "payments" : {"paymentDate": productCost, "paymentDate":date}}},

hobik · Accepted Answer · 2022-07-19 14:54:39Z

0

With @Naim Biswas's help, my problem solved with below functions:

User.findOneAndUpdate(
    { _id: user._id }, 
    { $set: { "balance" : currentBalance},
    $push: { "payments" :  {"paymentCost": productCost, "paymentDate":date}}},
   async function (error, success) {
         if (error) {
            return callback({
                message: "Balance not updated"
            })
         } else {
            user = await User.findOne({email});
            return callback(null, {...user.toJSON()})
             console.log(success);
         }
     });

answered Jul 19, 2022 at 14:54

hobik

5213 gold badges10 silver badges23 bronze badges

Collectives™ on Stack Overflow

MongoDB Schema Array Issue

2 Answers 2

3 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related