无法在 Sequelize.js 上为一对多创建子实例 [英] Unable to create child instance for one-to-many on Sequelize.js

问题描述

我正在使用 sequlize 创建父和子实例，但它引发以下错误.

I am creating parent and child instance using sequlize, but it throws following error.

Site.hasMany(Group,{as:'groups'});
Group.belongsTo(Site);

//not working
Site.create(siteData).then((site)=>{
  site.addGroups(groupData).then(()=>{  //also tried addGroup
    next();
  });
});

//this works
Site.create(siteData).then((site)=>{
 groupData.SiteId=site.id;
 Group.create(groupData).then(()=>{
    next();
 });
});

错误:

未处理的拒绝类型错误:val.replace 不是函数在 Object.SqlString.escape (c:\APi\node_modules\sequelize\lib\sql-string.js:61:15)在 Object.QueryGenerator.escape (c:\APi\node_modules\sequelize\lib\dialects\abstract\query-generator.js:983:22)

Unhandled rejection TypeError: val.replace is not a function at Object.SqlString.escape (c:\APi\node_modules\sequelize\lib\sql-string.js:61:15) at Object.QueryGenerator.escape (c:\APi\node_modules\sequelize\lib\dialects\abstract\query-generator.js:983:22)

推荐答案

假设您有一个任务和不同的日程安排，因此您可以尝试这样的操作并且您可以创建大量日程安排或单个任务也只需将 bulkeCreate 更改为 create

suppose you have a task and different schedule so you can try something like this and you can create the bulk of schedule or single task as well just change bulkeCreate to create

    var ts=req.body.task_time;


    tasks.create(req.body).then(function (taskvalues) {

         //for adding taskId with each object to prepare object for bulk

         for(var i=0;i<ts.length;i++)

         ts[i].taskId = taskvalues.id;

        taskschedule.bulkCreate(ts,{ individualHooks: true }).then(function (allschedule) {

            res.status(200).json({"message":"Post saved successfully"});

        }).catch(function (err) {
            res.status(500).json(err)
        }).catch(function (err) {
            res.status(500).json(err);

        })

    })

taskschedule 的 json 以及帖子正文中为 task 设置的任何值

Your json for taskschedule and whatever value set for task in post body

 "task_time": [
  {
    "shift": "m",
    "date": "01/23/2017",
    "start_time": "2017-01-22 19:00:00",
    "end_time": "2017-01-23 19:00:00",
      "status":"2",
      "user_id":"12"
  },

  {
    "shift": "m",
    "date": "01/23/2017",
    "start_time": "2017-01-22 19:00:00",
    "end_time": "2017-01-23 19:00:00",
      "status":"2",
      "user_id":"12"
  }

],

这篇关于无法在 Sequelize.js 上为一对多创建子实例的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！