Source: routers/person.js

  1. const express = require('express');
  2. const auth = require('../middleware/authenticator.js');
  3. const mysql = require("../db/mysql.js");
  4. const router = express.Router();
  6. /**
  7.  * @typedef {object} PersonGetPackage
  8.  * @property {string} first_name The first name of the person
  9.  * @property {string} last_name The last name of the person
  10.  * @property {boolean} has_picture Whether the person has a picture on the firebase database
  11.  */
  13. /**
  14.  * Route for getting person information for the current user
  15.  * @name person/get
  16.  * @function
  17.  * @inner
  18.  * @param {*} req
  19.  * @param {*} res
  20.  * @returns {PersonGetPackage|string} On success, information about the person. Otherwise, an error message.
  21.  * @async
  22.  */
  23. router.get('/', auth.token, async (req, res) => {
  24.   const errorMessage = "Unable to get person";
  25.   if (res.locals.uid) {
  26.     let client = await mysql.getClient();
  27.     client.query("SELECT first_name, last_name, has_picture FROM tma.person WHERE person_id=?", [res.locals.uid], function(error, results, fields) {
  28.       if (error) {
  29.         res.status(503).send(errorMessage);
  30.       } else if (results.length === 0) {
  31.         res.status(208).send(errorMessage); 
  32.       } else {
  33.         res.status(200).json(results[0]);
  34.       }
  35.     });
  36.   } else {
  37.     res.status(400).send(errorMessage);
  38.   }
  39. });
  41. /**
  42.  * Route for adding a person
  43.  * @name person/post
  44.  * @function
  45.  * @inner
  46.  * @param {*} req
  47.  * @param {string} req.body.firstName The first name of the Person to be created
  48.  * @param {string} req.body.lastName The last name of the Person to be created
  49.  * @param {boolean} req.body.hasPicture Whether the person uploaded a picture to Firebase during account creation
  50.  * @param {*} res
  51.  * @returns {string} An error message if an error occured
  52.  * @async
  53.  */
  54. router.post('/', auth.token, async (req,res) => {
  55.   let first = req.body.firstName;
  56.   let last = req.body.lastName;
  57.   let hasPicture = req.body.hasPicture;
  58.   const errorMessage = "Unable to create profile";
  59.   if (res.locals.uid && first && last && hasPicture !== undefined) {
  60.     let client = await mysql.getClient();
  61.     client.query("insert into tma.person (person_id, first_name, last_name, email, has_picture) values(?, ?, ?, ?, ?)",[res.locals.uid,first,last,res.locals.email,hasPicture], function (error, results, fields) {
  62.       if (error) {
  63.         res.status(503).send(errorMessage);
  64.       } else {
  65.         res.status(200).send();
  66.       }
  67.     });
  68.   } else {
  69.     res.status(400).send(errorMessage);
  70.   }
  71. });
  73. /**
  74.  * Route for updating a person's information
  75.  * @name person/put
  76.  * @function
  77.  * @inner
  78.  * @param {*} req
  79.  * @param {string} req.body.firstName Optional parameter. If provided, will set the first name of the Person to this value
  80.  * @param {string} req.body.lastName Optional parameter. If provided, will set the last name of the Person to this value
  81.  * @param {boolean} req.body.hasPicture Optional parameter. If provided, will set whether the Person has a picture to this value
  82.  * @param {*} res
  83.  * @returns {string} An error message if an error occured
  84.  * @async
  85.  */
  86. router.put('/', auth.token, async (req,res) => {
  87.   let setString = [];
  88.   let args = [];
  89.   let first = req.body.firstName;
  90.   if (first) {
  91.     setString.push("first_name=?");
  92.     args.push(first);
  93.   }
  94.   let last = req.body.lastName;
  95.   if (last) {
  96.     setString.push("last_name=?");
  97.     args.push(last);
  98.   }
  99.   let hasPicture = req.body.hasPicture;
  100.   if (hasPicture) {
  101.     setString.push("has_picture=?");
  102.     args.push(hasPicture);
  103.   }
  104.   const errorMessage = "Unable to update person";
  106.   args.push(res.locals.uid);
  107.   if (setString.length > 0) {
  108.     let client = await mysql.getClient();
  109.     client.query("UPDATE tma.person SET " + setString.join(",") + " WHERE person_id=?", args, function(error, results, fields) {
  110.       if (error) {
  111.         res.status(503).send(errorMessage);
  112.       } else {
  113.         res.status(200).send();
  114.       }
  115.     });
  116.   } else {
  117.     res.status(400).send(errorMessage);
  118.   }
  119. });
  121. module.exports = router;