This pull request introduces a new feature that allows students to retrieve their own course phase participation details. The changes include adding new functions, updating SQL queries, and modifying the router setup to support this functionality.

Key changes include:

Router Updates:

• server/coursePhase/coursePhaseParticipation/router.go: Added a new route /self to allow students to get their own course phase participation details and implemented the corresponding handler function getOwnCoursePhaseParticipation. [1] [2]

Keycloak Integration:

• server/keycloak/main.go: Updated the Keycloak client manager to include a database query to check if the user is a sutdent in some course. [1] [2]
• server/keycloak/middleware.go: Imported necessary packages and updated the middleware to support the new functionality.

Open Questions

• Should a student be allowed to see his / her pass status?
• Should a student be allowed to see the course phase participation?