Update Event table must-could-should

[fyliu]

Overview

We need to update the event table model in django to utilize the practice area table instead of the outdated role table.

• [docs] Improve contributing docs #173 wasn't as complete as we thought it was

Details

The old model issues for this table are

• Failing PR Test initial data migration 36 #14
• [docs] Improve contributing docs #173

Action Items

• Update existing Django model
• Write a test for the new relationships this model will have with other models (e.g., creating a user and assigning them a set of permissions on a project) if any.
• Update API end point
• Update API unit tests
• Document the endpoint in Swagger

Changes Needed

Columns to Remove

• must_roles - int[] (role_id)
• should_roles - int[] (role_id)
• could_roles - int[] (role_id)

Columns to Add

• must_attend - JSON[]
• should_attend - JSON[]
• could_attend - JSON[]

Additional Changes

• Add example JSON to the documentation (like the one in the ERD)

JSON Example:

[
  {
    practice_area: engineering,
    permission_level: practiceLeadProject
  },
  {
    practice_area: pm,
    permission_level: practiceLeadProject
  }
]

Resources

• See People Depot Resources wiki page for links
  • ERD
  • Table and Field Definitions
  • API Endpoint

Practice Areas:

• Development
• Project Management
• Design
• Professional Development

Permission Types:

• adminGlobal
• adminBrigade
• adminProject
• practiceLeadProject
• practiceLeadJrProject
• memberProject
• memberGeneral

Test suggestions

• create an "All" event for the PeopleDepot project with these attendance suggestions
  • must: adminProject, practiceLeadProject, practiceLeadJrProject
  • should: memberProject
  • could: memberGeneral
• need an example that utilizes Practice Area values