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

Create Data Fix to migrate CUS records to new spar #1737

Open
4 tasks done
franTarkenton opened this issue Nov 20, 2024 · 1 comment
Open
4 tasks done

Create Data Fix to migrate CUS records to new spar #1737

franTarkenton opened this issue Nov 20, 2024 · 1 comment
Assignees
Labels
devops devops related task

Comments

@franTarkenton
Copy link
Member

franTarkenton commented Nov 20, 2024

The original data migration that moved the original spar data from the dbp01 database to the new spar postgres database only moved the A class seedlots from tested parent trees.

This ticket will create a data patch that will copy the A class records that are from Custom Seedlots (CUS) and Untested Parent trees (UPT)

Acceptance Criteria

  • Migration script is created
  • Migration script added to the nr-fsa-scripts repository
  • Scripts have been tested and verified against the local dev env
  • Test queries are defined to verify that the script completed successfully
@franTarkenton franTarkenton added the devops devops related task label Nov 20, 2024
@franTarkenton franTarkenton self-assigned this Nov 20, 2024
@franTarkenton franTarkenton moved this from New to Active in DevOps (NR) Nov 20, 2024
@franTarkenton
Copy link
Member Author

franTarkenton commented Nov 28, 2024

Package has been created and loaded to the fsa scripts repo and the branch spar-add-cus-records

Next steps:

  • @franTarkenton will remove the CUS and TPT records from the spar2 TEST database
  • @franTarkenton will run the migration on the spar2 TEST database
  • @SLDonnelly and team will verify that new records do not impact the TEST database
  • @franTarkenton run data load scripts on PROD database.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
devops devops related task
Projects
Status: Active
Development

No branches or pull requests

2 participants