HydrologicEngineeringCenter / HydrologicEngineeringCenter/cwms-database

[FLYWAY] setup mechanism and tests for baselining existing installs

Open
#20 0 comments 0 reactions 0 assignees View on GitHub

Nobody has claimed this yet.

Dominant language
Visual Basic 6.0
Stars
4
Forks
8
Avg merge
8d 20h
Merged PRs (30d)
4

Description

NOTE: Focus will be on cloud (cwbi-dev). However we should be able to accomdate the T7s. Fortunately with the use of Flyway even if we don't go all-in on the T7s since ever change is a change it will not be difficult to create a secondary upgrade script for those usages.

Test Steps

  1. Start ready-database of last non-flyway version
  2. Perform baseline migration (over time will include making actual changes.)
  3. Run tests.

There is an option within flyway itself, baseline on migration, that needs to be set to active and with the desired version. This should be added to the cwms.Migration class.

Contributor guide

Open the contributing guide

First steps

  1. Read the whole issue, then the project's contributing guide.
  2. Comment on the issue to say you are picking it up — it saves two people doing the same work.
  3. Fork the repository and make your change on a branch.
  4. Open a pull request that references the issue number.

Research direction

Start with the cwms.Migration class and inspect how Flyway is configured for the baseline migration. Follow the listed test steps using a ready-database from the last non-Flyway version; done means baseline-on-migration uses the desired version and the migration tests pass for the cloud setup and applicable T7 usages.

Written by the indexing model from the issue text.

Assessment

Tech stack
visualbasic
Domain
database
Issue type
Feature
Difficulty
4/5
Estimated time
3-5 days
Activity status
Stale
Clarity
Mostly clear
Newbie friendliness
35/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.