Invalid field error on Sequelize bulkInsert method for Array of nested JSONB fields

Question

I have a metadata column in my sequelize Notifications model

metadata: { type: DataTypes.ARRAY(DataTypes.JSONB) }

I want to do a bulkInsert for the notifications table using a seeder file but each time, I get an invalid field error.

below is my seeder code

module.exports = {
  up: async (queryInterface, Sequelize) => {
    const notificationsData = [{
      id: 1,
      metadata: [
        {
          foo: 0,
          bar: 0.0014423,
          baz: {
            lorem: 987,
            ipsum: 'sample data',
            type: 'sample data',
            address: 'sample data'
          }
        },
        {
          foo: 10,
          bar: 2.423,
          baz: {
            lorem: 238,
            ipsum: 'sample data',
            type: 'sample data',
            address: 'sample data'
          }
        }
      ]
    }];
    await queryInterface.bulkInsert('Notifications', notificationsData, {});
  },

  down: async (queryInterface, Sequelize) => {
    await queryInterface.bulkDelete('Notifications', null, {});
  },
};

On further research I discovered that sequelize has a parsing issue with JSON-related fields on bulkInsert and bulkCreate.

Is there any workaround for this?

Isn't enough two workarounds in the mentioned issue?

Anatoly
– Anatoly

2023-10-02 17:53:02 +00:00
Commented Oct 2, 2023 at 17:53 — Anatoly
– Anatoly, Commented Oct 2, 2023 at 17:53

Austin · Accepted Answer · 2023-10-02 20:39:58Z

0

I was able to fix the issue by modifying the bulkInsert script as follows

await queryInterface.bulkInsert('Notifications', notificationsData, {}, {
   metadata: { type: Sequelize.ARRAY(Sequelize.JSONB) }
});

answered Oct 2, 2023 at 20:39

Austin

4341 gold badge11 silver badges21 bronze badges

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

Collectives™ on Stack Overflow

Invalid field error on Sequelize bulkInsert method for Array of nested JSONB fields

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