sequelize : cannot seed association values in DB table

Question

I am trying to seed an association into my db using sequelize, the tables being: Users and Admins. For this I am relying on this answer on the forum. so here is my seed:

'use strict';
const bcrypt = require('bcryptjs')
module.exports = {
    up: async (queryInterface, Sequelize) => {
        queryInterface.bulkInsert('Users', [{
            firstName: 'someone',
            lastName: 'awesome',
            email: 'someone@somewhere.com',
            password: bcrypt.hashSync('helloWorld', 8),
            type: 'admin',
            createdAt: new Date(),
            updatedAt: new Date()
        }], {});

        const users = await queryInterface.sequelize.query(
            'SELECT id from Users;'
        );

        return await queryInterface.bulkInsert('Admins', [{
            id: users[0].id,
            phone: '+9999999999',
            status: true, createdAt: new Date(),
            updatedAt: new Date()
        }]);
    },
    down: async (queryInterface) => {
        await queryInterface.bulkDelete('Admins', null, {});
        await queryInterface.bulkDelete('Users', null, {});
    }
};

now, The data in user table is field up perfectly but the admin table remains empty

EDIT:

I tried to print out the users[0].id with the following code:

const users = await queryInterface.sequelize.query(
    "SELECT id from Users"
);

console.log(users[0].id)

the output was undefined

but the data was once again fed to the table! I know what is happening here, but don't know how to resolve!

P.S. I also added await for the very first method of the up, but this changed nothing..

score 5 · Answer 1 · edited Jul 09 '20 at 17:38

It took a while to figure this out, Thank you all.

literature I referred to: this question AND this part of official sequelize documentation

Here is the code that works:

'use strict';
const bcrypt = require('bcryptjs');
const models = require('../models');
const User = models.User;
module.exports = {
    up: async (queryInterface, Sequelize) => {
        queryInterface.bulkInsert('Users', [{
            firstName: 'aname',
            lastName: 'alastname',
            email: 'someemail@somewhere.com',
            password: bcrypt.hashSync('poochies', 8),
            type: 'admin',
            createdAt: new Date(),
            updatedAt: new Date()
        }], {});

        const user = await User.findOne({
            where: {
                type: 'admin',
                email: 'someemail@somewhere.com'
            },
        });

        return await queryInterface.bulkInsert('Admins', [{
            id: user.id,
            phone: '+999999999999',
            status: true,
            createdAt: new Date(),
            updatedAt: new Date()
        }], {});
    },
    down: async (queryInterface) => {
        await queryInterface.bulkDelete('Admins', null, {});
        await queryInterface.bulkDelete('Users', null, {});
    }
};

Aramil Rey · Accepted Answer · 2018-09-07T18:34:49.697

1

You are not waiting for the users insert to end before querying for them, so this:

const users = await queryInterface.sequelize.query(
   'SELECT id from Users;'
);

Is empty, and this users[0].id must be throwing a type error

Adding an await to your first queryInterface.bulkInsert should fix that

await queryInterface.bulkInsert('Users', [{ // ...

edited Sep 07 '18 at 18:34

answered Sep 07 '18 at 18:33

Aramil Rey

3,387
1
19
30

Sorry, I was still edditing the soultion. Using `await` on the first `bulkInsert` should do it! – Aramil Rey Sep 07 '18 at 18:37
I did that, yet, the cli is responding with : `ERROR: Column 'id' cannot be null` ! but the data has been inserted into Users table – sameer manek Sep 07 '18 at 18:39
Maybe you could log the contents of `users` to see what that query is returning – Aramil Rey Sep 07 '18 at 18:43
You are almost there, with some more debugging and coding, your code will be doing what you expect. My hint is this: check the contents of `users`, not only `users[0].id`, good luck! – Aramil Rey Sep 07 '18 at 20:26
found the answer and posted it below on this thread! Thanks a lot – sameer manek Sep 08 '18 at 10:39

score 0 · Answer 3 · answered Nov 25 '19 at 20:43

You need to add await to the first bulkInsert method call and save its results into userId variable. The bulkInsert promise is resolved with the first ID of inserted sequence, so you can use it to create an admin like this:

'use strict';
const bcrypt = require('bcryptjs');

module.exports = {
    up: async (queryInterface, Sequelize) => {
        const userId = await queryInterface.bulkInsert('Users', [{
            firstName: 'someone',
            lastName: 'awesome',
            email: 'someone@somewhere.com',
            password: bcrypt.hashSync('helloWorld', 8),
            type: 'admin',
            createdAt: new Date(),
            updatedAt: new Date()
        }], {});

        return queryInterface.bulkInsert('Admins', [{
            id: userId,
            phone: '+9999999999',
            status: true,
            createdAt: new Date(),
            updatedAt: new Date(),
        }]);
    },
    down: async (queryInterface) => {
        await queryInterface.bulkDelete('Admins', null, {});
        await queryInterface.bulkDelete('Users', null, {});
    }
};

score 0 · Answer 4 · answered Sep 22 '20 at 17:40

You can receive an array of the inserted objects and use it in the admin insertion.

let ids = await queryInterface.bulkInsert('Users', [{
                    firstName: 'someone',
                    lastName: 'awesome',
                    email: 'someone@somewhere.com',
                    password: bcrypt.hashSync('helloWorld', 8),
                    type: 'admin',
                    createdAt: new Date(),
                    updatedAt: new Date()
                }], { returning: ['id'] });

let adminId = ids[0];

//Insert admin

Be aware that the "returning" option is only available with Postgres SQL. — rob-art, Jan 11 '23 at 09:15

sequelize : cannot seed association values in DB table

4 Answers4

Linked