require('../connections/sql-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('/dbs', verifyJWT, (req, res) => {
    execSQLQuery2(`SELECT
      name
    FROM master.dbo.sysdatabases
    WHERE cmptlevel = 80
    ORDER BY name ASC;`, res, req.originalUrl);
  })

  return router;
};

module.exports = routes;