Mongoose: How to post into array inside Schema

Question

I have a Company Schema that will hold some data for that company and an array of posts. When a user submits a post I use passport to decode the token and get some user information. Inside that user information there is an object ID which allows me to find the company that the user belongs to.

So now I have found the company that the user belongs to I need to save the submitted post into the board_posts array inside this company

const mongoose = require('mongoose');
const Schema = mongoose.Schema;

const BoardPostSchema = new Schema({
    name: {
        type: String
    }
});

const CompanySchema = new Schema({
    company_name: {
        type: String
    },
    board_posts: [BoardPostSchema],
});

module.exports = Company = mongoose.model('companies', CompanySchema);

router.post('/new-opportunity',  passport.authenticate('jwt', { 
    session: false 
}), (req, res) => {
    let user = req.user;
    let newPost = req.body;
    let companyId = user.company_id;

    const boardPost = {
        name: newPost.name
    };

    Company.find({'_id': companyId})
        .then(company => {
            // push boardPost into this company.board_posts array
        })
        .catch(error => {

        });
});

SuleymanSah · Accepted Answer · 2020-04-16 12:46:06Z

1

An alternative solution with findByIdAndUpdate:

router.post("/new-opportunity", passport.authenticate("jwt", { session: false }), (req, res) => {
  let user = req.user;
  let newPost = req.body;
  let companyId = user.company_id;

  const boardPost = {
    name: newPost.name,
  };

  Company.findByIdAndUpdate(
    companyId,
    {
      $push: {
        board_posts: boardPost,
      },
    },
    {
      new: true,
    }
  )
    .then((company) => {
      console.log("Updated compay if found:", company);
      res.send(company);
    })
    .catch((error) => {
      console.log(error);
      res.status(500);
    });
});

Or if you want only update status, you can use updateOne:

router.post("/new-opportunity", passport.authenticate("jwt", { session: false }), (req, res) => {
  let user = req.user;
  let newPost = req.body;
  let companyId = user.company_id;

  const boardPost = {
    name: newPost.name,
  };

  Company.updateOne(
    { _id: companyId },
    {
      $push: {
        board_posts: boardPost,
      },
    }
  )
    .then((result) => {
      console.log(result);
      // result.n; // Number of documents matched
      // result.nModified; // Number of documents modified
      res.send(result);
    })
    .catch((error) => {
      console.log(error);
      res.status(500);
    });
});

edited Apr 16, 2020 at 12:46

answered Apr 16, 2020 at 12:29

SuleymanSah

18k6 gold badges38 silver badges60 bronze badges

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

4 Comments

Reece Over a year ago

What does "new: true" do, does that just create a new object? If I set it to false would I be able to use a similar method to update a post inside the board_posts array?

SuleymanSah Over a year ago

with {new: true} option we get the updated object. It is useful to see the updated object so that we can easily understand whether the push worked.

Reece Over a year ago

So if I don't want to return the any data and instead just return a status then I don't need this part?

SuleymanSah Over a year ago

@Reece if you aren't interested in the updated object, better to use updateOne method, I added is to the answer.

Kira · Accepted Answer · 2020-04-16 12:09:00Z

1

You can use $push and update

router.post('/new-opportunity',  passport.authenticate('jwt', { 
    session: false 
}), (req, res) => {
    let user = req.user;
    let newPost = req.body;
    let companyId = user.company_id;

    const boardPost = {
        name: newPost.name
    };

    Company.update({_id: user.company_id},{
         $push{
             //the things you want to add
         }
    });
});

Hopefully this is what you want to do!

answered Apr 16, 2020 at 12:09

Kira

1181 silver badge9 bronze badges

Comments

Ilijanovic · Accepted Answer · 2020-04-16 12:25:33Z

0

Yes you can use the $pushand findOneAndUpdate operator. It would look nicer if you use the async/await approach.

router.post('/new-opportunity',  passport.authenticate('jwt', { 
   session: false 
}), async (req, res) => {
   let user = req.user;
   let newPost = req.body;
   let companyId = user.company_id;

   const boardPost = {
       name: newPost.name
   };

  let response = await Company.findOneAndUpdate({'_id': companyId}, {
     $push: {
        board_posts: "testword1"
     }
  },{ new: true })  //i set this to true so mongodb will return me the new updated document

  res.send(response);

});

answered Apr 16, 2020 at 12:25

Ilijanovic

15k4 gold badges29 silver badges63 bronze badges

Collectives™ on Stack Overflow

Mongoose: How to post into array inside Schema

3 Answers 3

4 Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

4 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related