Push items into array of objects with array attribute in mongoose

Question

Hello I am trying to add an element to an array that is inside an object and the object in turn inside an array, below is the structure.

// Schema called "Team" with mongoose
category: [
{
  seasson: { type: String, required: true },
  categories: [{ type: String, required: true }]
}]
// In code looks like:
[
  {
    seasson: "The seasson name 1",
    categories: ["categoryOne", "categoryTwo"]
  }
  {
    seasson: "The seasson name 2",
    categories: ["categoryOne"] // I want to make push in this array the value "categoryTwo"
  },
]
// I´m trying something like following code:
const status = await Team.updateOne(
  {
    _id: mongoose.Types.ObjectId(teamId),
  },
  { $addToSet: { "category.$last.categories": "categoryTwo"} }
)

Whenever an array has to be pushed into the object, it will be in the last position of the main array. Honestly, I've been trying to find a way for a while, but I can't think of anything that works. Thanks in advance.

is category field in your schema?

turivishal
– turivishal

2021-08-07 18:23:40 +00:00
Commented Aug 7, 2021 at 18:23 — turivishal
– turivishal, Commented Aug 7, 2021 at 18:23
Ye is one of the fields in my schema

Eladiorocha
– Eladiorocha

2021-08-07 18:44:32 +00:00
Commented Aug 7, 2021 at 18:44 — Eladiorocha
– Eladiorocha, Commented Aug 7, 2021 at 18:44

turivishal · Accepted Answer · 2021-08-08 05:56:25Z

There is no straight way to update the last element of the array without any identity, you can use update with aggregation pipeline starting from MongoDB 4.2,

$map to iterate loop of category array
$mergeObjects to merge current category object with updated categories field
$last to get the last element value from category.seasson
$cond check condition if above last element's value and current object session matches then do update operation otherwise return existing values
$setUnion to concat new value of categories, if it is present then it will do replace

let category = "categoryTwo";
const status = await Team.updateOne(
  { _id: mongoose.Types.ObjectId(teamId) },
  [{
    $set: {
      category: {
        $map: {
          input: "$category",
          in: {
            $mergeObjects: [
              "$$this",
              {
                categories: {
                  $cond: [
                    {
                      $eq: [
                        { $last: "$category.seasson" },
                        "$$this.seasson"
                      ]
                    },
                    { $setUnion: ["$$this.categories", [category]] },
                    "$$this.categories"
                  ]
                }
              }
            ]
          }
        }
      }
    }
  }]
)

Playground

Takis · Accepted Answer · 2021-08-08 00:12:23Z

The bellow query,adds "categoryTwo" in categories,of the last member of array category.I think this is what you want.

If you can next time give the document in the initial form,describe the query you want,and give the document in the final form,in valid JSON so people can help you easier.

You can try the code here Its pipeline update,needs MongoDB >= 4.2

Data in(Collection)

[
  {
    "_id": 1,
    "category": [
      {
        "seasson": "The seasson name 1",
        "categories": [
          "categoryOne",
          "categoryTwo"
        ]
      },
      {
        "seasson": "The seasson name 2",
        "categories": [
          "categoryOne"
        ]
      },
      
    ]
  }
]

Query

db.collection.update({
  "_id": {
    "$eq": 1
  }
},
[
  {
    "$addFields": {
      "category": {
        "$let": {
          "vars": {
            "without_last": {
              "$slice": [
                "$category",
                0,
                {
                  "$subtract": [
                    {
                      "$size": "$category"
                    },
                    1
                  ]
                }
              ]
            },
            "last_member": {
              "$arrayElemAt": [
                {
                  "$slice": [
                    "$category",
                    -1,
                    1
                  ]
                },
                0
              ]
            }
          },
          "in": {
            "$concatArrays": [
              "$$without_last",
              [
                {
                  "$mergeObjects": [
                    "$$last_member",
                    {
                      "categories": {
                        "$concatArrays": [
                          "$$last_member.categories",
                          [
                            "categoryTwo"
                          ]
                        ]
                      }
                    }
                  ]
                }
              ]
            ]
          }
        }
      }
    }
  }
])

Results

[
  {
    "_id": 1,
    "category": [
      {
        "categories": [
          "categoryOne",
          "categoryTwo"
        ],
        "seasson": "The seasson name 1"
      },
      {
        "categories": [
          "categoryOne",
          "categoryTwo"
        ],
        "seasson": "The seasson name 2"
      }
    ]
  }
]

Collectives™ on Stack Overflow

Push items into array of objects with array attribute in mongoose

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related