var createError = require('http-errors');
var express = require('express');
var path = require('path');
var cookieParser = require('cookie-parser');
var logger = require('morgan');


var pg = require('pg')
var conString = "tcp://postgres:root@localhost/robot_msg";
var client = new pg.Client(conString)
const { createProxyMiddleware } = require('http-proxy-middleware');
var app = express();

// view engine setup
app.set('views', path.join(__dirname, 'views'));
app.set('view engine', 'jade');
var restream = function (proxyReq, req, res, options) {
  if (req.body) {
    let bodyData = JSON.stringify(req.body);
    // incase if content-type is application/x-www-form-urlencoded -> we need to change to application/json
    proxyReq.setHeader('Content-Type', 'application/json');
    proxyReq.setHeader('Content-Length', Buffer.byteLength(bodyData));
    // stream the content
    proxyReq.write(bodyData);
  }
}
var router = express.Router();
client.connect(function (error, results) {
  if (error) {
    console.log('clientConnectionReady Error:' + error.message);
    client.end();
    return;
  }
  console.log('connection success...\n');
  
})
router.post("/addMsg", async (req, res, next) => {
  let { sendMsg, receive,player,ip,session } = req.body
  let selectSQLString = `insert into msg_table (sendmsg,receive,player,ip,session) values ('${sendMsg}','${receive}','${player}','${ip}','${session}');`;
  console.log(selectSQLString)
  client.query(selectSQLString, function (error, results) {
    console.log(error);
    res.json({ code: 1, msg: "添加成功" })
  })
})

app.use(logger('dev'));
app.use(express.json());
app.use(express.urlencoded({ extended: false }));
app.use(cookieParser());
app.use(express.static(path.join(__dirname, 'public')));

app.use('/myAddress', createProxyMiddleware({
  target: 'http://openapi.turingapi.com/openapi/api/v2', pathRewrite: {
    '^/myAddress': '',
  }, changeOrigin: true,
  onProxyReq: restream
})
);
app.use('/', router);


// 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;