Express-based API Endpoint Sample

Express-based API.md

src/server.js

import Express from 'express'
import bodyParser from 'body-parser';
import sql from 'mssql';
import config from './config';

const server = new Express();

server.use(bodyParser.urlencoded({ extended: true }));
server.use(bodyParser.json());
server.use(require('./api/sites.js'));

sql.connect(config.database, err => {
  if (err) {
    console.error('Failed to open a SQL Server connection.', err.stack);
  }
  server.listen(process.env.PORT);
});

src/api/sites.js

import sql from 'mssql';
import validator from 'validator';
import { Router } from 'express';

const router = new Router();

router.post('/sites', async (req, res, next) => {
  try {
    const model = req.body;
    // TODO: Validate the model
    const request = new sql.Request(connection);
    const dataset = await request.query(`
      INSERT INTO Site (...) VALUES (...);
      SELECT ... FROM Site WHERE SiteID = @@IDENTITY;
    `);
    res.status(201).send(dataset[0]);
  } catch (err) {
    next(err);
  }
});

export default router;