const express = require('express');
const path = require('path');
const mysql = require('mysql2/promise');
const cors = require('cors');

const config = require('./config')[process.env.env || 'dev'];
const router = require('./routes/1.0/router');
const auth = require('./routes/1.0/auth-middle');

var app = express();
app.use(cors());
app.locals.config = config;
app.locals.pool = mysql.createPool({
  host: config.mysql.host,
  user: config.mysql.username,
  password: config.mysql.password,
  database: config.mysql.database,
  waitForConnections: true,
  connectionLimit: config.mysql.connectionLimit,
  queueLimit: 0
});

app.locals.pool.query('select * from site;').then(results => {
  app.locals.sites = {};
  for(let row of results[0])
    app.locals.sites[row.key] = row;
  console.log('read site infos.');
});

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

app.use('/api/v1.0', auth, router);

app.use((req, res, next) => res.status(404).end());

module.exports = app;