{{/*
# Copyright © 2018 Amdocs, Bell Canada
# Modifications Copyright © 2020 AT&T Intellectual Property
# Modifications 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.
*/}}

{{ if not .Values.global.postgres.localCluster }}
apiVersion: batch/v1
kind: Job
metadata:
  name: {{ include "common.fullname" . }}-galera-init
  namespace: {{ include "common.namespace" . }}
  labels:
    app: {{ include "common.name" . }}-galera-init
    release: {{ include "common.release" . }}
spec:
  template:
    metadata:
      labels:
        app: {{ include "common.name" . }}-galera-init
        release: {{ include "common.release" . }}
      name: {{ include "common.name" . }}-galera-init
    spec:
      {{- include "common.imagePullSecrets" . | nindent 6 }}
      initContainers:
      {{ include "common.readinessCheck.waitFor" (dict "dot" . "wait_for" .Values.readinessCheck.wait_for_mariadb ) | indent 6 | trim }}
      containers:
      - name: {{ include "common.name" . }}-galera-config
        image: {{ include "repositoryGenerator.image.mariadb" . }}
        imagePullPolicy: {{ .Values.global.pullPolicy | default .Values.pullPolicy }}
        volumeMounts:
        - mountPath: /dbcmd-config/db.sh
          name: {{ include "common.fullname" . }}-config
          subPath: db.sh
        command:
        - /bin/sh
        - -cx
        - |
           {{- if include "common.onServiceMesh" . }}
           echo "waiting 15s for istio side cars to be up"; sleep 15s;{{- end }}
           /dbcmd-config/db.sh
        env:
        - name: MYSQL_ROOT_PASSWORD
          {{- include "common.secret.envFromSecretFast" (dict "global" . "uid" "db-root-password" "key" "password") | indent 10 }}
        - name: MYSQL_HOST
          value: "{{ index .Values "mariadb-galera" "service" "name" }}"
        - name: MYSQL_USER
          {{- include "common.secret.envFromSecretFast" (dict "global" . "uid" "db-secret" "key" "login") | indent 10 }}
        - name: MYSQL_PORT
          value: "{{ index .Values "mariadb-galera" "service" "internalPort" }}"
        resources: {{ include "common.resources" . | nindent 10 }}
      {{- if (include "common.onServiceMesh" .) }}
      - name: policy-service-mesh-wait-for-job-container
        image: {{ include "repositoryGenerator.image.quitQuit" . }}
        imagePullPolicy: Always
        command:
        - /bin/sh
        - "-c"
        args:
        - echo "waiting 10s for istio side cars to be up"; sleep 10s;
          /app/ready.py --service-mesh-check {{ include "common.name" . }}-galera-config -t 45;
        env:
        - name: NAMESPACE
          valueFrom:
            fieldRef:
              apiVersion: v1
              fieldPath: metadata.namespace
      {{- end }}
      restartPolicy: Never
      serviceAccountName: {{ include "common.fullname" (dict "suffix" "read" "dot" . )}}
      volumes:
        - name: {{ include "common.fullname" . }}-config
          configMap:
            name: {{ include "common.fullname" . }}-db-configmap
            defaultMode: 0755
            items:
              - key: db.sh
                path: db.sh
{{ end }}

{{ if .Values.global.postgres.localCluster }}
---
apiVersion: batch/v1
kind: Job
metadata:
  name: {{ include "common.fullname" . }}-pg-init
  namespace: {{ include "common.namespace" . }}
  labels:
    app: {{ include "common.name" . }}-pg-init
    release: {{ include "common.release" . }}
