Nodejs全栈入门-慕课网

/* jshint esversion: 8 */
const express = require('express')
const router = express.Router()

const models = require('../db/models')

/**
 * [model:Todo]
 * sequelize
 * Sequelize
 */

/**
 * 查询任务列表
 */
router.get('/list/:status/:page',  async (req, res,next)=>{
  // 1. 状态 1：表示待办， 2：完成，3：删除，-1：全部
  // 2. 分页的处理
  let {status,page} = req.params;
  let limit = 10;
  let offset = (page-1)*limit;
  let where = {};
  if (status != -1) {
    where.status = status;
  }
  let list = await models.Todo.findAndCountAll({
    where,
    limit,
    offset
  })
  res.json({
    list,
    message: '列表查询成功'
  })
})

/**
 * 创建一个todo任务
 */
router.post('/create',async (req,res,next)=>{
  try {
    let { name, deadline, content } = req.body;
    let todo = await models.Todo.create({
      name,
      deadline,
      content
    })
    res.json({
    todo,
    message: '任务创建成功!'
    })
  } catch (error) {
    next(error)
  }
})

/**
 * 修改一个todo任务
 */
router.post('/update', async (req,res,next)=>{
  try {
    let { id, name, deadline, content } = req.body;
    let todo = await models.Todo.findOne({
      where: {
        id
      }
    })
    if (!todo) {
      return res.json({
        message: `任务${id}不存在`
      })
    }
    // 执行任务更新
    todo = await todo.update({
      name,
      deadline,
      content
    })
    res.json({
      todo,
      message: '修改任务成功'
    })
  } catch (error) {
    next(error)
  }
})

/**
 * 修改一个todo任务的状态
 * 修改任务的状态 （ID/状态--待办/完成）
 */
router.post('/update_status', async (req,res,next)=>{
  try {
    let { id, status } = req.body;
    let todo = await models.Todo.findOne({
      where: {
        id
      }
    })
    if (todo && status != todo.status) {
      // 执行更新
      todo = await todo.update({
        status
      })
    } else {
      return res.json({
        message: `任务${id}不存在或者修改的status和原来的status相同!`
      })
    }
    res.json({
      todo
    })
  } catch (error) {
    next(error)
  }
 
})

/**
 * 删除一个todo任务
 */
router.delete('/delete/:id', async (req,res,next)=>{
  try {
    let { id } = req.params;
    let todo = await models.Todo.findOne({
      where: {
        id
      }
    })
    if (!todo) {
      return res.json({
        message: `任务${id}不存在`
      })
    }
    if (todo) {
      // 执行更新
      todo = await todo.destroy({
      })
    }
    if (todo == null) {
      res.json({
        message: `任务${id}删除成功`
      })
    }
  } catch (error) {
    next(error)
  }
})

module.exports = router

### 使用RestClient VSCode插件进行后端API接口测试
@baseurl = http://127.0.0.1:3000

### 根路径接口测试
GET  {{baseurl}}

### 获取status为2，page为1的任务列表数据
GET {{baseurl}}/todo/list/2/1

### 获取所有的任务数据（status为-1，page为2的任务列表数据）
GET {{baseurl}}/todo/list/-1/2

### 发送JSON数据

### 新增任务
POST {{baseurl}}/todo/create
Content-Type: application/json

{
    "name": "修手机",
    "deadline": "2020-08-23 17:00:00",
    "content": "帮老板修手机 下午5点前要完成"
}

### 修改任务
POST {{baseurl}}/todo/update
Content-Type: application/json

{
     "id": 5,
     "name": "学习任务005",
     "deadline": "2020-08-23T07:16:00.000Z",
     "content": "帮助小明补习功课"
}


### 修改任务的状态 

POST {{baseurl}}/todo/update_status
Content-Type: application/json

{
    "id": 8,
    "status": 3
}

### 删除一个id为8的任务
DELETE {{baseurl}}/todo/delete/8

git clone https://github.com/ccf19881030/todo_api.git

npm install

npm start

{
  "development": {
    "username": "root",
    "password": "123456",
    "database": "todo_development",
    "host": "127.0.0.1",
    "dialect": "mysql",
    "timezone": "+08:00"
  },
  "test": {
    "username": "root",
    "password": "123456",
    "database": "todo_development",
    "host": "127.0.0.1",
    "dialect": "mysql"
  },
  "production": {
    "username": "root",
    "password": "123456",
    "database": "todo_development",
    "host": "127.0.0.1",
    "dialect": "mysql"
  }
}