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

Refactor conditions.category migration #92

Closed
robertandremitchell opened this issue Oct 30, 2024 — with Linear · 2 comments
Closed

Refactor conditions.category migration #92

robertandremitchell opened this issue Oct 30, 2024 — with Linear · 2 comments
Assignees

Comments

Copy link
Collaborator

Per this PR: #88

We have some ongoing work around refactoring all of our migration work. For now, we are adding that via a CSV provided by APHL in a migration.

However, that adds a volume to the migration step that we would prefer not to have. Two potential paths forward:

  1. Convert the CSV dynamically to a series of INSERT statements that then do the UPDATE to the conditions table to avoid having a volume. This might involve writing a script to make these dynamic INSERT statements with each new publication of the eRSD to avoid as much manual editing as possible.
  2. (More ideal) Work with contacts at APHL to get category represented in the eRSD data so that it can be built out as a column at the same time during database creation.
Copy link

linear bot commented Oct 30, 2024

@robertandremitchell
Copy link
Collaborator Author

fixed as part of work on other ticket.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

1 participant