node.js - 多对多关系 Sequelize Node JS 属性数组

Question

我有一个工作模型

    module.exports = (sequelize, Datatypes) => {
  const Jobs = sequelize.define('Jobs', {
    jobinput: {
      type: Datatypes.STRING
    },
    typeinput: {
      type: Datatypes.STRING
    },
    jobdescinput: {
      type: Datatypes.TEXT('medium')
    },
    locationinput: {
      type: Datatypes.STRING
    },
    salarymininput: {
      type: Datatypes.INTEGER
    },
    salarymaxinput: {
      type: Datatypes.INTEGER
    },
    seniorityinput: {
      type: Datatypes.STRING
    },
    vacancyinput: {
      type: Datatypes.INTEGER
    },
    bountyinput: {
      type: Datatypes.INTEGER
    }
  })
  Jobs.associate = function (models) {
    Jobs.belongsTo(models.User)
    Jobs.belongsTo(models.Company)
    Jobs.belongsToMany(models.JobSkills, { through: models.JobHasSkills, foreignKey: 'JobId' })
  }

  return Jobs
}

和工作技能模型

module.exports = (sequelize, Datatypes) => {
  const JobSkills = sequelize.define('JobSkills', {
    skill: {
      type: Datatypes.STRING,
      unique: true
    }
  })
  JobSkills.associate = function (models) {
    JobSkills.belongsToMany(models.Jobs, { through: models.JobHasSkills, foreignKey: 'JobSkillId' })
  }
  return JobSkills
}

和多对多的 JobHasSkills 模型

module.exports = (sequelize, Datatypes) => {
  const JobHasSkills = sequelize.define('JobHasSkills', { })
  JobHasSkills.associate = function (models) {
    JobHasSkills.belongsTo(models.Jobs)
    JobHasSkills.belongsTo(models.JobSkills)
  }
  return JobHasSkills
}

我试图做一个创建功能

async create (req, res) {
   try {
     await Jobs.create(req.body, { include: { model: JobSkills } })
       .then(function (createdObjects) {
         res.json(createdObjects)
       })
   } catch (err) {
     res.status(500).send({
       error: 'an error has occured while posting'
     })
   }
 }

我通过 postman 发送的 Json 数据是

    { "jobinput": "Title",
     "typeinput": "Part Time",
     "jobdescinput": "lorem ipsum",
     "locationinput": "California",
     "salarymininput": "0",
     "salarymaxinput": "1000",
     "seniorityinput": "Internship",
     "vacancyinput": "1",
     "bountyinput": "10",
     "skills": ["skill1","skill2","skill3" ] 
   }

我检查了这个答案 Trying to create an instance and multiple related instances in a many to many relationship

但我得到了捕获(错误)。
这是我第一个使用 node js 和 sequelize 的项目。谁可以帮我这个事

Answer 1

如果您的表没有被创建，请使用 -

 sequelize.define(
    "Table Name"
    {
      Model Definations
    },
    {
        underscored: false,// Not Required in your case
        timestamps: false// Not Required in your case
    }
).sync({ force: true });

创建表后，请注释 Sync 选项，否则在每次重新启动时，表将被删除并重新创建。