FAQ.md

The Sequelize Command Line Interface (CLI) Frequently Asked Question

Initialize sequelize to create necessary files in the project

$ sequelize init

How can I generate a model?

Specify model name with --name argument. List of table fields can be passed with --attributes option (comma separated with no spaces at all)

$ sequelize model:create --name User --attributes name:string,state:boolean,birth:date,card:integer,role:enum:'{Admin,Guest}'

How can I create a migration?

Specify migration name with --name argument

$ sequelize migration:create --name <migration_name>

What is the command to execute all migrations?

$ sequelize db:migrate

How can I make a migrations rollback?

$ sequelize db:migrate:undo:all

How can I create a seeder?

Specify seeder name with --name argument

$ sequelize seed:create --name <seeder_name> 

How can I run the seeders?

$ sequelize db:seed:all

How can I make the seeders rollback?

$ sequelize db:seed:undo:all

I am getting an error when attempting to create a model with an enum type.

The brackets {} likely need to be quoted in your shell or there needs to be a space between the values

sequelize model:create --name User --attributes role:enum:'{Admin,Guest}'

or

sequelize model:create --name User --attributes role:enum:'{Admin, Guest}'

or possibly

sequelize model:create --name User --attributes role:enum:\{Admin,Guest\}