sequelize-cli 使用记录

执行上面命令，会生成以下几个文件夹：

• {
    "development": {
      "username": "root",
      "password": "123456",
      "database": "database_development",
      "host": "127.0.0.1",
      "dialect": "mysql"
    },
    "test": {
      "username": "root",
      "password": "123456",
      "database": "database_test",
      "host": "127.0.0.1",
      "dialect": "mysql"
    },
    "production": {
      "username": "root",
      "password": "123456",
      "database": "database_production",
      "host": "127.0.0.1",
      "dialect": "mysql"
    }
  }

  注意：

  $ node_modules/.bin/sequelize db:create

  执行上面命令，会一句

  $ node_modules/.bin/sequelize model:generate --name User --attributes firstName:string,lastName:string,email:string

  执行上面命令会：

  • 在

    $ node_modules/.bin/sequelize db:migrate

    执行上面命令，会在

    $ node_modules/.bin/sequelize seed:generate --name demo-user

    执行上面命令，会在

    'use strict';
    
    module.exports = {
      up: (queryInterface, Sequelize) => {
        return queryInterface.bulkInsert('Users', [{
            firstName: 'John',
            lastName: 'Doe',
            email: 'demo@demo.com'
          }], {});
      },
    
      down: (queryInterface, Sequelize) => {
        return queryInterface.bulkDelete('Users', null, {});
      }
    };

    8. 执行种子文件

    $ node_modules/.bin/sequelize db:seed:all

    执行上面命令，会在

    database_development

    数据库的

    users

    表中插入一条数据。