node+koa框架开发服务器之SQL封装以及redis

let db = {};
const mysql = require("mysql");
// const pool = mysql.createPool({
//   host: '180.76.240.87',
//   user: 'koa',
//   password: 'koa_123456',
//   database: "koa",
//   multipleStatements: true
// });
const pool = mysql.createPool({
  host: "localhost",
  user: "user",
  password: "password",
  database: "database",
  multipleStatements: true,
});
db.query = function (sql, values) {
  return new Promise((resolve, reject) => {
    pool.getConnection(function (err, connection) {
      if (err) {
        console.log("数据库链接失败");
        reject(err);
      } else {
        connection.query(sql, values, (err, rows) => {
          if (err) {
            reject(err);
          } else {
            resolve(rows);
          }
          connection.release();
        });
      }
    });
  });
};

module.exports = db;

const Redis = require('ioredis')//导入模块
const redis = {
  port: 6379,          // Redis port
  host: '127.0.0.1',   // Redis host
  prefix: '***', //存诸前缀
  ttl: 60 * 60 * 24 * 7 * 1000,  //过期时间   
  family: 4,
  db: 0
}
const redisClient = new Redis(redis)
//导出备用
module.exports = redisClient