Script Data Imports #43
Description
Summary
We need scripts to import data from the old database, which is hosted in Azure.
Why
Real data will be useful at various points in development, testing, and stakeholder review/approval, but in the end we will be replacing the old app with MedStick, which must be fully populated with the correct data.
We need script to allow us to do this at various points in the process, culminating in the launch.
At no point should this process expose their data. No import files can be committed to the repo.
Details
Languages and regions are relatively fixed, don't have security issues, and can be brought in via seeds. Those are being handled in another issue.
This issue stops short of bringing in the training resource media files (CMEFile in the old schema). Those will be handled in another issue.
This issue also does not handle tags and their associations. We will handle those later.
The old system has user data in the providers table. Those will be parsed into users.
Criteria for Completion
- A process is in place for importing data from the old system, covering all:
- Providers
- Provider Region associations
- Users
- ProviderUser associations
- Topics
- LanguageTopic associations
- The script has test coverage