tables.js

var express = require('express');
var router = express.Router();
const tablesModel = require('../../db/models/tables');
const usersModel = require('../../db/models/users');
const tryCatch = require('../utils/tryCatch');

//middleware
const authorization = require('../middleware/authorization');

router.get('/', async (req, res) => {
  //query string like ?userId=123
  const { userId } = req.query;
  try {
    const tables = await tablesModel.getByUserId(userId);
    res.status(200).send(tables);
  } catch (error) {
    res.status(500).send({ message: 'Internal server error' });
  }
});

router.get('/:id', async (req, res) => {
  tryCatch(async () => {
    const tableId = req.params.id;
    const table = await tablesModel.get(tableId);
    res.status(200).send(table);
  }, res);
});

router.get('/:id/users', async (req, res) => {
  tryCatch(async () => {
    const tableId = req.params.id;
    const users = await usersModel.getUsersByTableId(tableId);
    res.status(200).send(users);
  }, res);
});

router.post('/', (req, res) => {
  tryCatch(async () => {
    const tableName = req.body.name;
    const userId = req.user;
    const table = await tablesModel.create(tableName, userId);
    res.status(200).json(table);
  }, res);
});

router.delete('/:id', authorization.userOwnsTable, (req, res) => {
  tryCatch(async () => {
    const tableId = req.params.id;
    const result = await tablesModel.delete(tableId);
    res.status(200).json({ message: 'deleted' });
  }, res);
});

router.post('/:tableId/member', async (req, res) => {
  tryCatch(async () => {
    const userEmail = req.body.email;
    const tableId = req.params.tableId;
    const user = await usersModel.getUserInfoByEmail(userEmail);
    if (!user) {
      res.status(404).json({ message: `User ${userEmail} not found` });
      return;
    } else {
      const result = await tablesModel.addUserToTable(tableId, user.id);
      res.status(200).json({ ok: `added user ${user.id} to table ${tableId}` });
    }
  }, res);
});

router.delete('/:tableId/member/:userId', async (req, res) => {
  tryCatch(async () => {
    const tableId = req.params.tableId;
    const userId = req.params.userId;
    let result = await tablesModel.removeUserFromTable(tableId, userId);
    if (result) {
      res
        .status(200)
        .json({ ok: `removed user ${userId} from card ${tableId}` });
    } else {
      res.status(404).json({ message: `User not found` });
    }
  }, res);
});

module.exports = router;