Create Table: Accomplishment

[fyliu]

Overview

We need to create the accomplishment 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

• identify and document table description (see spreadsheet under Resources)
  • if not, reach out to PD leads
• 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)
• 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)
• create a single model in Django (defining schema)
• 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).
• write an API end point
• write API unit tests
• add extra validation code to the serializer
• write tests for the validation
• document the endpoint

Resources/Instructions

• See People Depot Resources wiki page for links
  • ERD
  • Table and Field Definitions
  • API Endpoint
• See the wiki page for instructions.
• DRF docs on object level validation

Description

List of Accomplishments associated with a project

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)

   • PK - id - int - Record Id
   • (FK) project_id - int - Record Id
   • title - varchar
   • description - varchar
   • url - url varchar
   • created - timestamp
   • updated - timestamp
   • accomplished_on - date

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)

   • project (many-to-one)

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

   • None

Custom Validation

The project_id field can be null.

1. If project_id is null, the url field must be filled
2. If the project_id is not null, the url field can still be filled if there's an alternative web page for the specific accomplishment

[dmartin4820]

For 10/24/2024 meeting:
I won't be at the meeting tomorrow

Progress: Not started yet.
Blockers: None yet
Availability: Flexible between 5pm - 9pm on weekdays.
ETA: Will work over the weekend

[dmartin4820]

For 10/30/2024 meeting:

Progress: Not started yet.
Blockers: Been focusing on PR updates (#385 and #400) for other tasks and reviewing. Once those are done or don't have any lingering issues to fix, I can dedicate more time to this.
Availability: Flexible between 5pm - 9pm on weekdays and the weekend.
ETA: Will work over the weekend

[shmonks]

@drakeredwind01 Just the usual update request ahead of today's meeting.

Please provide update

1. Progress: "What is the current status of your project? What have you completed and what is left to do?"
2. Blockers: "Difficulties or errors encountered."
3. Availability: "How much time will you have this week to work on this issue?"
4. ETA: "When do you expect this issue to be completed?"
5. Pictures or links* (if necessary): "Add any pictures or links that will help illustrate what you are working on."

• remember to add links to the top of the issue if they are going to be needed again.

[drakeredwind01]

created "class Accomplishment(AbstractBaseModel)"
working on API
then will run a test to make sure they work

[drakeredwind01]

finished:

• models.py
• admin.py
• serializers.py

need help:

• starting server for "app/core/tests/test_api.py"

[shmonks]

Please provide update

1. Progress: "What is the current status of your project? What have you completed and what is left to do?"
2. Blockers: "Difficulties or errors encountered."
3. Availability: "How much time will you have this week to work on this issue?"
4. ETA: "When do you expect this issue to be completed?"
5. Pictures or links* (if necessary): "Add any pictures or links that will help illustrate what you are working on."

• remember to add links to the top of the issue if they are going to be needed again.