summaryrefslogtreecommitdiffstats
path: root/feature-active-standby-management/src/main/feature/db/activestandbymanagement/sql/18020-activestandbymanagement.upgrade.sql
blob: 4b3375ad0d2f9c8884d73ecfb0d9b8185070d9b3 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
/*-
 * ============LICENSE_START=======================================================
 * feature-active-standby-management
 * ================================================================================
 * Copyright (C) 2017 AT&T Intellectual Property. All rights reserved.
 * ================================================================================
 * 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.
 * ============LICENSE_END=========================================================
 */

set foreign_key_checks=0; 

CREATE TABLE if not exists activestandbymanagement.DROOLSPDPENTITY 
( 
pdpId VARCHAR(255) NOT NULL, 
designated TINYINT(1) default 0 NOT NULL, 
priority INTEGER NOT NULL, 
site VARCHAR(50), 
updatedDate TIMESTAMP NOT NULL, 
designatedDate TIMESTAMP NOT NULL, 
PRIMARY KEY (pdpId) 
);

set foreign_key_checks=1;
lass="nt">chart: {{ .Chart.Name }}-{{ .Chart.Version | replace "+" "_" }} release: {{ .Release.Name }} heritage: {{ .Release.Service }} spec: replicas: {{ .Values.replicaCount }} selector: matchLabels: app: {{ include "common.name" . }} template: metadata: labels: app: {{ include "common.name" . }} release: {{ .Release.Name }} name: {{ include "common.name" . }} spec: initContainers: - command: - /bin/sh - -c - | mkdir -p /logroot/data-router/logs chmod -R 777 /logroot/data-router/logs chown -R root:root /logroot env: - name: NAMESPACE valueFrom: fieldRef: apiVersion: v1 fieldPath: metadata.namespace securityContext: privileged: true image: {{ .Values.global.dockerhubRepository | default .Values.dockerhubRepository }}/{{ .Values.global.busyboxImage | default .Values.busyboxImage }} imagePullPolicy: {{ .Values.global.pullPolicy | default .Values.pullPolicy }} name: init-sysctl volumeMounts: - name: {{ include "common.fullname" . }}-logs mountPath: /logroot/ containers: - name: {{ include "common.name" . }} image: "{{ include "common.repository" . }}/{{ .Values.image }}" imagePullPolicy: {{ .Values.global.pullPolicy | default .Values.pullPolicy }} env: - name: SERVICE_BEANS value: /opt/app/data-router/dynamic/conf - name: CONFIG_HOME value: /opt/app/data-router/config/ - name: KEY_STORE_PASSWORD value: {{ .Values.config.keyStorePassword }} - name: DYNAMIC_ROUTES value: /opt/app/data-router/dynamic/routes - name: KEY_MANAGER_PASSWORD value: {{ .Values.config.keyManagerPassword }} volumeMounts: - mountPath: /etc/localtime name: localtime readOnly: true - mountPath: /opt/app/data-router/config/auth name: {{ include "common.fullname" . }}-auth - mountPath: /opt/app/data-router/config/data-router.properties subPath: data-router.properties name: {{ include "common.fullname" . }}-properties - mountPath: /opt/app/data-router/config/schemaIngest.properties subPath: schemaIngest.properties name: {{ include "common.fullname" . }}-properties - mountPath: /opt/app/data-router/dynamic/routes/audit.route subPath: audit.route name: {{ include "common.fullname" . }}-dynamic-route - mountPath: /opt/app/data-router/dynamic/routes/poaValidation.route subPath: poaValidation.route name: {{ include "common.fullname" . }}-dynamic-route - mountPath: /opt/app/data-router/dynamic/conf/audit-bean.xml subPath: audit-bean.xml name: {{ include "common.fullname" . }}-dynamic-policy - mountPath: /opt/app/data-router/dynamic/conf/poa-validation-bean.xml subPath: poa-validation-bean.xml name: {{ include "common.fullname" . }}-dynamic-policy - mountPath: /logs/ name: {{ include "common.fullname" . }}-logs ports: - containerPort: {{ .Values.service.internalPort }} {{- if eq .Values.liveness.enabled true }} livenessProbe: tcpSocket: port: {{ .Values.service.internalPort }} initialDelaySeconds: {{ .Values.liveness.initialDelaySeconds }} periodSeconds: {{ .Values.liveness.periodSeconds }} {{ end -}} readinessProbe: tcpSocket: port: {{ .Values.service.internalPort }} initialDelaySeconds: {{ .Values.readiness.initialDelaySeconds }} periodSeconds: {{ .Values.readiness.periodSeconds }} volumes: - name: localtime hostPath: path: /etc/localtime - name: {{ include "common.fullname" . }}-auth secret: secretName: {{ include "common.fullname" . }} - name: {{ include "common.fullname" . }}-properties configMap: name: {{ include "common.fullname" . }}-prop items: - key: data-router.properties path: data-router.properties - key: schemaIngest.properties path: schemaIngest.properties - name: {{ include "common.fullname" . }}-dynamic-route configMap: name: {{ include "common.fullname" . }}-dynamic - name: {{ include "common.fullname" . }}-dynamic-policy configMap: name: {{ include "common.fullname" . }}-dynamic - name: {{ include "common.fullname" . }}-logs persistentVolumeClaim: claimName: {{ include "common.fullname" . }} restartPolicy: {{ .Values.global.restartPolicy | default .Values.restartPolicy }} imagePullSecrets: - name: "{{ include "common.namespace" . }}-docker-registry-key"