eggjs sequelize 命令

个人用，详细配置可访问 egg.js + sequelize-cli + mysql 实战

创建和删除数据库

常用

npx sequelize db:migrate:undo:all
npx sequelize db:migrate 
npx sequelize db:seed:undo:all
npx sequelize db:seed:all

 # 设置数据库默认编码为utf8
npx sequelize db:create --charset 'utf8'
npx sequelize db:drop

同时创建模型和迁移文件

# create 和 generate 都可以
# 如果表的字段很多的话, 那么命令行就写一两个, 后面可以在文件里面更改
npx sequelize model:create --name xxx--attributes username:string,password:string

迁移文件

# 创建迁移文件
npx sequelize migration:generate --name=xxx

# 运行迁移文件生成数据表
npx sequelize db:migrate 

# 撤销上一次迁移
npx sequelize db:migrate:undo
# 撤销指定迁移
npx sequelize db:migrate:undo --name xxx
# 撤销所有迁移 
npx sequelize db:migrate:undo:all

种子文件

# 创建种子文件
npx sequelize seed:create --name xxx

# 如果运行过一次, 再次运行就会报错, 除非删除上一次填充的种子文件
npx sequelize db:seed:all # 也可以指定文件命令和迁移命令类似
npx sequelize db:seed --seed xxx
# 撤销所有种子
npx sequelize db:seed:undo:all

字段属性

// 迁移文件 设计数据表的
{
	allowNull: false, // 是否允许为空
	autoIncrement: true, // 字段是否是自增类型
	primaryKey: true, // 字段是否是主键
	type: Sequelize.INTEGER // 字段是整型
    defaultValue: null, // 字段默认值
    unique: true // 唯一索引
}

sequelize --help

$ sequelize --help

Sequelize CLI [Node: 8.9.0, CLI: 3.2.0, ORM: 4.8.0]

WARNING: This version of Sequelize CLI is not fully compatible with Sequelize v4. https://github.com/sequelize/cli#sequelize-support

Commands:
  db:migrate                        Run pending migrations
  db:migrate:schema:timestamps:add  Update migration table to have timestamps
  db:migrate:status                 List the status of all migrations
  db:migrate:undo                   Reverts a migration
  db:migrate:undo:all               Revert all migrations ran
  db:seed                           Run specified seeder
  db:seed:undo                      Deletes data from the database
  db:seed:all                       Run every seeder
  db:seed:undo:all                  Deletes data from the database
  db:create                         Create database specified by configuration
  db:drop                           Drop database specified by configuration
  init                              Initializes project
  init:config                       Initializes configuration
  init:migrations                   Initializes migrations
  init:models                       Initializes models
  init:seeders                      Initializes seeders
  migration:generate                Generates a new migration file  [aliases: migration:create]
  model:generate                    Generates a model and its migration  [aliases: model:create]
  seed:generate                     Generates a new seed file  [aliases: seed:create]

Options:
  --version  Show version number  [boolean]
  --help     Show help  [boolean]