Create API Endpoint to Fetch Project Contributors

[jalaym825]

We need to implement an API endpoint that retrieves a list of contributors for the Club Gamma project from our database. This will help us showcase all individuals who have contributed to the project without fetching data directly from GitHub.

Requirements

• Create an API endpoint /api/projects/contributors/:id that returns a list of contributors for a specific project, identified by its id.
• The API should fetch data from the pullRequests table in the database using Prisma.
• Each contributor entry should include:
  • Contributor's name
  • GitHub username (githubId)
  • Profile URL (constructed using the GitHub username)
  • Contributions count (sum of points for the PRs and PRs count)
  • Avatar URL for displaying profile images

Implementation Steps

1. Set up a new route for the /api/projects/contributors/:id endpoint in the backend.
2. Use Prisma to fetch contributors from the pullRequests table.
3. Aggregate the points for each contributor and format the response to include the necessary details.
4. Return the data in a structured format (e.g., JSON) to the frontend.

Additional Notes

• Ensure that the endpoint handles cases where no contributors are found gracefully.
• Consider optimizing the query if the pullRequests table contains a large amount of data.

Acceptance Criteria

• The /api/projects/contributors/:id endpoint is created and functional.
• It returns a list of contributors with the specified details.
• The endpoint handles errors appropriately and returns relevant status codes.
• The implementation follows best practices for API design and documentation.

[opbot-xd]

I am interested in solving this issue. Can you assign it to me?

[jalaym825]

I am interested in solving this issue. Can you assign it to me?

Hey, done! You can work on this issue now.

[jalaym825]

@opbot-xd any updates?

[opbot-xd]

yes, just working on it... will complete it by tonight.