How can I have a datatype of array in mysql Sequelize instance?

Question

I am building an application that uses Node/Express and MySQL with Sequelize as the ORM. I want to have a datatype of Array, but the sequelize docs says this is limited to postgres only.

Basically, if I have a users table that has 3 columns for example (name, phone, favColors), I want favColors to get populated with an array of string values retrieved from the user. How can I do this?

Thanks @Adam, I was going to just store the data as a STRING, and then split the values later, but I thought there may be a less hacky way. — johnny_mac
– johnny_mac, Commented Jan 26, 2017 at 8:19

Dregg · Accepted Answer · 2021-11-19 08:50:35Z

45

You can use getter/setter functions for this:

favColors: {
    type: Sequelize.STRING,
    allowNull: false,
    get() {
        return this.getDataValue('favColors').split(';')
    },
    set(val) {
       this.setDataValue('favColors',val.join(';'));
    },
}

more info: https://sequelize.org/master/manual/getters-setters-virtuals.html

edited Nov 19, 2021 at 8:50

Dregg

6738 silver badges18 bronze badges

answered Jan 26, 2017 at 8:22

Adam

5,2933 gold badges33 silver badges64 bronze badges

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

Comments

Gideão · Accepted Answer · 2021-02-25 11:12:08Z

15

You can define your field as json:

type: Sequelize.JSON

And then save the data as an array

answered Feb 25, 2021 at 11:12

Gideão

3783 silver badges5 bronze badges

2 Comments

Jose Javier Sanahuja Over a year ago

I wanted to implement this idea, but the vsCode's intellisense adviced that it was only for postgreSQL. So I didn´t even tried

Gideão Over a year ago

Yep, there are some kinds of data types that work only with some kinds of databases. You can read this doc to see if you can use or not a specific datatype.

nhaht · Accepted Answer · 2022-09-20 01:22:38Z

4

This worked for me:

tags: {
    type: Sequelize.ARRAY(Sequelize.TEXT),
    defaultValue: [],
}

answered Sep 20, 2022 at 1:22

nhaht

1,25714 silver badges22 bronze badges

1 Comment

Jess Over a year ago

This worked with a MYSQL database?

Njoli Patrick · Accepted Answer · 2023-07-30 23:33:24Z

0

favColors: {
    type: Sequelize.JSON
}

if you're using typescript you could set the type as

favColors: string[]

answered Jul 30, 2023 at 23:33

Njoli Patrick

1031 silver badge5 bronze badges

Collectives™ on Stack Overflow

How can I have a datatype of array in mysql Sequelize instance?

4 Answers 4

Comments

2 Comments

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

2 Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related