require('dotenv').config({ path: './.env' })
var express = require('express');
var router = express.Router();
const mysql = require('mysql2/promise');
const co = require('co');
const chalk = require('chalk');

/* GET users listing. */
router.get('/:database/tables', function (req, res, next) {
  process.env.DB_DATABASE = req.params.database;

  const connect = function* () {
    return yield mysql.createConnection({
      host: process.env.DB_HOST,
      user: process.env.DB_USER,
      password: process.env.DB_PASS,
      database: process.env.DB_DATABASE
    });
  }

  const showTables = function* () {
    try {
      const connection = yield connect();

      const [rows, fields] = yield connection.query('show tables');
      const tables = rows.map(row => row[`Tables_in_${process.env.DB_DATABASE}`])

      return tables;
    } catch (err) {
      yield Promise.reject(err);
    }
  }

  co(showTables)
    .then(tables => {
      res.send(tables);
    }).catch(err => {
      res.status(500).send({message: err.message})
    })

});

module.exports = router;