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

Resources/Instructions

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

Description

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

Data Fields

1. New fields
   • (PK) id - int - Record Id
   • (FK) project_id - int
   • (FK) stack_element_id - int - Record Id

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

[fyliu]

We may be able to use the django builtin many to many field for this since this model doesn't have extra custom fields.

We would be able to do something like peopledepot.stack to get the set of associated stack_elements. And python.projects to get the all the projects using python.

More links to reference in deciding if this is a good idea to do:

• https://docs.djangoproject.com/en/5.0/ref/models/fields/#django.db.models.ManyToManyField
• https://docs.djangoproject.com/en/5.0/topics/db/models/#intermediary-manytomany