summaryrefslogtreecommitdiffstats
path: root/openecomp-be/dist/sdc-onboard-db-init-docker/artifacts/startup.sh
diff options
context:
space:
mode:
authorandre.schmid <andre.schmid@est.tech>2021-08-12 23:05:15 +0100
committerMichael Morris <michael.morris@est.tech>2021-08-13 16:14:07 +0000
commitb8bfef3a009922db72c1a618211ce03c07683e58 (patch)
treeb81c7855ba3308249d1608df5212a1f36705e78c /openecomp-be/dist/sdc-onboard-db-init-docker/artifacts/startup.sh
parentb1bfe8bfae834f92577b04a016c0c7dade388941 (diff)
Implement simple onboarding cassandra upgrade
Introduces a folder to hold cql scripts to upgrade the onboarding cassandra. The files will be copied to the docker and executed in alphabetical order. The suggested pattern for the file names is YYYYMMDD-changeName.cql. Change-Id: Ia32a63ec5ab4417cf0df8bb5536c7f041e2327c9 Issue-ID: SDC-3669 Signed-off-by: andre.schmid <andre.schmid@est.tech>
Diffstat (limited to 'openecomp-be/dist/sdc-onboard-db-init-docker/artifacts/startup.sh')
-rw-r--r--openecomp-be/dist/sdc-onboard-db-init-docker/artifacts/startup.sh42
1 files changed, 27 insertions, 15 deletions
diff --git a/openecomp-be/dist/sdc-onboard-db-init-docker/artifacts/startup.sh b/openecomp-be/dist/sdc-onboard-db-init-docker/artifacts/startup.sh
index 92bf869ccc..3856e10f89 100644
--- a/openecomp-be/dist/sdc-onboard-db-init-docker/artifacts/startup.sh
+++ b/openecomp-be/dist/sdc-onboard-db-init-docker/artifacts/startup.sh
@@ -1,38 +1,50 @@
#!/bin/sh
-
-cd /home/sdc
+SDC_HOME="/home/sdc"
+cd $SDC_HOME || { echo "$(date) Failed to access directory $SDC_HOME"; exit 1; }
CS_PORT=""
CS_HOST=127.0.0.1
-if [ ! -z "${CS_HOST_IP}" ]; then
+if [ -n "${CS_HOST_IP}" ]; then
CS_HOST=$CS_HOST_IP
fi
-if [ ! -z "${CS_HOST_PORT}" ]; then
+if [ -n "${CS_HOST_PORT}" ]; then
CS_PORT=$CS_HOST_PORT
fi
-echo "[Info] Going to initialize sdc onboard cassandra: user=$SDC_USER; host=$CS_HOST; port=$CS_PORT"
+echo "$(date) [Info] Going to initialize sdc onboard cassandra: user=$SDC_USER; host=$CS_HOST; port=$CS_PORT"
-echo "[Info] Initializing onboard keyspaces"
-date;
-cqlsh -u $SDC_USER -p $SDC_PASSWORD -f init_keyspaces.cql $CS_HOST $CS_PORT
+echo "$(date) [Info] Initializing onboard keyspaces"
+cqlsh -u "$SDC_USER" -p "$SDC_PASSWORD" -f init_keyspaces.cql "$CS_HOST" "$CS_PORT"
rc=$?
-date;
if [ $rc != 0 ]; then
- echo "[Error] Failed to initialize onboard keyspaces";
+ echo "$(date) [Error] Failed to initialize onboard keyspaces";
exit $rc;
fi
+echo "$(date) [Info] Finished initializing onboard keyspaces"
-echo "[Info] Initializing onboard schemas"
-date;
-cqlsh -u $SDC_USER -p $SDC_PASSWORD -f init_schemas.cql $CS_HOST $CS_PORT
+echo "$(date) [Info] Initializing onboard schemas"
+cqlsh -u "$SDC_USER" -p "$SDC_PASSWORD" -f init_schemas.cql "$CS_HOST" "$CS_PORT"
rc=$?
-date;
if [ $rc != 0 ]; then
- echo "[Error] Failed to initialize onboard schemas";
+ echo "$(date) [Error] Failed to initialize onboard schemas";
exit $rc;
fi
+echo "$(date) [Info] Finished initializing onboard schemas"
+
+echo "$(date) [Info] Upgrading onboard schemas"
+for entry in "$SDC_HOME/upgrade-scripts"/*
+do
+ echo "$(date) Running upgrade file '$entry'"
+ cqlsh -u "$SDC_USER" -p "$SDC_PASSWORD" -f "$entry" "$CS_HOST" "$CS_PORT"
+ rc=$?
+ if [ $rc != 0 ]; then
+ echo "$(date) [Warn] Upgrade failed for file '$entry'. It is possible that the upgrade was previously applied.";
+ fi
+ echo "$(date) Successfully ran upgrade file '$entry'"
+done
+
+echo "$(date) [Info] Onboarding init was successful" \ No newline at end of file