require('../connections/mysql-server');
require('../helpers/CheckToken');
const express = require('express');
const router = express.Router();
const bodyParser = require('body-parser');

router.use(bodyParser.urlencoded({ extended: true }));
router.use(bodyParser.json());

var routes = function () {

  router.get('/states', verifyJWT, (req, res) => {
    execSQLQuery(`SELECT
      *
    FROM states;`, res, req.originalUrl);
  });

  router.get('/citiesbyState/:idstates', verifyJWT, (req, res) => {
    const idstates = parseInt(req.params.idstates);
    execSQLQuery(`SELECT
      *
    FROM cities
    WHERE idstates = ${idstates};`, res, req.originalUrl);
  });

  return router;
};

module.exports = routes;