Add Pagination, Sorting and 3 summary fields to endpoint Get Features for Workspace

fvalentiner commented 5 months ago

Add Pagination, Filtering, Sorting and 3 more fields to the Get Features for Workspace endpoint

/workspaces/{workspace_uuid}/features

We need to add:

Use the Database pagination and sorting function

offset, limit, sortBy, direction, search := utils.GetPaginationParams(r)

And Three fields: -- Total Completed Bounties [bounties_count_completed] (int ) -- Total Assigned Bounties [bounties_count_assigned] (int) -- Total Open Bounties [bounties_count_open] (int)

To the get features for workspace endpoint. GET /workspaces/{workspace_uuid}/features

Pagination Query Parameters limit=10 &page=1 &resetPage=true

Sorting Query Parameter &sortBy=priority, created

You can copy functionality for pagination and sorting from /gobounties/all endpoint where all this query parameters are implemented.

This changes in the endpoints are necessary to make this UI changes.

Current Design

New Design

Make sure you are running posgresql locally
Create file .env with the following content PORT=5005 DATABASE_URL=postgres://postgres:asdf@localhost:5432/ebdb?sslmode=disable

Change DATABASE_URL to connect to your local DB (it could be an empty db)

Run "go run ." to run the backend API that connects to the DB and creates the objects

[ ] I have created at least 5 features for a single workspace
[ ] I have created at least 5 bounties for each feature total (25) and put at least 1 in each of the bounty states [Open], [Assigned], [Completed], [Paid]
[ ] I have checked that the summary fields are returning the right values
[ ] I have tested each of the query parameters [limit], [sortBy], [page], [resetPage]
[ ] I have tested several values for each filter parameter
[ ] I can submit a pr within 6 hours of taking the bounty

AbdulWahab3181 commented 5 months ago

@fvalentiner Could you please assign me?

MahtabBukhari commented 5 months ago

@fvalentiner Could you please assign me?

MirzaHanan commented 5 months ago

Hi @fvalentiner, please assign me?

stakwork / sphinx-tribes