获取公开剪切板

前置内容

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.get("/public",ClipboardService.listPublicClipboard)


module.exports = ClipboardController;
js

数据库访问

• ClipboardDao.js

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

/**
 * 获取公开剪切板列表
 * @param userId
 * @returns {Promise<unknown>}
 */
export const listPublicClipboard = (userId) => {
    return Query("SELECT * FROM `tb_clipboard` WHERE `user_id` = ? AND `status` = 1 ORDER BY `create_time` DESC ", [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 listPublicClipboard = [
    validator.query("userId", "用户id不能为空").isLength({min: 1}),
    (req, res, next) => {

        //校验参数
        let validationResult = validator.validationResult(req)
        if (!validationResult.isEmpty()) return Result.result(res, Result.invalidParams(validationResult.array()));

        //拿到参数
        let {userId} = req.query

        //查询
        ClipboardDao.listPublicClipboard(userId).then(result => {
            //格式化一下
            result = result.map(item => new ClipboardDTO(item))
            return Result.result(res, Result.success(result))
        }).catch(err => {
            console.log("list clipboard error ...", err)
            return Result.result(res, Result.failed("获取用户公开剪切板数据失败！"))
        })
    }]
js