Node.js+Sequelize+PostgreSQL发帖功能：外键关联与报错解决

Hey there, let's fix this issue step by step. The core problem here comes from two key points: a typo in your model associations, and missing the required userID when creating a post. Let's break down the solutions:

1. Fix the Typo in Model Associations #

You wrote refeignKey instead of the correct foreignKey in all your model association definitions. Sequelize can't recognize this misspelled parameter, which breaks the automatic foreign key handling. Here's the corrected code for each model:

Corrected User Model #

'use strict';
module.exports = (sequelize, DataTypes) => {
  const User = sequelize.define('User', {
    firstName: DataTypes.STRING,
    lastName: DataTypes.STRING,
    username: DataTypes.STRING,
    password: DataTypes.STRING,
    email: DataTypes.STRING,
    phone: DataTypes.STRING,
    gender: DataTypes.STRING
  }, {});
  User.associate = function(models) {
    User.hasMany(models.Post, { foreignKey: 'userID' })
    User.hasMany(models.Comment, { foreignKey: 'userID' })
    User.hasMany(models.Follow, { foreignKey: 'userID' })
    // Add an alias to avoid conflicts with duplicate Follow associations
    User.hasMany(models.Follow, { foreignKey: 'userID_follow', as: 'Followers' })
  };
  return User;
};

Corrected Post Model #

'use strict';
module.exports = (sequelize, DataTypes) => {
  const Post = sequelize.define('Post', {
    // Match the TEXT type from your migration file
    description: DataTypes.TEXT,
    like: { 
      type: DataTypes.INTEGER, 
      defaultValue: 0 // Sync with migration's default value
    }
  }, {});
  Post.associate = function(models) {
    Post.belongsTo(models.User, { foreignKey: 'userID' })
    // Use hasMany if a post can have multiple images (more common for posts)
    Post.hasMany(models.Image, { foreignKey: 'postID' })
    Post.hasMany(models.Comment, { foreignKey: 'postID' })
  };
  return Post;
};

Corrected Image Model #

'use strict';
module.exports = (sequelize, DataTypes) => {
  const Image = sequelize.define('Image', {
    urlImage: DataTypes.STRING
  }, {});
  Image.associate = function(models) {
    Image.belongsTo(models.Post, { foreignKey: 'postID' })
  };
  return Image;
};

2. Update Your Post Creation Logic #

The error null value in column "userID" violates not-null constraint happens because you're not passing the logged-in user's ID when creating a post. You need to retrieve the user ID from your authentication context (e.g., req.user.id if you're using sessions/JWT) and explicitly include it in the create call. Also, fix the nested image creation syntax:

// Example route handler (adjust based on your auth setup)
async function createPost(req, res) {
  try {
    const postInfo = req.body;
    // Get the logged-in user's ID from your auth middleware (e.g., req.user.id)
    const currentUserId = req.user.id;

    // Create post with associated image(s)
    const newPost = await Post.create({
      description: postInfo.description,
      userID: currentUserId, // Required: passes the user ID to the Post table
      // Use plural "Images" since we set up hasMany association
      Images: [{ urlImage: postInfo.urlImage }]
    }, {
      // Include the Image model to create it in the same transaction
      include: [{ model: require('../models/image') }]
    });

    res.status(201).json(newPost);
  } catch (error) {
    console.error(error);
    res.status(500).json({ message: 'Failed to create post' });
  }
}

Notes on Image Association: #

• If you want each post to have only one image, change Post.hasMany(models.Image) to Post.hasOne(models.Image), and use Image: { urlImage: postInfo.urlImage } (singular) in the create call.
• Ensure postInfo.urlImage is a valid file path/URL (e.g., from a file upload middleware like multer).

3. Verify Migration Consistency #

Double-check that your model field types match the migration definitions:

• Your Post migration uses Sequelize.TEXT for description, so update the Post model to use DataTypes.TEXT (already done in the corrected code above).

Why This Works: #

• The foreignKey typo fix ensures Sequelize correctly maps the relationships between tables.
• Explicitly passing userID satisfies the NOT NULL constraint on the Post table.
• Nested creation with include automatically sets the postID on the Image table without you having to manually insert it.

内容的提问来源于stack exchange，提问作者Hoang Quang Hung