spec:
  template:
    metadata:
      labels:
        app: {{ include "common.name" . }}-pg-init
        release: {{ include "common.release" . }}
      name: {{ include "common.name" . }}-pg-init
    spec:
      {{- include "common.imagePullSecrets" . | nindent 6 }}
      initContainers:
      {{ include "common.readinessCheck.waitFor" (dict "dot" . "wait_for" .Values.readinessCheck.wait_for_postgres ) | indent 6 | trim }}
      containers:
      - name: {{ include "common.name" . }}-pg-config
        image: {{ include "repositoryGenerator.repository" . }}/{{ .Values.postgresImage }}
        imagePullPolicy: {{ .Values.global.pullPolicy | default .Values.pullPolicy }}
        volumeMounts:
          - mountPath: /docker-entrypoint-initdb.d/db-pg.sh
            name: {{ include "common.fullname" . }}-config
            subPath: db-pg.sh
        command:
          - /bin/sh
          - -cx
          - |
             {{- if include "common.onServiceMesh" . }}
             echo "waiting 15s for istio side cars to be up"; sleep 15s;{{- end }}
             /docker-entrypoint-initdb.d/db-pg.sh
        env:
          - name: PG_ADMIN_PASSWORD
            {{- include "common.secret.envFromSecretFast" (dict "global" . "uid" "db-root-password" "key" "password") | indent 12 }}
          - name: PG_HOST
            value: "{{ .Values.postgres.service.name2 }}"
          - name: PG_USER
            {{- include "common.secret.envFromSecretFast" (dict "global" . "uid" "db-secret" "key" "login") | indent 12 }}
          - name: PG_USER_PASSWORD
            {{- include "common.secret.envFromSecretFast" (dict "global" . "uid" "db-secret" "key" "password") | indent 12 }}
          - name: PG_PORT
            value: "{{ .Values.postgres.service.internalPort }}"
        resources: {{ include "common.resources" . | nindent 10 }}
      {{- if (include "common.onServiceMesh" .) }}
      - name: policy-service-mesh-wait-for-job-container
        image: {{ include "repositoryGenerator.image.quitQuit" . }}
        imagePullPolicy: Always
        command:
        - /bin/sh
        - "-c"
        args:
        - echo "waiting 10s for istio side cars to be up"; sleep 10s;
          /app/ready.py --service-mesh-check {{ include "common.name" . }}-pg-config -t 45;
        env:
        - name: NAMESPACE
          valueFrom:
            fieldRef:
              apiVersion: v1
              fieldPath: metadata.namespace
      {{- end }}
      restartPolicy: Never
      serviceAccountName: {{ include "common.fullname" (dict "suffix" "read" "dot" . )}}
      volumes:
        - name: {{ include "common.fullname" . }}-config
          configMap:
            name: {{ include "common.fullname" . }}-db-configmap
            defaultMode: 0755
            items:
              - key: db-pg.sh
                path: db-pg.sh
{{ end }}

---
{{ if not .Values.global.postgres.localCluster }}
apiVersion: batch/v1
kind: Job
metadata:
  name: {{ include "common.fullname" . }}-galera-config
  namespace: {{ include "common.namespace" . }}
  labels:
    app: {{ include "common.name" . }}-galera-config
    release: {{ include "common.release" . }}
spec:
  template:
    metadata:
      labels:
        app: {{ include "common.name" . }}-galera-config
        release: {{ include "common.release" . }}
      name: {{ include "common.name" . }}-galera-config
    spec:
      {{- include "common.imagePullSecrets" . | nindent 6 }}
      initContainers:
      - name: {{ include "common.name" . }}-init-readiness
        image: {{ include "repositoryGenerator.image.readiness" . }}
        imagePullPolicy: {{ .Values.global.pullPolicy | default .Values.pullPolicy }}
        command:
        - /app/ready.py
        args:
        - --job-name
        - {{ include "common.fullname" . }}-galera-init
        env:
        - name: NAMESPACE
          valueFrom:
            fieldRef:
              apiVersion: v1
              fieldPath: metadata.namespace
        resources:
          limits:
            cpu: "100m"
            memory: "500Mi"
          requests:
            cpu: "3m"
            memory: "20Mi"
      containers:
      - name: {{ include "common.name" . }}-galera-db-migrator
        image: {{ include "repositoryGenerator.repository" . }}/{{ .Values.dbmigrator.image }}
        imagePullPolicy: {{ .Values.global.pullPolicy | default .Values.pullPolicy }}
        volumeMounts:
        - mountPath: /dbcmd-config/db_migrator_policy_init.sh
          name: {{ include "common.fullname" . }}-config
          subPath: db_migrator_policy_init.sh
        command:
        - /bin/sh
        - -cx
        - |
           {{- if include "common.onServiceMesh" . }}
           echo "waiting 15s for istio side cars to be up"; sleep 15s;{{- end }}
           /dbcmd-config/db_migrator_policy_init.sh
        env:
        - name: SQL_HOST
          value: "{{ index .Values "mariadb-galera" "service" "name" }}"
        - name: SQL_USER
          {{- include "common.secret.envFromSecretFast" (dict "global" . "uid" "db-secret" "key" "login") | indent 10 }}
        - name: SQL_PASSWORD
          {{- include "common.secret.envFromSecretFast" (dict "global" . "uid" "db-secret" "key" "password") | indent 10 }}
        - name: SQL_DB
          value: {{ .Values.dbmigrator.schema }}
        - name: POLICY_HOME
          value: {{ .Values.dbmigrator.policy_home }}
        - name: SCRIPT_DIRECTORY
          value: "sql"
        resources: {{ include "common.resources" . | nindent 10 }}
      {{- if (include "common.onServiceMesh" .) }}
      - name: policy-service-mesh-wait-for-job-container
        image: {{ include "repositoryGenerator.image.quitQuit" . }}
        imagePullPolicy: Always
        command:
        - /bin/sh
        - "-c"
        args:
        - echo "waiting 10s for istio side cars to be up"; sleep 10s;
          /app/ready.py --service-mesh-check {{ include "common.name" . }}-galera-db-migrator -t 45;
        env:
        - name: NAMESPACE
          valueFrom:
            fieldRef:
              apiVersion: v1
              fieldPath: metadata.namespace
      {{- end }}
      restartPolicy: Never
      serviceAccountName: {{ include "common.fullname" (dict "suffix" "read" "dot" . )}}
      volumes:
        - name: {{ include "common.fullname" . }}-config
          configMap:
            name: {{ include "common.fullname" . }}-db-configmap
            defaultMode: 0755
            items:
              - key: db_migrator_policy_init.sh
                path: db_migrator_policy_init.sh
{{ end }}
{{ if .Values.global.postgres.localCluster }}
---
apiVersion: batch/v1
kind: Job
metadata:
  name: {{ include "common.fullname" . }}-pg-config
  namespace: {{ include "common.namespace" . }}
  labels:
    app: {{ include "common.name" . }}-pg-config
    release: {{ include "common.release" . }}
