23 lines
542 B
JavaScript
23 lines
542 B
JavaScript
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;
|