更新剪切板状态

前置内容

1. 【Nodejs express 连接Mysql】: https://www.hyz.cool/articles/207
2. 【Nodejs express 连接 Redis】: https://www.hyz.cool/articles/208
3. 【统一后端返回数据格式——云剪切板】: https://www.hyz.cool/articles/209

路由

• ClipboardController.js

const express = require("express");
const ClipboardController = express.Router();

const ClipboardService = require("../services/ClipboardService")

/**
 * 改变剪切板状态
 */
ClipboardController.post("/status",ClipboardService.changeStatus)

module.exports = ClipboardController;
js

数据库访问

• ClipboardDao.js

import {Query} from "../services/MysqlService";

/**
 * 更新剪切板状态
 * @param id
 * @param userId
 * @param status
 * @returns {Promise<unknown>}
 */
export const changeStatus = (id, userId, status = 0) => {
    return Query("UPDATE `tb_clipboard` SET `status` = ?,`update_time` = NOW() WHERE `id` = ? AND `user_id` = ?", [status, id, userId])
}
js

服务实现

• ClipboardService.js

const Result = require("../utils/Result");
const ClipboardDTO = require("../dtos/ClipboardDTO");

const validator = require("express-validator");

const ClipboardDao = require("../daos/ClipboardDao")
const TokenService = require("../services/TokenService")

/**
 * 修改剪切板状态
 */
export const changeStatus = [
    validator.body("id", "剪切板id不能为空").isLength({min: 1}),
    validator.body("userId", "用户id不能为空").isLength({min: 1}),
    validator.body("status", "状态不能为空").isLength({min: 1}),
    (req, res, next) => {
        //校验参数
        let validationResult = validator.validationResult(req)
        if (!validationResult.isEmpty()) return Result.result(res, Result.invalidParams(validationResult.array()));

        //拿到参数
        let {id, userId, status} = req.body

        status = status === 0 ? 0 : 1

        //检查是否登陆
        TokenService.getLoginUser(req).then(userDTO => {
            //判断是否登陆
            if (!userDTO) return Result.result(res, Result.notLogin());
            //判断id是否一致
            if ((userDTO.id + "") !== (userId + "")) return Result.result(res, Result.noAuth())
            //校验通过，更新状态
            ClipboardDao.changeStatus(id, userId,status).then(result => {
                return Result.result(res, Result.success("修改状态成功!"))
            }).catch(err => {
                console.log("list clipboard error ...", err)
                return Result.result(res, Result.failed("修改状态失败！"))
            })
        }).catch(err => {
            return Result.result(res, Result.failed("检查登陆失败！"))
        })

    }]
js