Sequelize操作MySQL数据库

npm install sequelize-cli -g

npm install sequelize --save

npm install mysql2 --save

sequelize init

//连接数据库
{
  "development": {
    "username": "root",
    "password": null,
    "database": "bilikoa",
    "host": "127.0.0.1",
    "dialect": "mysql"
  },
  "test": {
    "username": "root",
    "password": null,
    "database": "database_test",
    "host": "127.0.0.1",
    "dialect": "mysql"
  },
  "production": {
    "username": "root",
    "password": null,
    "database": "database_production",
    "host": "127.0.0.1",
    "dialect": "mysql"
  }
}

sequelize model:generate --name Article --attributes title:string,content:text

sequelize db:migrate

sequelize seed:generate --name atricle

'use strict';

module.exports = {
  up: async (queryInterface, Sequelize) => {
   
      await queryInterface.bulkInsert('Articles', [
        {
        title: 'John Doe',
        content: '内容。。',
        createdAt: new Date(),
        updatedAt: new Date()
      },
      {
        title: 'John Does',
        content: '内容。。',
        createdAt: new Date(),
        updatedAt: new Date()
      }
    ], {});
    
  },

  down: async (queryInterface, Sequelize) => {
   
      await queryInterface.bulkDelete('People', null, {});
     
  }
};

sequelize db:seed:all