3 # Copyright 2017 ZTE Corporation.
5 # Licensed under the Apache License, Version 2.0 (the "License");
6 # you may not use this file except in compliance with the License.
7 # You may obtain a copy of the License at
9 # http://www.apache.org/licenses/LICENSE-2.0
11 # Unless required by applicable law or agreed to in writing, software
12 # distributed under the License is distributed on an "AS IS" BASIS,
13 # WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
14 # See the License for the specific language governing permissions and
15 # limitations under the License.
19 HOME=`cd $DIRNAME/; pwd`
25 echo "Initializing the holmes engine management database..."
28 # if deployed using helm, use the helm-generated configuration file.
29 if [ -d /opt/hemconfig ]; then
30 cp /opt/hemconfig/onap-holmes_engine-createobj.sql "$main_path/dbscripts/postgresql/onap-holmes_engine-createobj.sql"
32 sed -i "s|DBNAME|$dbname|g" "$main_path/dbscripts/postgresql/onap-holmes_engine-createobj.sql"
33 sed -i "s|DBUSER|$user|g" "$main_path/dbscripts/postgresql/onap-holmes_engine-createobj.sql"
34 sed -i "s|DBPWD|$password|g" "$main_path/dbscripts/postgresql/onap-holmes_engine-createobj.sql"
37 cat $main_path/dbscripts/postgresql/onap-holmes_engine-createobj.sql
41 echo "password=$password"
45 if [ -z `env | grep PGPASSWORD` ]; then
46 export PGPASSWORD=$password
50 psql -U "'$user'" -p "'$port'" -h "'$host'" -d "'$dbname'" -f $main_path/dbscripts/postgresql/onap-holmes_engine-createobj.sql
51 psql -U "'$user'" -p "'$port'" -h "'$host'" -d "'$dbname'" --command 'select * from alarm_info;'
54 if [ "$need_unset"x == "1"x ]; then
58 echo "sql_result=$sql_result"
59 if [ $sql_result != 0 ] ; then
60 echo "Failed to initialize the database!"
63 echo "The database is initialized successfully!"