安裝egg-sequelize

npm install egg-sequelize mysql2 --save // 下載mysql驅(qū)動(dòng)插件
npm install sequelize-cli --save-dev // 下載sequelize管理工具

引入sequelize

• 在 config/plugin.js 中引入 egg-sequelize 插件

'use strict';

/** @type Egg.EggPlugin */
module.exports = {
  // had enabled by egg
  // static: {
  //   enable: true,
  // }
  sequelize:{
    enable:true,
    package:"egg-sequelize"
  }
};

• 在 config/config.default.js 中編寫 sequelize 配置

# 這里連接的是存服務(wù)數(shù)據(jù)的數(shù)據(jù)庫
const config = exports = {
    sequelize: {
      dialect: "mysql",
      host: "localhost", // 數(shù)據(jù)庫地址
      port: '3306',
      database: "test-db", // 數(shù)據(jù)庫名稱
      username: "root",
      password: "",
      timezone: "+08:00", // 東八時(shí)區(qū)
      dialectOptions: {
        useUTC: false // 輸出為東八時(shí)區(qū)，但是不管用
      }
    }
  };

初始化sequelize

• 創(chuàng)建相應(yīng)數(shù)據(jù)庫
• 在 egg 項(xiàng)目中，我們希望將所有數(shù)據(jù)庫 Migrations 相關(guān)的內(nèi)容都放在 database 目錄下，所以我們?cè)陧?xiàng)目根目錄下新建一個(gè) .sequelizerc 配置文件：

# 指定目錄地址
'use strict';

const path = require('path');

module.exports = {
  config: path.join(__dirname, 'database/config.json'),
  'migrations-path': path.join(__dirname, 'database/migrations'),
  'seeders-path': path.join(__dirname, 'database/seeders'),
  'models-path': path.join(__dirname, 'app/model'),
};

• 創(chuàng)建config.js、 migrations、seeders、models

# 創(chuàng)建sequelize配置數(shù)據(jù)庫
npx sequelize init:config
# 創(chuàng)建migrations文件夾
npx sequelize init:migrations
# 創(chuàng)建種子數(shù)據(jù)文件夾
npx sequelize init:seeders
# 創(chuàng)建model文件夾 
npx sequelize init:models

• 創(chuàng)建user數(shù)據(jù)表

npx sequelize migration:generate --name=init-user

在database/migrations文件夾下生成對(duì)應(yīng)js文件

'use strict';

module.exports = {
  up: async (queryInterface, Sequelize) => {
    /**
     * Add altering commands here.
     *
     * Example:
     * await queryInterface.createTable('users', { id: Sequelize.INTEGER });
     */

    const {INTEGER,STRING,DATE} = Sequelize;
    await queryInterface.createTable("user",{
      name:STRING,
      age:INTEGER,
      createAt:DATE,
      updateAt:DATE
    },{
      freezeTableName:true, //強(qiáng)制表明不為復(fù)數(shù)
      paranoid:true, 
    });

  },

  down: async (queryInterface, Sequelize) => {
    /**
     * Add reverting commands here.
     *
     * Example:
     * await queryInterface.dropTable('users');
     */
    await queryInterface.dropTable("user");
  }
};

執(zhí)行命令

npx sequelize db:migrate

完成

• 創(chuàng)建初始數(shù)據(jù)
  執(zhí)行命令

npx sequelize seed:generate --name seed-user

在database/seeders文件夾下生成對(duì)應(yīng)js

'use strict';

module.exports = {
  up: async (queryInterface, Sequelize) => {
    /**
     * Add seed commands here.
     *
     * Example:
     * await queryInterface.bulkInsert('People', [{
     *   name: 'John Doe',
     *   isBetaMember: false
     * }], {});
    */
    return queryInterface.sequelize.transaction(async t => {
      return await queryInterface.bulkInsert("user",[{name:"askwan",age:29},{name:"Bob",age:28}],{transaction:t});
    })

  },

  down: async (queryInterface, Sequelize) => {
    /**
     * Add commands to revert seed here.
     *
     * Example:
     * await queryInterface.bulkDelete('People', null, {});
     */
    return queryInterface.sequelize.transaction(async t => {
      return await queryInterface.bulkDelete("user",null,{transaction:t});
    })
  }
};

sequelize-cli 常用命令

# 通過命令行創(chuàng)建模型，使用 model:generate 命令
# name: 模型名稱
# attributes: 模型的屬性列表
# 創(chuàng)建模型 User, 模型包括屬性 firstName、lastName、email
npx sequelize model:generate --name User --attributes firstName:string,lastName:string,email:string
# 創(chuàng)建模型 Role, 模型包括屬性 roleName
npx sequelize model:generate --name Role --attributes roleName:string

# 數(shù)據(jù)庫遷移
npx sequelize db:migrate
# 撤銷上一次遷移操作
# 可使用 --name xxx 指定具體遷移
npx sequelize db:migrate:undo
# 撤銷所有遷移操作
npx sequelize db:migrate:undo:all

# 創(chuàng)建種子，用于生成測(cè)試數(shù)據(jù)
npx sequelize seed:generate --name demo-role
npx sequelize seed:generate --name demo-user
# 插入演示數(shù)據(jù)到數(shù)據(jù)庫種
npx sequelize db:seed:all
# 撤銷指定種子文件
npx sequelize db:seed:undo --seed 指定種子文件
# 撤銷所有種子文件
db:seed:undo:all