# sequelize

**Repository Path**: interview-highlights/sequelize

## Basic Information

- **Project Name**: sequelize
- **Description**: No description available
- **Primary Language**: Unknown
- **License**: Not specified
- **Default Branch**: master
- **Homepage**: None
- **GVP Project**: No

## Statistics

- **Stars**: 0
- **Forks**: 0
- **Created**: 2021-05-23
- **Last Updated**: 2021-05-23

## Categories & Tags

**Categories**: Uncategorized

**Tags**: None

## README


## 前提依赖
npm install sequelize -S
npm install mysql2 -S
npm install sequelize-cli -g
## 目录结构
config -> 数据库配置
migrations -> 迁移
models -> 模型(对应数据库的表)
seeders -> 种子
## 创建数据库
sequelize db:create --charset 'utf8mb4'
## 创建模型
sequelize model:generate --name Article --attributes title:string,content:text
## 迁移
sequelize db:migrate
## 新建一个种子文件
sequelize seed:generate --name article
```
// 并修改成以下内容
"use strict";
​
module.exports = {
  up: async (queryInterface, Sequelize) => {
    await queryInterface.bulkInsert(
      "Articles",
      [
        {
          title: '111',
          content: "John Doe",
          createdAt: new Date(),
          updatedAt: new Date()
        },
        {
          title: '2222',
          content: "John Doe",
          createdAt: new Date(),
          updatedAt: new Date()
        }
      ],
      {}
    );
  },
​
  down: async (queryInterface, Sequelize) => {
    await queryInterface.bulkDelete("Articles", null, {});
  },
};
```
// 添加数据
sequelize db:seed:all