Removing portal schema from configmap

-Trying a new way to initialize maria db's.
-Docker image contains project sources and sql files are fetched
and executed agains't the target database.
-duplicates are silently ignored.
-A script that takes some basic params will do the heavy lifting
-A 2nd job to make some OOM specific changes (carry over from amsterdam)
-docker image has been pushed to oomk8s under the 2.0.0 number

Issue-ID: OOM-858

Change-Id: I56d0c9c5aa1d3c4a9df2998634b9147db626d1fb
Signed-off-by: Mandeep Khinda <mandeep.khinda@amdocs.com>

1 files changed, 90 insertions, 0 deletions

diff --git a/kubernetes/portal/charts/portal-mariadb/templates/job.yaml b/kubernetes/portal/charts/portal-mariadb/templates/job.yaml
new file mode 100644
index 0000000000..75d5bb0874
--- /dev/null
+++ b/kubernetes/portal/charts/portal-mariadb/templates/job.yaml
@@ -0,0 +1,90 @@
+# Copyright © 2017 Amdocs, Bell Canada
+#
+# 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.
+
+apiVersion: batch/v1
+kind: Job
+metadata:
+  name: {{ include "common.fullname" . }}-config
+  namespace: {{ include "common.namespace" . }}
+  labels:
+    app: {{ include "common.name" . }}-job
+    chart: {{ .Chart.Name }}-{{ .Chart.Version | replace "+" "_" }}
+    release: {{ .Release.Name }}
+    heritage: {{ .Release.Service }}
+spec:
+  template:
+    metadata:
+      labels:
+        app: {{ include "common.name" . }}-job
+        release: {{ .Release.Name }}
+    spec:
+      restartPolicy: Never
+      initContainers:
+      - name: {{ include "common.name" . }}-init-readiness
+        image: "{{ .Values.global.readinessRepository }}/{{ .Values.global.readinessImage }}"
+        imagePullPolicy: {{ .Values.global.pullPolicy | default .Values.pullPolicy }}
+        command:
+        - /root/ready.py
+        args:
+        - --container-name
+        - {{ include "common.name" . }}
+        env:
+        - name: NAMESPACE
+          valueFrom:
+            fieldRef:
+              apiVersion: v1
+              fieldPath: metadata.namespace
+      containers:
+      - name: {{ include "common.name" . }}-job
+        image: "{{ .Values.global.repository | default .Values.dockerHubRepository }}/{{ .Values.mariadbInitImage }}"
+        imagePullPolicy: {{ .Values.global.pullPolicy | default .Values.pullPolicy }}
+        env:
+        - name: DB_HOST
+          value: "{{ .Release.Name }}-{{ .Values.service.name }}"
+        - name: DB_USER
+          value: {{ .Values.config.mariadbUser }}
+        - name: DB_PASS
+          valueFrom:
+            secretKeyRef: {name: {{ include "common.fullname" . }}, key: db-root-password}
+        - name: SQL_SRC_DIR
+          value: {{ .Values.config.sqlSourceDirectory }}
+      - name: {{ include "common.name" . }}-oom-update-job
+        image: "{{ .Values.global.repository | default .Values.dockerHubRepository }}/{{ .Values.mariadbInitImage }}"
+        imagePullPolicy: {{ .Values.global.pullPolicy | default .Values.pullPolicy }}
+        env:
+        - name: DB_HOST
+          value: "{{ .Release.Name }}-{{ .Values.service.name }}"
+        - name: DB_USER
+          value: {{ .Values.config.mariadbUser }}
+        - name: DB_PORT
+          value: "{{ .Values.service.internalPort }}"
+        - name: DB_PASS
+          valueFrom:
+            secretKeyRef: {name: {{ include "common.fullname" . }}, key: db-root-password}
+        command:
+        - /bin/sh
+        - -x
+        - -c
+        - "mysql -vv --user=$DB_USER --password=$DB_PASS --host=$DB_HOST --port=$DB_PORT < /tmp/oom_updates.sql"
+        volumeMounts:
+        - name: portal-mariadb-sql
+          mountPath: /tmp/oom_updates.sql
+          subPath: oom_updates.sql
+      volumes:
+      - name: portal-mariadb-sql
+        configMap:
+          name: {{ include "common.fullname" . }}-mariadb
+      imagePullSecrets:
+      - name: "{{ include "common.namespace" . }}-docker-registry-key"
+      restartPolicy: Never
\ No newline at end of file