summaryrefslogtreecommitdiffstats
path: root/kubernetes/vid/resources/config/db_cmd.sh
blob: daa1f8b6ea8469279e081c526b41772bc5402745 (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
35
36
37
38
39
40
41
42
43
44
45
#!/bin/sh
{{/*
# Copyright © 2018 AT&T
# Copyright © 2020 Aarna Networks
#
# 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.
*/}}

DB={{index .Values "mariadb-galera" "db" "name" | upper }}
eval "MYSQL_USER=\$MYSQL_USER_${DB}"
eval "MYSQL_PASSWORD=\$MYSQL_PASSWORD_${DB}"

#echo "Going to run mysql ${DB} -u${MYSQL_USER} -p${MYSQL_PASSWORD} -h${DB_HOST} -P${DB_PORT} ..."
mysql -u${MYSQL_USER} -p${MYSQL_PASSWORD} -h${DB_HOST} -P${DB_PORT} <<'EOD'
CREATE TABLE IF NOT EXISTS `{{index .Values "mariadb-galera" "db" "name" }}`.`schema_info` (
`SCHEMA_ID` VARCHAR(25) NOT NULL,
`SCHEMA_DESC` VARCHAR(75) NOT NULL,
`DATASOURCE_TYPE` VARCHAR(100) NULL DEFAULT NULL,
`CONNECTION_URL` VARCHAR(200) NOT NULL,
`USER_NAME` VARCHAR(45) NOT NULL,
`PASSWORD` VARCHAR(45) NULL DEFAULT NULL,
`DRIVER_CLASS` VARCHAR(100) NOT NULL,
`MIN_POOL_SIZE` INT(11) NOT NULL,
`MAX_POOL_SIZE` INT(11) NOT NULL,
`IDLE_CONNECTION_TEST_PERIOD` INT(11) NOT NULL)
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8;
EOD

if [ $? -ne 0 ];then
        echo "ERROR: Failed to run cmd vid-pre-init.sql"
        exit 1
else
        echo "INFO: Database initialized successfully"
fi