requests.js - API - Update Matching Request - Tinder Clone

requests.js

const getUpdateRequest = (id, status) => {
    if (status && status === constants.matchRequestStatus.accepted) {
      return {
        payload: [status, new Date(), id],
        sql: "UPDATE match_request SET match_request_status = ?, accepted_date = ? WHERE id = ?"
      };
    }
    return {
      payload: [status, id],
      sql: "UPDATE match_request SET match_request_status = ? WHERE id = ?"
    };
  }

  app.post('/requests/update', (req, res) => {
    const { id, status } = req.body;
    if (id && status) {
      const sql = "SELECT * FROM match_request WHERE id = ?";
      dbConn.query(sql, [id], function (err, result) {
        if (err) {
          res.status(200).jsonp({ message: "The system error, cannot update the match request. Please try again" });
        } else if (!result || result.length === 0) {
          res.status(200).jsonp({ message: "The match request did not exist in the system" });
        } else {
          const updateRequest = getUpdateRequest(id, status);
          dbConn.query(updateRequest.sql, updateRequest.payload, function (error, result) {
            if (error || !result || result.length === 0) {
              res.status(200).jsonp({ message: 'Cannot update the match request. Please try again' });
            } else {
              res.status(200).jsonp({ message: 'The match request was updated successfully' });
            }
          });
        }
      });
    } else {
      res.status(200).jsonp({ message: "Please provide id and status for the match request" });
    }
  });