From 88a991b939a4c469b9d2c1c392ea4f683cdc8f7a Mon Sep 17 00:00:00 2001 From: ktimoney Date: Mon, 9 Aug 2021 17:23:35 +0100 Subject: Add db-migrator to CSIT tests Issue-ID: POLICY-3491 Change-Id: I987986da7325a040b80b031ae4e7fbf9776c4c54 Signed-off-by: ktimoney --- csit/db_migrator_policy_init.sh | 35 +++++++++++++++++++++++++++++++++++ 1 file changed, 35 insertions(+) create mode 100755 csit/db_migrator_policy_init.sh (limited to 'csit/db_migrator_policy_init.sh') diff --git a/csit/db_migrator_policy_init.sh b/csit/db_migrator_policy_init.sh new file mode 100755 index 00000000..d7a7b3f7 --- /dev/null +++ b/csit/db_migrator_policy_init.sh @@ -0,0 +1,35 @@ +#!/bin/sh +# ============LICENSE_START==================================================== +# Copyright (C) 2021 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. +# +# SPDX-License-Identifier: Apache-2.0 +# ============LICENSE_END====================================================== + +export POLICY_HOME=/opt/app/policy +export SQL_USER=${MYSQL_USER} +export SQL_PASSWORD=${MYSQL_PASSWORD} + +/opt/app/policy/bin/prepare_upgrade.sh ${SQL_DB} + +/opt/app/policy/bin/db-migrator -s ${SQL_DB} -o report + +/opt/app/policy/bin/db-migrator -s ${SQL_DB} -o upgrade +rc=$? + +/opt/app/policy/bin/db-migrator -s ${SQL_DB} -o report + +nc -l -p 6824 + +exit $rc -- cgit 1.2.3-korg