Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Update Program Entity - All Programs belong to 1 Data Center #413

Open
5 tasks done
joneubank opened this issue Aug 30, 2023 · 0 comments
Open
5 tasks done

Update Program Entity - All Programs belong to 1 Data Center #413

joneubank opened this issue Aug 30, 2023 · 0 comments
Assignees
Labels
new-feature Request is a new feature

Comments

@joneubank
Copy link
Member

joneubank commented Aug 30, 2023

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 #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

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
new-feature Request is a new feature
Projects
None yet
Development

No branches or pull requests

2 participants