Skip to content

Database migration to include project managers on project db entry #1386

@jbubar

Description

@jbubar

Overview

We want to display the PM's for the project on the Project page, and the first step is having that information in the backend.

Currently the project manager information (who can change project meeting times) are being kept in the User model (managedProjects array of project IDs) however, it is not in the project model. What we need is to add the User ids into the managedByUsers array on the project model.

Action Items

This should be done similarly to what @dannyprikaz is working on via a python notebook of some sort.

  • Add a field to the projects model to keep track of the managers
  • Do a database migration to add this new field to the test db.
  • Create a new db query that adds a specified user id to a project
  • Create a new db query that removes a specified user id from a project
    • These queries may need their own api route
    • These queries should be PUT requests because they're updating a current entrey
  • Note from Trillium that I don't have enough of a mental model of the project right now to point out where in the code this needs to go. Will update.
  • Create unit tests for all new functionality / update existing unit tests for any changed functionality

Resources/Instructions

Metadata

Metadata

Assignees

Type

No type

Projects

Status

Final QA (product)

Relationships

None yet

Development

No branches or pull requests

Issue actions