Support for Integration tests in github actions #115
Description
For awareness a "ready-to-go" CWMS Database is now available as a docker image from the hec public registry.
registry-public.hecdev.net/cwms/database-ready-ora-23.5:latest-dev (named versions coming soon)
By the end of this week there should also be a publicly accessible image for the data API. URL will be provided here when it's available. Maybe the registry above, ghcr.io, or possibly both.
We have used https://testcontainers.org to great success in java development, CDA itself, OpenDCS, the various data access layers.
That same group provides a library for python as well, https://github.com/testcontainers/testcontainers-python, that integrates with the currently chosen test framework.
By way of guidance, while the ready database does start quickly a test run should ensure only one instance is created and reused for all tests. It's a more realistic test of the integration, and helps expose possible issues with how data is stored and retrieved.