How to query associated models in Node/Postgres

Question

I'm building an app in express and I'm using postgres and sequelize for ORM. I have two models, User and Post.

In my user.js and post.js files I have:

module.exports = function(sequelize, DataTypes) {
  return sequelize.define('users', {
    id: {
      type: DataTypes.INTEGER,
      allowNull: false,
      primaryKey: true,
      autoIncrement: true
    },
    name: {
      type: DataTypes.STRING,
      allowNull: false,
      defaultValue: ""
    },

module.exports = function(sequelize, DataTypes) {
  return sequelize.define('posts', {
    id: {
      type: DataTypes.INTEGER,
      allowNull: false,
      primaryKey: true,
      autoIncrement: true
    },
    user_id: {
      type: DataTypes.INTEGER,
      allowNull: true
    },
    title: {
      type: DataTypes.STRING,
      allowNull: false,
      defaultValue: ""
    },

I imported those two models and I made the following associations:

User.hasMany(Post, { foreignKey: 'user_id' });

Post.belongsTo(User, { foreignKey: 'user_id' });

I am trying to render all the posts done by a user, but I'm probably missing something.

In my routes I can get the correct user but I don't know how to proceed.

router.route('/:id').get(async (req, res) => {
  const user = await User.findById(req.params.id);
  console.log(user);
  res.send(user);
})

Thanks!

Vivek Doshi · Accepted Answer · 2018-04-12 07:15:51Z

1

findById does not support the associated model ,

User.findById(req.params.id);

You can change findById to findOne and include model like this ,

User.findOne({
    where : { id : req.params.id },
    include : {
        model : Post
    }
});

answered Apr 12, 2018 at 7:15

Vivek Doshi

58.8k12 gold badges120 silver badges126 bronze badges

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

Collectives™ on Stack Overflow

How to query associated models in Node/Postgres

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