Update Table: project

[Neecolaa]

Overview

We need to update the project table model to have the correct fields.

Details

• The initial model issue: Create Table: project #16
• Discussion leading to this change is here: ER: docs: project url fields vs project_url #78

Action Items

• Update existing Django model

• In the files indicated by Resource 1.01, Change the following items in the code

Current name in code	Updated Name	Updated Type (may already be this type)	FK Table	FK table Issue(s)
github_primary_repo_id	github_primary_repo_id	int	project_url1	#41
github_org_id	github_org_id	int	project_url2	#41
google_drive_id	google_drive_id	int	project_url3	#41
completed_at	completed_on	date

• Add the following items in the code

Name	Type	FK Table	FK Table Issue(s)
project_leads	int[] (user_id)

• 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
• generate a schema table description (see resources 1.04), post it in a comment below, and add a link to it in the Update Schema dependency issue
• Document the endpoint in ReDocs (see resources 1.05)

FK status

• Create Table: project_url #41

After PR has been approved

• Release the dependency and move the issue out of the icebox for ER: docs: project url fields vs project_url #78

Resources

• 1.01 Code locations
  • 1.01.01 /app/core/models.py
  • 1.01.02 /app/core/admin.py
  • 1.01.03 /app/core/api/serializers.py
  • 1.01.04 /app/core/api/views.py
• 1.02 People Depot Resources wiki page for links
  • ERD
  • Table and Field Definitions
  • API Endpoint
• 1.03 Spreadsheet: PD: Table and field explanations, Current Field Permission tab
  -1.03.01 project filter
• 1.04 Instructions for how to generate a schema table description
• 1.05 Instructions for how to Document End point step 3

Footnotes

1. github_primary_repo_id is no longer the repo id itself, will now be a foreign key to a row in project_url that corresponds to the primary repo ↩

2. github_org_id - int - no longer the org id itself, will now be a foreign key to a row in project_url that corresponds to the org repo link ↩

3. google_drive_id - int - no longer the google drive id itself, will now be a foreign key to a row in project_url that corresponds to the google drive ↩