Sequelize Error on DataTypes.ARRAY(DataTypes.STRING)

Question

I am new to NodeJs development I am using NodeJs with mysql and Sequelize to create a Batch model with these properties.

const Batch = sequelize.define(
  "Batch",
  {
    title: { type: DataTypes.STRING, allowNull: false },
    studentIds: { type: DataTypes.STRING },
    teacherId: { type: DataTypes.STRING, allowNull: true }
  },
  {
    timestamps: false
  }
);

On async method call it is working fine.

Batch.sync().then((res) => {
  console.log("Batch model sync : ", Batch === sequelize.models.Batch);
});

But I need to change

studentIds: { type: DataTypes.ARRAY(DataTypes.STRING)}

Whenever I make this change it gives error

I am using node 14.5.0 MySql 8.0.21 and Sequelize 6.3.4

Eduard · Accepted Answer · 2022-08-22 08:52:49Z

8

DataTypes.ARRAY is not available on Mysql, it's only available on postgres.

Check in official docs: https://sequelize.org/api/v6/class/src/data-types.js~array

edited Aug 22, 2022 at 8:52

answered Aug 10, 2020 at 8:36

Eduard

2,2782 gold badges12 silver badges16 bronze badges

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

1 Comment

radiorz Over a year ago

so on mysql , it should be what when I need array

Simpel · Accepted Answer · 2023-02-02 13:30:57Z

0

With a small workaround you can use your string data as an array. Overwrite the getter and setter of the property of the model

studentIds: {
    type: Sequelize.STRING,
    get() {
      const stringValue = this.getDataValue('studentIds');
      return stringValue ? rawValue.split(',') : null;
    },
    set(value) {
      const arrayValue = value ? value.join(',') : '';
      this.setDataValue('studentIds', arrayValue);
    },
  },

answered Feb 2, 2023 at 13:30

Simpel

1

Collectives™ on Stack Overflow

Sequelize Error on DataTypes.ARRAY(DataTypes.STRING)

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related