Once Flyway database migrations are in place, we need a script to allow us to wipe out all schema and data from a database (such as the RDS instance).
Apply this script into the deployment configuration in Jenkins for the test.openlmis.org instance. We want the Test server to basically get emptied each time Test is deployed. Each service will be re-creating its own schema and re-adding its own bootstrap data, and probably seed/demo data.
This script goes in the openlmis-deployment repo.
Create this script
Use the DB credentials from the same .env file that Blue uses to start
Update Test environment configuration to use this
Update UAT to provide an OPTIONAL way to wipe it when needed (a button to push in Jenkins would be great)
Update relevant documentation, perhaps on the CI/CD wiki page and/or the Flyway docs