Added ability to get challenges by challengeName API
Work To Do
Create a front-end form to allow admins to create a challenge
Create front-end to choose which challenge the person is logging exercise to
Create front-end to choose which team the person is logging exercise to
Desired flow:
User chooses the challenge they are taking part in by selecting from dropdown (map challengeId to challengeName)
User is presented with a dropdown to choose which team they are adding exercise to (map teamId to teamName)
User chooses exercise
User enters time completed
Submits to database
Database has an entry with the following data:
ID
ExerciseID
ExerciseName
UserID
TeamID
ChallengeID
This will allow for effective filtering e.g. using the exercise DB as a master, then querying based on unique IDs e.g.:
I want to find what exercise I have done => query the DB by my UserID
I want to find what exercise a team has done => query the DB by the TeamID
I want to find out what exercise has been done in the whole challenge => query the DB by the ChallengeID
I want to find out how many minutes a particular exercise has been done => query the DB by ExerciseID
I want to get a particular entry => query the DB by that entry ID
7
Setup Challenges
Work completed:
Work To Do
Desired flow: User chooses the challenge they are taking part in by selecting from dropdown (map challengeId to challengeName) User is presented with a dropdown to choose which team they are adding exercise to (map teamId to teamName) User chooses exercise User enters time completed Submits to database Database has an entry with the following data:
This will allow for effective filtering e.g. using the exercise DB as a master, then querying based on unique IDs e.g.: