From aa86c67092daa5bd10dd6506fd33f3a6233dd281 Mon Sep 17 00:00:00 2001
From: waynedunican <wayne.dunican@est.tech>
Date: Thu, 18 Apr 2024 17:09:52 +0100
Subject: Add ACM db upgrade/downgrade to db-migrator

Issue-ID: POLICY-4934
Change-Id: Ic515eb1b2d549fdd91cff22ed6f589b673748657
Signed-off-by: waynedunican <wayne.dunican@est.tech>
---
 compose/config/clamp/AcRuntimeParameters.yaml |  2 +-
 compose/docker-compose.yml                    | 25 +++++++++++++++++++++++--
 2 files changed, 24 insertions(+), 3 deletions(-)

(limited to 'compose')

diff --git a/compose/config/clamp/AcRuntimeParameters.yaml b/compose/config/clamp/AcRuntimeParameters.yaml
index 262f10c6..c61428da 100644
--- a/compose/config/clamp/AcRuntimeParameters.yaml
+++ b/compose/config/clamp/AcRuntimeParameters.yaml
@@ -18,7 +18,7 @@ spring:
       maximumPoolSize: 10
   jpa:
     hibernate:
-      ddl-auto: update
+      ddl-auto: none
       naming:
         physical-strategy: org.hibernate.boot.model.naming.PhysicalNamingStrategyStandardImpl
         implicit-strategy: org.onap.policy.common.spring.utils.CustomImplicitNamingStrategy
diff --git a/compose/docker-compose.yml b/compose/docker-compose.yml
index 0264b290..60ed0bc7 100644
--- a/compose/docker-compose.yml
+++ b/compose/docker-compose.yml
@@ -35,7 +35,7 @@ services:
       container_name: policy-db-migrator
       hostname: policy-db-migrator
       depends_on:
-        - mariadb
+       - mariadb
       expose:
        - 6824
       env_file: ./config/db/db.conf
@@ -51,6 +51,27 @@ services:
                 '/opt/app/policy/bin/db_migrator_policy_init.sh',
                 'mariadb', '3306'
                ]
+   policy-db-migrator-clamp:
+     image: ${CONTAINER_LOCATION}onap/policy-db-migrator:${POLICY_DOCKER_VERSION}
+     container_name: policy-db-migrator-clamp
+     hostname: policy-db-migrator-clamp
+     depends_on:
+       - mariadb
+     expose:
+       - 6824
+     env_file: ./config/db/db.conf
+     environment:
+       SQL_DB: clampacm
+       SQL_HOST: mariadb
+     volumes:
+       - ./config/db-migrator/init.sh:/opt/app/policy/bin/db_migrator_policy_init.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.sh',
+       'mariadb', '3306'
+     ]
    simulator:
       image: ${CONTAINER_LOCATION}onap/policy-models-simulator:${POLICY_MODELS_VERSION}
       container_name: simulator
@@ -240,7 +261,7 @@ services:
       image: ${CONTAINER_LOCATION}onap/policy-clamp-runtime-acm:${POLICY_CLAMP_VERSION}
       container_name: policy-clamp-runtime-acm
       depends_on:
-       - mariadb
+       - policy-db-migrator-clamp
        - kafka
        - policy-clamp-ac-http-ppnt
        - policy-clamp-ac-k8s-ppnt
-- 
cgit 1.2.3-korg