Create Table: project_status (used to say project_program_area_status)

[Neecolaa]

Overview

We need to create the project_status table so that we can update a shared data store across hackforla.org, vrms, civictechjobs, and tables (onboarding) project.

Details

A table and a model are the same thing

Action Items

• [x] add issue link to the tables tab of the spreadsheet
• [x] identify and document table description (see spreadsheet under Resources)
• [x] compare and check off the data fields (below) against the ERD. Note any fields in the ERD that's missing from the list. (see Resources)
• [x] compare the check off associated tables (below) against the ERD. Note any associated tables in the ERD that's missing from the list (see Resources)
• [x] create a single model in Django (defining schema)
• [x] Create issue for updating projecttable connecting current_status_id to project_status -- This was done in the PR attached to this issue instead of creating a new one.
• [x] write a test for the relationships this model will have with other models (e.g., creating a user and assigning them a set of permissions on a project).
• [x] write an API end point
• [x] write API unit tests
• [x] document the endpoint

Post issue tasks

• [ ] resolve dependency on #67 and move it from Ice Box to New Issue Review with ready for tech lead label

Resources/Instructions

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

Description

Dictionary of status options for project and program_area

Data Fields

1. Copied from spreadsheet and checked off according to ERD. (unchecked items indicate a mismatch between ERD and spreadsheet, which requires a review)

   • [x] (PK) id - int - Record Id
   • [x] name - varchar
   • [x] description - varchar

2. In ERD only (having items here indicates a mismatch, which requires a review)

   • None

Associated Tables

1. Copied from spreadsheet and checked off according to ERD. (unchecked items indicate a mismatch between ERD and spreadsheet, which requires a review)

   • [x] project (one-to-many) #16
   • [x] project_status_history (one-to-many) #67

2. In ERD only (having items here indicates a mismatch, which requires a review)

   • None

[ExperimentsInHonesty]

remove program area from this table. It should be projects only

[Neecolaa]

DB Architect to-do: Change name from project_program_area_status to project_status

• [x] In tables tab
  • [x] table name
  • [x] table connections
• [x] In fields tab
• [x] In associated tables' issues
  • [x] see if closed tables need update issues
• [x] In ERD

[Neecolaa]

DB Architect to-do:

• [x] Remove status_id in program_area
  • [x] in fields tab
  • [x] in ERD create update issue for program_area to remove status_id program_area was merged without status_id already. Removed status_id from closed issue to reflect what's in the codebase
  • [x] Remove table connection between project_status and program_area
  • [x] in table tab
  • [x] in ERD

[fyliu]

Need to have initial data in the spreadsheet for project_status table

[ExperimentsInHonesty]

Initial data is Active On Hold Completed Closed

There is also another bit of information and I don't know exactly where it goes right at this min. But it's a visible: hidden. That is in addition to the status above. e.g., a project that is on-hold and hidden would not show up on the website. This is probably on the project table.

[dmartin4820]

Progress: Got my branch setup locally and on my remote fork of the main repo. I just need some fairly easy questions answered and I'll be able to move forward. Blockers:

• [x] The issue description says that the program_area model should have a relationship with the project_status model. The row in the PD: Table and field explanations Google sheet doesn't list this relationship (the Lucidchart diagram doesn't indicate a relationship either). Which is correct?
• [x] The issue also requires me to create another issue to update the current_status_id foreign key field to project_status. It should be possible to do this with the PR that I make for this issue by removing the line here. Should I still create an issue, or make the change I suggest in the PR for this issue?

Availability: Should have time this weekend, and potentially time in the evenings (i.e. 7pm to 9pm). ETA: Early next week or end of this weekend.

[fyliu]

• [ ] The issue description says that the program_area model should have a relationship with the project_status model. The row in the PD: Table and field explanations Google sheet doesn't list this relationship (the Lucidchart diagram doesn't indicate a relationship either). Which is correct?

I would confirm with @Neecolaa since it has to do with the database design and since she created this issue and made the change I refer to in the next sentence. From the issue history, it looks like the original issue had to do with project and program_area, and then this line was inadvertently left over when the issue was changed to project_status.

• [ ] The issue also requires me to create another issue to update the current_status_id foreign key field to project_status. It should be possible to do this with the PR that I make for this issue by removing the line here. Should I still create an issue, or make the change I suggest in the PR for this issue?

You're right. It's easier to just do that in this issue. Please update that task to do that.

[Neecolaa]

Fang's correct: when I updated the ERD and spreadsheet I neglected to remove the connection from this issue as well. I've done that now. Thank you for double checking that!