CSITs for db-migrator

- Added test to confirm databases are created
- Added test for api healthcehck

Issue-ID: POLICY-2715
Signed-off-by: Wayne Dunican <wayne.dunican@est.tech>
Change-Id: I8ef9f67bf50d2fcbf7c7db2c78370f6b277e5993

1 files changed, 69 insertions, 0 deletions

diff --git a/csit/compose-postgres.yml b/csit/compose-postgres.yml
new file mode 100644
index 00000000..6c5e00a7
--- /dev/null
+++ b/csit/compose-postgres.yml
@@ -0,0 +1,69 @@
+#
+# ===========LICENSE_START====================================================
+#  Copyright (C) 2022 Nordix Foundation.
+# ============================================================================
+# Licensed under the Apache License, Version 2.0 (the "License");
+# you may not use this file except in compliance with the License.
+# You may obtain a copy of the License at
+#
+#      http://www.apache.org/licenses/LICENSE-2.0
+#
+# Unless required by applicable law or agreed to in writing, software
+# distributed under the License is distributed on an "AS IS" BASIS,
+# WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+# See the License for the specific language governing permissions and
+# limitations under the License.
+# ============LICENSE_END=====================================================
+#
+version: '2'
+services:
+  postgres:
+    image: nexus3.onap.org:10001/library/postgres:${POLICY_POSTGRES_VER}
+    container_name: postgres
+    hostname: postgres
+    command: ['--idle_in_transaction_session_timeout=28800']
+    env_file: config/db-pg/db-pg.conf
+    volumes:
+      - ./config/db-pg:/docker-entrypoint-initdb.d:ro
+    expose:
+      - 5432
+  policy-db-migrator-postgres:
+    image: nexus3.onap.org:10001/onap/policy-db-migrator:${POLICY_DOCKER_VERSION}
+    container_name: policy-db-migrator-postgres
+    hostname: policy-db-migrator-postgres
+    depends_on:
+      - postgres
+    expose:
+      - 6824
+    env_file: config/db-pg/db-pg.conf
+    environment:
+      SQL_DB: policyadmin
+      SQL_HOST: postgres
+      PGPASSWORD: policy_user
+    volumes:
+      - ./db_migrator_policy_init_pg.sh:/opt/app/policy/bin/db_migrator_policy_init_pg.sh:ro
+      - ./wait_for_port.sh:/opt/app/policy/bin/wait_for_port.sh:ro
+    entrypoint: /opt/app/policy/bin/wait_for_port.sh
+    command: [
+      '-c',
+      '/opt/app/policy/bin/db_migrator_policy_init_pg.sh',
+      'postgres', '5432'
+    ]
+  api:
+    image: nexus3.onap.org:10001/onap/policy-api:${POLICY_API_VERSION}
+    container_name: policy-api
+    depends_on:
+      - policy-db-migrator-postgres
+    hostname: policy-api
+    expose:
+      - 6980
+    volumes:
+      - ./config/ks.jks:/opt/app/policy/api/etc/ssl/policy-keystore:ro
+      - ./config/policy-truststore:/opt/app/policy/api/etc/ssl/policy-truststore:ro
+      - ./wait_for_port.sh:/opt/app/policy/api/bin/wait_for_port.sh:ro
+    entrypoint: ./wait_for_port.sh
+    command: [
+      '-c', './policy-api.sh',
+      'postgres', '5432',
+      'policy-db-migrator-postgres', '6824'
+    ]
\ No newline at end of file