node+koa框架开发服务器之定时器

定时器

• app.js

/**
 * 定时任务
*/
const schedule = require('node-schedule')
const script = require('./util/script')
/** 定义规则,cron表达式*/
// *  *  *  *  *  *
// ┬ ┬ ┬ ┬ ┬ ┬
// │ │ │ │ │  |
// │ │ │ │ │ └ day of week (0 - 7) (0 or 7 is Sun)
// │ │ │ │ └───── month (1 - 12)
// │ │ │ └────────── day of month (1 - 31)
// │ │ └─────────────── hour (0 - 23)
// │ └──────────────────── minute (0 - 59)
// └───────────────────────── second (0 - 59, OPTIONAL)
let rule = new schedule.RecurrenceRule()
/**每天的凌晨2点去执行了clearLogger方法*/
rule.hour = 2
rule.minute = 0
rule.second = 0
/**启动任务*/
schedule.scheduleJob(rule, () => {
  script.clearLogger()
})
/**每周1凌晨1点1分执行清理任务*/
schedule.scheduleJob('0 1 1 * * 1', () => {
  script.clearRubbishImg()
})
/**

• 定时任务，分别是清楚废弃图片和定时清理日志

//script.js
const db = require("../controllers/mysql");
const fs = require("fs");
const path = require("path");
const logger = require("../controllers/logger");
const script = {
  /** 清除30天之前的日志*/
  async clearLogger() {
    const start = new Date();
    let time_30 = (
      (new Date().getTime() - 60 * 60 * 24 * 30 * 1000) /
      1000
    ).toFixed(0);
    let _sql = `delete from logger where unix_timestamp(createTime)<='${time_30}'`;
    let row = await db.query(_sql);
    const ms = new Date() - start;
    let params = {};
    params.ms = ms;
    params.ip = "本地";
    params.address = "局域网";
    params.url = "清除日志";
    params.method = "clearLogger";
    let paramsJson = { _sql: _sql, affectedRows: row.affectedRows };
    params.params = JSON.stringify(paramsJson);
    await logger.add(params);
  },
  /** 定时删除SQl里不存在的图片*/
  async clearRubbishImg() {
    /**读取文件里的图片地址*/
    const start = new Date();
    const filePath = path.join(__dirname, `../upload/`);
    fs.readdir(filePath, async (err, files) => {
      if (err) {
        console.warn(err);
      } else {
        const good_imgsql = `select figure from goods`;
        let goodsImg = await db.query(good_imgsql);
        const users_imgsql = `select avatar from users`;
        let usersImg = await db.query(users_imgsql);
        goodsImg = goodsImg.reduce((item, cur) => {
          item.push(cur.figure);
          return item;
        }, []);
        usersImg = usersImg.reduce((item, cur) => {
          item.push(cur.avatar);
          return item;
        }, []);
        usersImg = usersImg.reduce((item, cur) => {
          if (cur?.avatar) {
            item.push(cur?.avatar);
          }
          return item;
        }, []);
        const SQL_img = [...goodsImg, ...usersImg];
        const files_img = files;
        for (let i = 0; i < files_img.length; i++) {
          let flag = true; //是否要删掉文件
          for (let j = 0; j < SQL_img.length; j++) {
            if (SQL_img[j].search(files_img[i]) > -1) {
              //说明files[i]图片地址是在数据表中的，是真正用到的图片
              flag = false;
            }
          }
          if (flag) {
            fs.unlinkSync(`${filePath}/${files_img[i]}`);
          }
        }
      }
    });
    const ms = new Date() - start;
    params.ms = ms;
    let params = {};
    params.ip = "本地";
    params.address = "局域网";
    params.url = "清除多余图片";
    params.method = "clearRubbishImg";
    params.params = start;
    await logger.add(params);
  },
};
module.exports = script;