const Sequelize = require('sequelize');

const sequelize = new Sequelize('数据库名', '数据库账号', '数据库密码', {
  host: '主机名',
  dialect: 'mysql',
  port: '端口',
  operatorsAliases: false,
  timezone: '+08:00', // 时区，中国+8
  pool: {
    max: 5,
    min: 0,
    acquire: 30000,
    idle: 10000
  }
});

sequelize
    .authenticate()
    .then(() => {
      console.log('***数据库连接成功');
    })
    .catch(err => {
      console.error('数据库连接失败：', err);
    });

module.exports = sequelize;

var PW = require("png-word");
var pw = PW(PW.GRAY); //这里可以选GRAY PNGWord RED
var r = require("random-word")("abcdefghijklmnopqrst0123456789");

const validat = (req, res) => {
  var numtxt = req.session.validat_num = r.random(4);
  pw.createPNG(numtxt,function(pngnum){
    res.send(pngnum);	
  })
}

module.exports = validat