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.

Sign up for GitHub

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

Jump to bottom

rename db table ZipEndpoint to ReplicationEndpoint and some column renames #2060

Open
1 of 14 tasks
ndushay opened this issue Nov 22, 2022 · 1 comment
Open
1 of 14 tasks

rename db table ZipEndpoint to ReplicationEndpoint and some column renames #2060

ndushay opened this issue Nov 22, 2022 · 1 comment
Labels
refactor architecture, refactoring, style, etc.

Comments

@ndushay
Copy link
Contributor

ndushay commented Nov 22, 2022 •
edited
Loading

from storytime 2022-11-21

Notes:

  • be sure to have a clean rollback path with the db migration.
  • have ops take a full backup of prod, while jobs are stopped, before migrating db.
  • checklist for doing prescat db migrations: https://github.com/sul-dlss/preservation_catalog/wiki/DB-Migration-Checklist
  • preservation policy removal from db and switching to sidekiq instead of resque should happen in PROD before this change is ported to prod.

This ticket's work:

  • table rename:
    • ZipEndpoint table becomes ReplicationEndpoint table
    • column "delivery_class" becomes "delivery_job_class"
    • column "endpoint_node" becomes "endpoint_host"
    • column "storage_location" becomes "bucket"
  • Then, change model class name and relevant column uses.
  • Then, change variables referring to model class and columns.
  • Then do a case insensitive search on "zipendpoint" and "zip_endpoint" and change any remaining instances found.
  • Then do similar searches in github.com for repo to find wiki pages to update
  • Perform the migration, per above.
@ndushay ndushay added the refactor architecture, refactoring, style, etc. label Nov 22, 2022
@ndushay ndushay changed the title rename table ZipEndpoint to ReplicationEndpoint and some column renames rename db table ZipEndpoint to ReplicationEndpoint and some column renames Nov 22, 2022
@ndushay
Copy link
Contributor Author

ndushay commented Dec 5, 2022 •
edited
Loading

NOTE: wait for sidekiq to replace redis (#1984) in production before this change is merged to prod!

done a while back.

@ndushay ndushay assigned ndushay and unassigned ndushay Jan 25, 2023
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
refactor architecture, refactoring, style, etc.
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
1 participant
@ndushay