GSG-G10 / GSG-G10/PSJobs

GET| /company/:companyId/reviews

Open
#10 0 comments 0 reactions 1 assignee Claimed by @emanNahed View on GitHub
Backend To-Do
Dominant language
JavaScript
Stars
0
Forks
3
PR merge metrics
No merged PRs in 30d

Description

## Route: GET api/v1/company/:companyId/reviews

### Success criteria:
- [ ] DB query
- [ ] Response

### DB Query
```sql
SELECT U.first_name, U.last_name, review_content, FROM company C INNER JOIN review R ON C.id = R.company_id
INNER JOIN user U ON U.id = R.user_id
WHERE C.id = $1
```

### Response

## Success
```js
{
statusCode:200,
data: [{
first_name,
last_name,
content_review
}]
}
```

## Failed:
```js
{statusCode:400, msg: "bad request"}
```

Contributor guide

No contributing guide indexed for this repository

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.