Create Table: project_stack_element_xref

[Neecolaa]

Dependency

• Consolidating Technology, Tool, & Language - Schema Changes #207
• Update Table: technology (rename to stack_element) #204

Overview

We need to create the project_stack_element_xref 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
• Check to see if open issues in FK status below
  • If all Issues listed are closed (or there are no FKs), then skip the next 3 steps
    • comment out the code after you create it (see FK Status below for open/closed state)
    • add an action item on the open issue to uncomment the code line you commented out when that issue's table is created.
    • Provide your file and line number as a permalink under resources in that issue

Resources/Instructions

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

Table Description

Joining project to stack_element (technologies, tools, and languages table)

Data Fields

1. New fields

Name	Type	FK Table	FK table Issue(s)
project_id	int	project	#16
stack_element_id	int	stack_element	#39 initial model, #204 modification

FK status

• Create Table: project #16
• Create Table: technology #39
• Update Table: technology (rename to stack_element) #204

Associated Tables

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

Testing ideas

Set the peopledepot project to have the python language in its stack

• create a stack_element object of "python" with the "language" type
• create the peopledepot project and associate the stack_element.
• check that the peopledepot project stack associations contains the "python" language