austinmm / wsu_cpts_422_bats Goto Github PK

router.post("/:name", async (req, res) => {
  const tag_name = req.params.name;
  const interaction = req.query.interaction;
  const value = req.query.value;
  const token_id = res.locals.token_id;
  var response = undefined;
  try {
    var query = `INSERT IGNORE INTO tags (token_id, name, value, created) VALUES (${token_id}, '${tag_name}', '${value}', CURRENT_TIMESTAMP())`;
    var results = await executeQuery(query); //Executes query
    var tag_id = results.insertId;
    //Tag already exist so we need to obtain its 'id' to enter the new interaction 
    if(tag_id == 0){
      query = `SELECT id FROM tags WHERE name='${tag_name}'`;
      results = await executeQuery(query); //Executes query
      tag_id = results[0].id; 
    }
    query = `INSERT INTO interactions (tag_id, action, time) VALUES ('${tag_id}', '${interaction}', CURRENT_TIMESTAMP())`;
    results = await executeQuery(query); //Executes query
    res.status(201);
    response = {"tag": {"id": tag_id, "name": tag_name, "value": value}, "interaction": {"id": results.insertId, "action": interaction}};
  }
  catch(err) {
    response = err;
    res.status(500);
  }  
  //returns the json of new record that was inserted into the table
  res.send(response);
});

{
    "Status": "Successful",
    "Result": [
        {
            "id": 2326,
            "token_id": 2326,
            "name": "groups.custom.0",
            "value": "Example Tag Value",
            "created": "2019-09-21T06:56:41.000Z",
            "token": "cc93d2ef-a0ca-405d-8e8d-633b70ab51d4",
            "organization": "BATS",
            "issued": "2019-09-21T06:56:02.000Z"
        },
        {
            "id": 2326,
            "token_id": 2326,
            "name": "groups.custom.1",
            "value": "Example Tag Value",
            "created": "2019-09-21T06:57:20.000Z",
            "token": "cc93d2ef-a0ca-405d-8e8d-633b70ab51d4",
            "organization": "BATS",
            "issued": "2019-09-21T06:56:02.000Z"
        },
        {
            "id": 2326,
            "token_id": 2326,
            "name": "groups.custom.2",
            "value": "Example Tag Value",
            "created": "2019-09-21T06:57:58.000Z",
            "token": "cc93d2ef-a0ca-405d-8e8d-633b70ab51d4",
            "organization": "BATS",
            "issued": "2019-09-21T06:56:02.000Z"
        },...