icgc-argo / icgc-argo/program-service

Update Program Entity - All Programs belong to 1 Data Center

Open
#413 0 comments 0 reactions 1 assignee View on GitHub

@Azher2Ali is already working on this.

Since Aug 30, 2023.

new-feature
Dominant language
Java
Stars
3
Forks
0
Avg merge
14h 34m
Merged PRs (30d)
2

Description

This ticket is part of the effort to add functionality of a Data Center Registry to the Program Service:
The Program Service scope is being expanded to also act as a Data Center Registry. Data Centers represent the Regional Data Processing Centers (RDPC) that ARGO will support a network of. Each program registered in the program-service must belong to a single Data Center. The Data Centers have various connection details that also need to be stored.

Update the Program entity so that every Program is connected to a Data Center. This requires a change to the Program DB table to include a new property with a foreign key relationship to the Data Center entity created in ticket https://github.com/icgc-argo/program-service/issues/412 .

Required Changes

  • Update Program DB Table
  • Update Java entity for Program/DAO
  • Create migration to update existing data
    • Create an placeholder Data Center
    • Use the placeholder Data Center as the data_center_id for all existing programs

We need a placehodler DataCenter in order to modify to Program table and satisfy the mandatory ForeignKey requirement for all existing programs. After these changes are deployed, we have the opportunity to modify the placeholder Data Center to represent the initial Data Center hosting these programs.

Tickets will follow to update the RESTful endpoints for the Programs.

Updated ERD

image

Contributor guide

Open the contributing guide

First steps

  1. Read the whole issue, then the project's contributing guide.
  2. Comment on the issue to say you are picking it up — it saves two people doing the same work.
  3. Fork the repository and make your change on a branch.
  4. Open a pull request that references the issue number.

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.