Mongoose auto increment a subdocuments field in array

Question

I'm pushing subdocuments to an array:

const deliverySchema = new db.Schema({
  deliveryId: Number,
  amountDelivered: Number,
  price: Number
})

const suppliersSchema = new db.Schema({
  supplierName: String,
  phone:  Number,
  deliveries: [deliverySchema]
})

const delivery =  {
  "amountDelivered": 123,
  "price": 123
}

Suppliers.updateOne(
  { _id: supplierId },
  { $push: { deliveries: delivery } }
)

How can I have the deliveryId field inside that document auto increment on update. So the result would look something like:

{
  "supplierName": "Test supplier",
  "phone": 12345678,
  "deliveries": [
    {
      "deliveryId": 1, // Auto increment this field on update
      "amountDelivered": 123,
      "price": 123
    },
    {
      "deliverId": 2,
      "amountDelivered": 123,
      "price": 1234
    }
  ]
}

NeNaD · Accepted Answer · 2022-03-07 23:54:08Z

1

You can do it with Aggregation Framework:

$concatArrays - to concatenate the current deliveries array with new item
$size - to get the current size of the deliveries array
$sum - to sum current size of the deliveries array with 1 and use the result to set deliveryId

db.collection.update({
  "key": 1
},
[
  {
    "$set": {
      "deliveries": {
        "$concatArrays": [
          "$deliveries",
          [
            {
              "deliveryId": {
                "$sum": [
                  1,
                  {
                    "$size": "$deliveries"
                  }
                ]
              },
              "amountDelivered": 123,
              "price": 123
            }
          ]
        ]
      }
    }
  }
])

Working example

answered Mar 7, 2022 at 23:54

NeNaD

20.8k11 gold badges64 silver badges118 bronze badges

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

Collectives™ on Stack Overflow

Mongoose auto increment a subdocuments field in array

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related