Get /stats

[Mu7ammadAbed]

relates #5

Route: GET api/v1/stats

Acceptance Criteria

• DB query
• Response
• Testing

---

DB query

We will use #14 , #26 , #16 and #17 query functions to get the length of each table to use in the stats board

// This is from a previous example you can use it as a reference

router.get('/stats', (req, res) => {
  getAllData()
    .then(({ rows }) => console.log(rows.length)) // this will log the length
    .catch((err) => next(err));
});

OR:
We can use the count function like this to count the number of rows per table

SELECT COUNT(id) 
 FROM cohort 
 UNION ALL 
 SELECT COUNT(id) 
 FROM project 
 UNION ALL 
 SELECT COUNT(id) 
 FROM student

Response

• Success

{ StatusCode: 200,
data: [ { count: '11' }, { count: '22' }, { count: '154' }  ]
}

• Failed

{statusCode:400, message:"Bad Request"}

Testing

to be a successful test

• status === 200
• typeof(data) === "object"