hackforla / hackforla/peopledepot

Update Table: ProjectSDGXref

Open
#575 0 comments 0 reactions 0 assignees View on GitHub
feature: update table good first issue PII: FALSE ready for prioritization role: back end s: hackforla.org size: 0.25pt
Dominant language
Python
Stars
14
Forks
37
Avg merge
9d 15h
Merged PRs (30d)
5

Description

### Overview

We need to update the ProjectSDGXref table model to update table to have the correct names for fields.

#### Details

- The initial model issue: #66
- Discussion leading to this change is here: n/a

### 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) |
| -------------------- | ------------ | --------------------------------------- | -------- | ----------------- |
| sdg_id_id | sdg | int | SDG | #70 |
| projet_id_id | project | int | Project | #16 |

| Current Table Name in code | Updated Table Name |
| -------------------- | ------------ |
| ProjectSdgXref | ProjectSDGXref |

- [ ] 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
- #70
- #16

### After PR has been approved
- [ ] Release the dependency and move the issue out of the icebox for [Replace with ISSUE NUMBER OF UPDATE ERD]

### Resources
- 1.01 Code locations
- 1.01.01 [/app/core/models.py](https://github.com/hackforla/peopledepot/blob/main/app/core/models.py)
- 1.01.02 [/app/core/admin.py](https://github.com/hackforla/peopledepot/blob/main/app/core/admin.py)
- 1.01.03 [/app/core/api/serializers.py](https://github.com/hackforla/peopledepot/blob/main/app/core/api/serializers.py)
- 1.01.04 [/app/core/api/views.py](https://github.com/hackforla/peopledepot/blob/main/app/core/api/views.py)
- 1.02 [People Depot Resources wiki page](https://github.com/hackforla/peopledepot/wiki/Resources-and-Links) for links
- ERD
- Table and Field Definitions
- API Endpoint
- 1.03 Spreadsheet: [PD: Table and field explanations, Current Field Permission tab](https://docs.google.com/spreadsheets/d/1x_zZ8JLS2hO-zG0jUocOJmX16jh-DF5dccrd_OEGNZ0/edit?gid=749942651)
- 1.04 [Instructions for how to generate a schema table description](https://hackforla.github.io/peopledepot/contributing/howto/generate-db-table-description/)
- 1.05 [Instructions for how to Document End point](https://hackforla.github.io/peopledepot/contributing/howto/add-model-and-api-endpoints/#add-viewset) step 3

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.