node.js - Unable to create child instance for one-to-many on Sequelize.js -

-

i creating parent , child instance using sequlize, 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();  }); });

error:

unhandled rejection typeerror: val.replace not function @ 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)

suppose have task , different schedule can try and can create bulk of schedule or single task change bulkecreate create

    var ts=req.body.task_time;       tasks.create(req.body).then(function (taskvalues) {           //for adding taskid each object prepare object 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);          })      })

your json taskschedule , whatever value set 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"   }  ],

Comments

Post a Comment

Popular posts from this blog

Hatching array of circles in AutoCAD using c# -

-
i beginner in autocad plugins .i have created array of circle using following code. now, have hatch circles in array .how that??how hatch circles @ once? moreover, how can return hatch method , use hatch objects.sorry language.thanks in advance. [assembly: commandclass(typeof(beamsection.class1))] namespace beamsection { public class class1 { //class1 obj = new class1(); [commandmethod("beamatsupport")] public void addlightweightpolyline() { // current document , database document acdoc = application.documentmanager.mdiactivedocument; database accurdb = acdoc.database; promptpointresult ppr = acdoc.editor.getpoint("\nselect starting point "); var ucs = acdoc.editor.currentusercoordinatesystem; point3d startingpt = ppr.value.transformby(ucs); list<double> radius = new list<double>(); radius.add(0.5);
Read more

ios - UITEXTFIELD InputView Uipicker not working in swift -

-
hello trying pop uipickerview view programmatically when user clicks on textfield. have tried doesn't doing anything. isn't working. nothing happening when click textfield class userprofiletableviewcontroller: uitableviewcontroller,uitextfielddelegate,uipickerviewdelegate,uipickerviewdatasource { var itempicker: uipickerview! = uipickerview() @iboutlet weak var gendertxtfield: uitextfield! var gender = ["male","female"] override func viewdidload() { super.viewdidload() gendertxtfield.delegate = self itempicker!.delegate = self itempicker!.datasource = self itempicker!.backgroundcolor = uicolor.blackcolor() self.gendertxtfield.inputview = itempicker } func numberofcomponentsinpickerview(pickerview: uipickerview) -> int{ return 1 } // returns # of rows in each component.. func pickerview(pickerview: uipickerview, numberofrowsincomponent component:
Read more

Python Pig Latin Translator -

-
so have been working on @ codecademy.com while trying learn python. don't know if blind , can't see why won't work or what. here's code won't let me use. function print variable if had typed in , print "empty" if didn't type anything. print "welcome english pig latin translator!" original = raw_input("what's name?") if len(original) > 0 print original else print "empty" if len(original) > 0 else the above lines contains syntax errors. try: if len(original) > 0: else: note added colons, ( : ).
Read more