SequelizeJS:批量设置外键

const { Sequelize, Model, DataTypes } = require('sequelize');

// 创建Sequelize实例
const sequelize = new Sequelize('database', 'username', 'password', {
  host: 'localhost',
  dialect: 'mysql',
});

// 定义模型
class User extends Model {}
User.init({
  name: DataTypes.STRING,
}, { sequelize, modelName: 'user' });

class Post extends Model {}
Post.init({
  title: DataTypes.STRING,
}, { sequelize, modelName: 'post' });

// 设置外键关系
User.hasMany(Post);
Post.belongsTo(User);

// 批量创建实例并设置外键
(async () => {
  await sequelize.sync({ force: true });

  const user = await User.create({ name: 'John' });
  const posts = await Post.bulkCreate([
    { title: 'Post 1', userId: user.id },
    { title: 'Post 2', userId: user.id },
    { title: 'Post 3', userId: user.id },
  ]);

  console.log(posts);
})();