sequelize.js with nested Insert

Question

I am working with sequelize.js, Where I have a table (say User) with different string fields and a many-to-many relation with another table (say Nationality).

I am trying to insert a new row of User with all the sub-element and the nationality, in one single instruction. Now I am doing like this:

models.Nation.create({codice:"IT",name:"Italia"}).then(function(italy){
      models.User.create({username:"local_u",nation:italy}).then(function(){

     });
});

If I look at the database, at the newly created User row: the fieldNationId` is not set.

I know I can use the function setNation of sequelize, but I wonder if I can do it within one single User.create.

btw you need to return the second one. return models.User.create... — Louay Alakkad
– Louay Alakkad, Commented Dec 26, 2015 at 17:28
huh, interesting! Is it necessary? or just philosophically required? because things are working without the return — Antonio Ragagnin
– Antonio Ragagnin, Commented Dec 26, 2015 at 17:42
it's necessary, so no errors would go undetected. currently the Nation.create promise won't catch errors in User.create. Bluebird should warn you about this already. — Louay Alakkad
– Louay Alakkad, Commented Dec 26, 2015 at 17:43

belyid · Accepted Answer · 2016-08-11 16:45:56Z

1

Yes you can create the user entity with nation in one step using include. Something like this (code not tested):

models.Nation.create({ codice: "IT", name: "Italia" }).then(function (italy) {
    models.User.create({
        username: "local_u",
        nation: italy

    }, {
            include: [models.nation]
        }
    ).then(function () {/*Do Something*/});
});

It's an old question but hopefully will help someone.

answered Aug 11, 2016 at 16:45

belyid

8712 gold badges12 silver badges29 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

sequelize.js with nested Insert

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related