Create Table: stack_element_type

[Neecolaa]

Dependency

• Consolidating Technology, Tool, & Language - Schema Changes #207 Completed for this table

Overview

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

• 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
• 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.

Description

Indicating whether a record in the ttl table is a technology, tool, or language (and possibly other types in the future).

Data Fields

1. New fields
   • (PK) id - int - Record Id
   • name - varchar
   • description - varchar

Associated Tables

1. New associations
   • stack_element (one-to-many)

[AzaniaBG]

Availability:
Tuesday: 12:45 - 1:45 PM
Wednesday: 8 - 9 AM
Thursday: 10:30 - 12:30 PM
Note: I added a link to the ERD and Table and Field Definitions in this issue (under Resources/Instructions)

[AzaniaBG]

In addition to tasks above the following were done so far:

• Register model
• Create a Serializer
• Create a ViewSet
• Register the API endpoint (ViewSet)

[AzaniaBG]

I need help with this, and posted my issue in Slack earlier this week.

[AzaniaBG]

• I submitted a PR (#206 Create Table: stack_element_type (merge conflicts) #220) and requested @fyliu's review on 10/22 (also added the PD Project Board to this PR)
  • moved this to "New Issue Review" on Project Board
• I still need to do the following under Action Items:

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).

Questions:

• what's the best way to test that the table is working properly?

[AzaniaBG]

Working on the requested changes - availability:
11/3: 10 AM - 12 PM
11/6: 10 AM - 12 PM

[AzaniaBG]

Working on requested changes. I will follow up with Fang if I can't figure out the issues I'm facing.
Availability:
11/11: 9 AM - 12 PM
11/12: 9 AM - 12 PM

[AzaniaBG]

I re-requested review today.