Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Competition Participation #10

Open
1 of 3 tasks
varunsingh87 opened this issue Dec 23, 2023 · 0 comments · Fixed by #13
Open
1 of 3 tasks

Competition Participation #10

varunsingh87 opened this issue Dec 23, 2023 · 0 comments · Fixed by #13
Assignees
@varunsingh87
Labels
EPIC A large idea comprising many stories story New feature or request
Milestone
Phase 1 Stories

Comments

@varunsingh87
Copy link
Owner

varunsingh87 commented Dec 23, 2023 •
edited
Loading

Competition Teams

Users can create and join teams for a competition, and the submission is attached to this team.

Requirements

  • A logged in user can join a competition, becoming a participant
  • A teams page lists all teams
  • Teams have a max of 4 people
  • A participant may switch from a one-participant team to a new team by fulfilling the above conditions
  • A participant may leave a competition, but this action is irreversible to enforce commitments to teams
  • To switch teams, one of the following must happen:
    • a participant must submit a join request and (a member of) the team must accept the request
    • the team (member) must invite the participant and the participant must accept the invite
  • Currently joined competitions show up at top of home page for a user

Software Design

Schema Changes

  • submissions table -> teams table as an object property:
ID Competition Submission Join Requests
TEAM_1 COMPETITION_1 SUBMISSION_1 [USER_ID_4]
TEAM_2 COMPETITION_1 SUBMISSION_2 [USER_ID_5, USER_ID_6]
TEAM_3 COMPETITION_2 SUBMISSION_3 []
  • New table: participants:
User Team
USER_ID_1 TEAM_1
USER_ID_2 TEAM_1
USER_ID_3 TEAM_2
USER_ID_1 TEAM_3

Indexes: by_user, by_team

With this normalized database design, switching and joining teams is simple and efficient.

Competition Participation.pdf

Subtasks
@varunsingh87 varunsingh87 added the story New feature or request label Dec 23, 2023
@varunsingh87 varunsingh87 changed the title Hackathon participation Competition participation Dec 23, 2023
@varunsingh87 varunsingh87 self-assigned this Dec 23, 2023
@varunsingh87 varunsingh87 moved this from Backlog to In progress in Spoke Web Application Dec 26, 2023
varunsingh87 added a commit that referenced this issue Dec 27, 2023
@varunsingh87
#10 Implement joinCompetition, leaveCompetition, joinTeam
09b85a1 
* Add column width enforcement to prettier
* Add null check and error messages
* Update schema
varunsingh87 added a commit that referenced this issue Dec 27, 2023
@varunsingh87
#10 Reimplement listSubmissions, addSubmission with new schema
38878fd
varunsingh87 added a commit that referenced this issue Dec 28, 2023
@varunsingh87
#10 Implement requestJoin hook with validation logic
2d677fd
varunsingh87 added a commit that referenced this issue Dec 29, 2023
@varunsingh87
#10 Implement inviteToTeam with validation logic
e815673
varunsingh87 added a commit that referenced this issue Dec 29, 2023
@varunsingh87
#10 Implement leaveCompetition with validation logic
dd4b189
varunsingh87 added a commit that referenced this issue Dec 29, 2023
@varunsingh87
#10 Implement readParticipant hook, frontend for competition particip…
3fa41ea 
…ation, reimplement addCompetition

* Turn new-competition into a TypeScript file
varunsingh87 added a commit that referenced this issue Jan 2, 2024
@varunsingh87
#10 Implement leave competition front-end (button), alert provider
3f47090
varunsingh87 added a commit that referenced this issue Jan 3, 2024
@varunsingh87
#10 Implement own competitions row on front-end
e7bb9c5
varunsingh87 added a commit that referenced this issue Jan 4, 2024
@varunsingh87
#10 Make all pages guest-friendly, add wordmark
d2f8384 
* Extract into new components
* Make navbar links nextjs router links
varunsingh87 added a commit that referenced this issue Jan 4, 2024
@varunsingh87
#10 Make all pages guest-friendly, add wordmark
881f531 
* Extract into new components
* Make navbar links nextjs router links
varunsingh87 added a commit that referenced this issue Jan 4, 2024
@varunsingh87
#10 Make all pages guest-friendly, add wordmark
99e0bf7 
* Extract into new components
* Make navbar links nextjs router links
@varunsingh87 varunsingh87 linked a pull request Jan 5, 2024 that will close this issue
Feature/hopscotch 10 competition participation #13
Merged
@github-project-automation github-project-automation bot moved this from In progress to Done in Spoke Web Application Jan 5, 2024
@varunsingh87 varunsingh87 mentioned this issue Jan 11, 2024
Closed
@varunsingh87 varunsingh87 reopened this Jan 15, 2024
@varunsingh87 varunsingh87 pinned this issue Jan 15, 2024
@varunsingh87 varunsingh87 changed the title Competition participation Competition Participation Jan 15, 2024
@varunsingh87 varunsingh87 added the EPIC A large idea comprising many stories label Jan 15, 2024
@varunsingh87 varunsingh87 added this to the Phase 1 Stories milestone Jan 20, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@varunsingh87 varunsingh87

Labels
EPIC A large idea comprising many stories story New feature or request
Projects
Spoke Web Application
Status: Done
Milestone
Phase 1 Stories
Development

Successfully merging a pull request may close this issue.

Feature/hopscotch 10 competition participation varunsingh87/HOPSCOTCH
1 participant
@varunsingh87