We're updating the issue view to help you get more done. 

Write deployment script to wipe RDS data, apply on Test server

Description

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.

Acceptance Criteria

  • 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

Status

Assignee

Josh Zamor

Reporter

Brandon Bowersox-Johnson

Labels

Story Points

3

Components

Sprint

None

Fix versions

Priority

Blocker