如何在 SequelizeJS 中设置创建时通过模型的额外属性?

2022-01-19 00:00:00 javascript sequelize.js

我的模特:

 Recipe (id, name)
 Ingredient (id, name)
 Recipe_Ingredient (recipeId, ingredientId, quantity)

我的联想:

Recipe.belongsToMany(Ingredient, { through: Recipe_Ingredient })
Ingredient.belongsToMany(Recipe, { through: Recipe_Ingredient })

我的问题:

我如何创建一个包含一些成分和数量的食谱?

How can I create a Recipe with some Ingredients and the quantities attached to them?

我试过了:

Recipe.create({
  name: 'Pizza',
  ingredients:[
    {
      name: 'mozarella',
      recipe_ingredients: {
          quantity: 5
      }
    }
  ]
}, {
    include:[Ingredient]
})

为配方、成分和配方_成分创建记录.唯一的问题是数量的值不是从数据源收集的.

Records are created for Recipe, Ingredient and the Recipe_Ingredient. The only problem is that the value of the quantity is not collected from the data source.

推荐答案

过去无法做到这一点，但在 2018 年 10 月 23 日，这在 sequelize PR #10050.

It was not possible to do this in the past, but in October 23, 2018 this was fixed in sequelize PR #10050.

截至今天 (2018-10-24)，修复程序尚未发布，但只要 v5.0.0-beta14 发布，您就可以执行以下操作:

As of today (2018-10-24) the fix is not released yet, but as soon as v5.0.0-beta14 comes out, you'll be able to do the following:

Recipe.create({
    name: 'Pizza',
    ingredients: [
        {
            name: 'mozarella',
            recipe_ingredient: {
                quantity: 5
            }
        }
    ]
}, {
    include: Ingredient
})

另外，请注意正确的用法是单数形式的 recipe_ingredient:，而不是您在问题中尝试的复数形式.这是有道理的，因为对于给定的成分，与给定的食谱相关联，总是只涉及一个 Recipe_Ingredient.

Also, note that the correct usage is recipe_ingredient: in the singular form, not in the plural form as you tried in your question. This makes sense, because for a given Ingredient, associated with a given Recipe, there is only one Recipe_Ingredient involved, always.

如果你不想等待 v5.0.0-beta14(虽然它可能很快就会发布)，你可以直接从 github 的 master 分支安装它如下:

If you do not want to wait for v5.0.0-beta14 (although it will probably be released very soon), you can install it directly from github's master branch as follows:

npm install --save https://github.com/sequelize/sequelize/tarball/master

相关文章