//请求报错
var createError = require('http-errors');
//引入express
var express = require('express');
//引入path
var path = require('path');
var cookieParser = require('cookie-parser');
var lessMiddleware = require('less-middleware');
var logger = require('morgan');
// 引入express-session
var session = require('express-session');
const mysql = require('mysql');
const MySQLStore = require('express-mysql-session')(session);

//配置 mysql
const options = {
  host:'localhost',
  port:3306,
  user:'root',
  password:'123456',
  database:'session'
}
//创建
const sessionStore = new MySQLStore(options);

var indexRouter = require('./routes/index');
var usersRouter = require('./routes/users');
var apisRouter = require('./routes/api');
var app = express();

// view engine setup 使用art-template模板引擎
app.set('views', path.join(__dirname, 'views'));
app.set('view engine', 'html');
app.engine('html',require('express-art-template'));

//app.use(fn)  fn都是应用级中间件
app.use(logger('dev'));
app.use(express.json());
app.use(express.urlencoded({ extended: false }));
app.use(cookieParser());
app.use(lessMiddleware(path.join(__dirname, 'public')));
app.use(express.static(path.join(__dirname, 'public')));

//设置相关参数 --路由守卫
app.use(session({
  secret: 'hellom', //自定义
  name: 'hellom.sid',//自定义
  resave: true,
  rolling: true,
  saveUninitialized: true,
  cookie: {
      secure: false,
      // domain: 'xxx.xxx.xxx.xxx:xxxx', // 域名
      path: '/',
      httpOnly: true,
      maxAge: 1000*60*60*24  //信息过期时间
  },
  Store:sessionStore,
}));

//使用路由    
app.use('/', indexRouter);
app.use('/users', usersRouter);
app.use('/api',apisRouter);

// catch 404 and forward to error handler
app.use(function(req, res, next) {
  next(createError(404));
});

// error handler 错误处理中间件
app.use(function(err, req, res, next) {
  // set locals, only providing error in development
  res.locals.message = err.message;
  res.locals.error = req.app.get('env') === 'development' ? err : {};

  // render the error page
  res.status(err.status || 500);
  res.render('error');
});

module.exports = app;