Full Stack: Create a "CreateTeam/JoinTeam Page" (React, Express)

[DanielPasion]

User Story

As a user who does not belong to a team, I would like to be able to access a page that gives me the option to either create a team or join a team via access code. Once I choose one of the options, it should be able to redirect me to the team management page and I should no longer be able to see this CreateTeam/JoinTeam Page unless I leave the current team im on.

Requirements

You will be creating the page that loads when a user is not part of a team. The page will be split up into two sections

• Create Team

  • Back End Tasks

  • Create a post route that takes in the parameters "teamName" and "userID".
  • In the Team Table: create a new record where Team.teamName = "teamName" and randomly generate a 8 character long passcode and store that into Team.passcode
  • In the TeamMember Table: create a new record where userID = "userID", teamID = the teamID of the newly created team, and the isOwner = True
  • Make sure to handle these cases and send respective error codes for the following:
    • Send an error code + message if the teamName is taken
    • Send an error code + message if user is already part of a team
    • If succesful, return a success status code and a message that team was successfully created.

• Front End Tasks

• In the upper half of the page, prompt the user to create a team by typing in a team name of their choice. Underneath, it should have a button that says create team. Once you create the team, it sends a POST Request to the backend creating an entry in the Teams and Teams Member table.
• When they click on the create team button, an alert of the status code or message should pop up
• If the creation is unsuccesful, allow user to try another input
• If the input is succesful, load the page so the user can no longer see the CreateTeam Page anymore

Reference:

• Join Team

• FRONT END ONLY

• Recreate this (DOES NOT NEED TO WORK) and put it in the bottom half of the page

Acceptance Criteria

• Nothing is styled
• User can succesfully create an account given a unique name
• User can not create a team name for a name that already exists
• User can not see the page if already part of a team

[jsouliss]

Most of the backend is completed I may have found a bug with the database.js file. The USER may be a environmental variable for MacOS changed from USER to DB_USER instead and works now.

I still need to test the backend code I wrote.

[jsouliss]

Tested a few routes fixed some logic and syntax errors. POST and GET requests work I used postman for testing, still need to test a few more routes.

[jsouliss]

Altered Tables TeamMember and Team, when a team is deleted the individual team members in the TeamMember Table are deleted first then the Team is deleted, I think backend is done for this task???

The following routes work:

Get all teams Create new team Delete team Get team by id