Question 117258 in Mongodb Question posted in
The official documentation can be found here.

MongoDB Schema Array Issue

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:

enter image description here

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

Tags:

2

Answers


  1. Chosen as BEST ANSWER
    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);
         }
     });

  2. 0

    $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

    Login or Signup to reply.
Please signup or login to give your own answer.

Back To Top
Search