3 # Copyright 2017-2021 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 rule management database..."
28 if [ -d /opt/hrmconfig ]; then
29 cp /opt/hrmconfig/onap-holmes_rulemgt-createobj.sql "$main_path/dbscripts/postgresql/onap-holmes_rulemgt-createobj.sql"
31 sed -i "s|DBNAME|$dbname|g" "$main_path/dbscripts/postgresql/onap-holmes_rulemgt-createobj.sql"
32 sed -i "s|DBUSER|$user|g" "$main_path/dbscripts/postgresql/onap-holmes_rulemgt-createobj.sql"
33 sed -i "s|DBPWD|$password|g" "$main_path/dbscripts/postgresql/onap-holmes_rulemgt-createobj.sql"
36 cat $main_path/dbscripts/postgresql/onap-holmes_rulemgt-createobj.sql
39 echo "password=$password"
43 if [ -z `env | grep PGPASSWORD` ]; then
44 export PGPASSWORD=$password
48 # Escape the single quote to avoid cause errors when executing the scripts.
49 password=`sed -rn "s/.+ ('.+') .+/\1/p" $main_path/dbscripts/postgresql/onap-holmes_rulemgt-createobj.sql`
50 password=${password:1:-1}
51 password_e=`echo $password | sed "s#'#''#g"`
52 sed -i "s#$password#$password_e#" $main_path/dbscripts/postgresql/onap-holmes_rulemgt-createobj.sql
54 psql -U "$user" -p "$port" -h "$host" -d "$dbname" -f $main_path/dbscripts/postgresql/onap-holmes_rulemgt-createobj.sql
55 psql -U "$user" -p "$port" -h "$host" -d "$dbname" --command 'select * from aplus_rule;'
58 if [ "$need_unset"x = "1"x ]; then
62 echo "sql_result=$sql_result"
63 if [ $sql_result != 0 ] ; then
64 echo "Failed to initialize the database!"
67 echo "The database is initialized successfully!"