30 lines
716 B
JavaScript
30 lines
716 B
JavaScript
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;
|