Not able to create ENUM type attribute using sequelize cli

Question

Trying to create a model that has an enum field with certain values using Sequelize CLI.

sequelize model:generate --name user --attributes name:string,login_method:enum('email','google')

Error: bash: syntax error near unexpected token `('

What is the right syntax to do so?

Yumi Ko · Accepted Answer · 2021-01-21 15:17:50Z

6

https://github.com/sequelize/cli/blob/master/docs/FAQ.md

try

npx sequelize-cli model:generate --name user --attributes name:string,login_method:enum:'{email,google}'

edited Jan 21, 2021 at 15:17

answered Jan 21, 2021 at 12:10

Yumi Ko

611 silver badge5 bronze badges

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

3 Comments

Yumi Ko Over a year ago

@AkashElhance What message do you see when you run the command?

Akash Elhance Over a year ago

ERROR: Attribute 'Status_Name:enum:'{Completed,Pending}'' cannot be parsed: Unknown type ''{Completed,Pending}''

Yumi Ko Over a year ago

@AkashElhance I have tried

npx sequelize-cli model:generate --name user --attributes name:string,login_method:enum:'{email,google}',Status_Name:enum:'{Completed,Pending}'

and I don't see error

Brian · Accepted Answer · 2021-10-19 19:07:13Z

2

you can do it with

model:generate --name User --attributes 'login_method:enum:{google,facebook}'

Another good example is:

npx sequelize-cli model:generate --name devicelogs --attributes 'type:enum:{embedded,console,wearable,smarttv,browser,tablet,mobile}','browser:enum:{Chrome,Firefox,Safari,Opera,Internet Explorer,Edge,Edge Chromium,Yandex,Chromium,Mobile Safari,Samsung Browser}'

from sequelize-cli code you can also try

first_name:string,last_name:string,bio:text,role:enum:{Admin, 'Guest User'},reviews:array:string
'first_name:string, last_name:string, bio:text, role:enum:{Admin, Guest User} reviews:array:string'

edited Oct 19, 2021 at 19:07

Brian

9619 silver badges21 bronze badges

answered Jun 6, 2021 at 21:20

Tarekkhaled

212 bronze badges

Comments

Arpit Vyas · Accepted Answer · 2020-06-09 05:10:11Z

0

It should be possible to create enum values from model:create command

you can do like this .

$ sequelize model:create --name User --attributes opts:enum(x,y,z)

hope this help .

edited Jun 9, 2020 at 5:10

answered Jun 9, 2020 at 5:02

Arpit Vyas

2,2671 gold badge10 silver badges21 bronze badges

1 Comment

Arpit Vyas Over a year ago

@RAJKIRANSINGH is this helped you ?

Aum Trivedi · Accepted Answer · 2020-06-11 05:20:08Z

0

Try this one:

npx sequelize model:create --name User --attributes 'opts:enum:{x,y,z}'

Or

sequelize model:create --name User --attributes 'opts:enum:{x,y,z}'

Hope this will help you.

answered Jun 11, 2020 at 5:20

Aum Trivedi

1474 bronze badges

Comments

sunny yadav · Accepted Answer · 2023-01-10 08:04:44Z

0

npx sequelize-cli model:generate --name User --attributes username:string,email:string,password:string,role:ENUM("users","admin")

instead or writing this try this

npx sequelize-cli model:generate --name User --attributes username:string,email:string,password:string,role:enum:'{users,admin}'

answered Jan 10, 2023 at 8:04

sunny yadav

11 bronze badge

Collectives™ on Stack Overflow

Not able to create ENUM type attribute using sequelize cli

5 Answers 5

3 Comments

Comments

1 Comment

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

3 Comments

Comments

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related