Update opencdms-api's deploy_stable.yml to deploy postgresl, mysql & oracle containers from opencdms-test-data's /docker-compose.yml on publish (release). These will contain:
CliDE and WMDR schemas for postgresql
Climsoft and MCH schemas for MariaDB
MIDAS Core schema for Oracle XE
Note: the data in the contains above should not persist and should be lost on each deployment (replaced by the default test data)
Remove climsoft-db-snapshot.sql and create_mch_english_basic_tables.sql from opencdms-api repo (since we will be using versions from opencdms-test-data's /schemas instead)
In addition - is it possible to give direct access to all three DMBS (postgres, mariadb and oracle) to external collaborators (some experts would like to be able to log into those databases and look at the data models)
deploy_latest.ymlaction completelydeploy_stable.ymlto deploypostgresl,mysql&oraclecontainers from opencdms-test-data's/docker-compose.ymlon publish (release). These will contain:Note: the data in the contains above should not persist and should be lost on each deployment (replaced by the default test data)
climsoft-db-dummy-data.sqlto opencdms-test-data's /opencdms_test_data/data/climsoft4/ and apply this to groups/Dockerfile.mysql and docker/Dockerfile.climsoft-4.1.1climsoft-db-snapshot.sqlandcreate_mch_english_basic_tables.sqlfrom opencdms-api repo (since we will be using versions from opencdms-test-data's /schemas instead)In addition - is it possible to give direct access to all three DMBS (postgres, mariadb and oracle) to external collaborators (some experts would like to be able to log into those databases and look at the data models)