spec:
  template:
    metadata:
      labels:
        app: {{ include "common.name" . }}-pg-config
        release: {{ include "common.release" . }}
      name: {{ include "common.name" . }}-pg-config
    spec:
      {{- include "common.imagePullSecrets" . | nindent 6 }}
      initContainers:
      - name: {{ include "common.name" . }}-init-readiness
        image: {{ include "repositoryGenerator.image.readiness" . }}
        imagePullPolicy: {{ .Values.global.pullPolicy | default .Values.pullPolicy }}
        command:
        - /app/ready.py
        args:
        - --job-name
        - {{ include "common.fullname" . }}-pg-init
        env:
        - name: NAMESPACE
          valueFrom:
            fieldRef:
              apiVersion: v1
              fieldPath: metadata.namespace
        resources:
          limits:
            cpu: "100m"
            memory: "500Mi"
          requests:
            cpu: "3m"
            memory: "20Mi"
      containers:
      - name: {{ include "common.name" . }}-pg-db-migrator
        image: {{ include "repositoryGenerator.repository" . }}/{{ .Values.dbmigrator.image }}
        imagePullPolicy: {{ .Values.global.pullPolicy | default .Values.pullPolicy }}
        volumeMounts:
          - mountPath: /dbcmd-config/db_migrator_pg_policy_init.sh
            name: {{ include "common.fullname" . }}-config
            subPath: db_migrator_pg_policy_init.sh
        command:
          - /bin/sh
          - -cx
          - |
             {{- if include "common.onServiceMesh" . }}
             echo "waiting 15s for istio side cars to be up"; sleep 15s;{{- end }}
             /dbcmd-config/db_migrator_pg_policy_init.sh
        env:
        - name: SQL_HOST
          value: "{{ .Values.postgres.service.name2 }}"
        - name: SQL_USER
          {{- include "common.secret.envFromSecretFast" (dict "global" . "uid" "db-secret" "key" "login") | indent 10 }}
        - name: SQL_PASSWORD
          {{- include "common.secret.envFromSecretFast" (dict "global" . "uid" "db-secret" "key" "password") | indent 10 }}
        - name: SQL_DB
          value: {{ .Values.dbmigrator.schema }}
        - name: POLICY_HOME
          value: {{ .Values.dbmigrator.policy_home }}
        - name: SCRIPT_DIRECTORY
          value: "postgres"
        - name: PGPASSWORD
          {{- include "common.secret.envFromSecretFast" (dict "global" . "uid" "db-secret" "key" "password") | indent 10 }}
        resources: {{ include "common.resources" . | nindent 10 }}
      {{- if (include "common.onServiceMesh" .) }}
      - name: policy-service-mesh-wait-for-job-container
        image: {{ include "repositoryGenerator.image.quitQuit" . }}
        imagePullPolicy: Always
        command:
        - /bin/sh
        - "-c"
        args:
        - echo "waiting 10s for istio side cars to be up"; sleep 10s;
          /app/ready.py --service-mesh-check {{ include "common.name" . }}-pg-db-migrator -t 45;
        env:
        - name: NAMESPACE
          valueFrom:
            fieldRef:
              apiVersion: v1
              fieldPath: metadata.namespace
      {{- end }}
      restartPolicy: Never
      serviceAccountName: {{ include "common.fullname" (dict "suffix" "read" "dot" . )}}
      volumes:
        - name: {{ include "common.fullname" . }}-config
          configMap:
            name: {{ include "common.fullname" . }}-db-configmap
            defaultMode: 0755
            items:
              - key: db_migrator_pg_policy_init.sh
                path: db_migrator_pg_policy_init.sh
{{ end }}