RESTful API for a Demo Model

api.js

const express = require('express');
const app = express();
const router = express.Router();

const host = '';
const port = '';
const user = '';
const password = '';
const database = '';

const Sequelize = require('sequelize');
const sequelize = new Sequelize(`postgres://${user}:${password}@${host}:${port}/${database}`);

const User = sequelize.define('user', {
  firstName: {
    type: Sequelize.STRING
  },
  lastName: {
    type: Sequelize.STRING
  }
});

router.get('/', (req, res) => {
  User.findAll({
    order: [
      [ 'id', 'ASC' ]
    ]
  }).then(users => {
    res.send(users);
  })
});

router.get('/profile/:fname.:lname', (req, res) => {
  User.findAll({
    where: {
      firstName: `${req.params.fname}`,
      lastName: `${req.params.lname}`
    }
  }).then(users => {
    res.send(users);
  });
});

router.post('/new/:fname.:lname', (req, res) => {
  User.create({
    firstName: `${req.params.fname}`,
    lastName: `${req.params.lname}`
  }).then(() => {
    res.redirect('/users');
  });
});

router.put('/edit/:id/:fname.:lname', (req, res) => {
  User.update({
    firstName: `${req.params.fname}`,
    lastName: `${req.params.lname}`
  }, {
    where: {
      id: `${req.params.id}`
    }
  }).then(() => {
    res.redirect('/users');
  });
});

router.delete('/destroy/:id', (req, res) => {
  User.destroy({
    where: {
      id: `${req.params.id}`
    }
  }).then(() => {
    res.redirect('/users');
  })
})

app.use('/users', router);
app.listen(3030);