const render = require('koa-ejs');
const path = require('path');
const app = new Koa();
render(app, {
  root: path.join(__dirname, 'view'),
  layout: false,
  viewExt: 'html' || 'ejs',
  cache: false,
  debug: true
});
 

var staticCache = require('koa-static-cache')
 
app.use(staticCache(path.join(__dirname, 'public'), {
  maxAge: 365 * 24 * 60 * 60
}))

const Koa = require('koa');
const app = new Koa();
app.use(require('koa-static')(root, opts));

const multer = require("koa-multer");
// 存储到内存
let upload = multer({
  storage: multer.memoryStorage(),
  limits: {
      fileSize: $class.config.multer_file_size * 1024 * 1024
  }
});
let multem_fn = (ctx) => {
  let multer = upload.single("image");
  return new Promise((resolve, reject) => {
      multer(ctx, () => { })
          .then(() => {
          resolve(true);
      })
          .catch((err) => {
          reject(err);
      });
  });
};

const mysql = require('mysql2');
// create the pool
const pool = mysql.createPool({host:'localhost', user: 'root', database: 'test'});
// now get a Promise wrapped instance of that pool
const promisePool = pool.promise();
// query database using promises
const [rows,fields] = await promisePool.query("SELECT 1");

var Redis = require('ioredis');
var redis = new Redis();
redis.set('foo', 'bar');
redis.get('foo', function (err, result) {
  console.log(result);
});
redis.del('foo');
// Or using a promise if the last argument isn't a function
redis.get('foo').then(function (result) {
  console.log(result);
});

let Hashids = require('hashids')
// 盐值，最小长度，加密的值
let hashid = new Hashids(salt,minLength,alphabet)
hashids.encode(1)
hashids.decode(1)

let parser = require('fast-xml-parser')
// xml2json
parser.parse(resp)
let j2xParser = parser.j2xParser;
// json2xml
return new j2xParser({}).parse(obj);

import * as winston from "winston";
import * as path from "path";
import * as DailyRotateFile from "winston-daily-rotate-file";
import * as Koa from 'koa'
const { combine, timestamp, label, printf, json } = winston.format;
//---------------error-stack 日志 --------------------------------
let createErrorStackLogger = function(filepath: string = "") {
  let errStackLogger = winston.createLogger({
    level: "error",
    format: combine(
      label({ label: "error" }),
      timestamp(),
      printf(print => {
        let { level, message, label, timestamp, info } = print;
        info = info
          .replace(/at.+\/node_modules\/.+(\)|\d)/g, "")
          .replace(/(\r\n)|\n/g, "")
          .replace(/at\s+/g, "\n");
        return `${new Date(
          timestamp
        ).toLocaleString()} [${label}] ${level}: ${message}--print: \n ${info}`;
      })
    ),
    transports: [
      new DailyRotateFile({
        filename: path.resolve(filepath,`log/error_stack/%DATE%.log`),
        datePattern: "YYYY-MM-DD",
        zippedArchive: true,
        maxSize: "20m",
        maxFiles: "14d"
      })
    ]
  });
  return errStackLogger;
};

let createLog = (type: string = "debug") => {
  return function(filepath: string = "") {
    let Log = winston.createLogger({
      level: type,
      format: json(),
      transports: [
        new DailyRotateFile({
          filename: path.resolve(filepath,`log/${type}/%DATE%.log`),
          datePattern: "YYYY-MM-DD",
          zippedArchive: true,
          maxSize: "20m",
          maxFiles: "14d"
        })
      ]
    });
    return Log;
  };
};
let init = (app: any, filepath: string = "") => {
  app.context.createError = createErrorStackLogger(filepath);
  app.context.requestError = createErrorRequestLogger(filepath)
  let appDebug: any = createLog()(filepath);
  let appError: any = createLog("error")(filepath);
  app.context.$log = (str: any, type: string = "debug") => {
    if (type == "debug") {
      appDebug.log({
        level: "debug",
        message: "debug",
        info: str
      });
    } else {
      appError.log({
        level: "error",
        message: "error",
        info: str
      });
    }
  };
};
let Log = {
  createErrorStackLogger,
  createDeBug: createLog(),
  createError: createLog("error"),
  init: init
};
export = Log;