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 rule management database..."
28 sed -i "s|DBNAME|$dbname|g" "$main_path/dbscripts/postgresql/onap-holmes_rulemgt-createobj.sql"
29 sed -i "s|DBUSER|$user|g" "$main_path/dbscripts/postgresql/onap-holmes_rulemgt-createobj.sql"
30 sed -i "s|DBPWD|$password|g" "$main_path/dbscripts/postgresql/onap-holmes_rulemgt-createobj.sql"
32 cat $main_path/dbscripts/postgresql/onap-holmes_rulemgt-createobj.sql
35 echo "password=$password"
38 export PGPASSWORD=$password
39 psql -U $user -p $port -h $host -d $dbname -f $main_path/dbscripts/postgresql/onap-holmes_rulemgt-createobj.sql
40 psql -U $user -p $port -h $host -d $dbname --command 'select * from aplus_rule;'
43 echo "sql_result=$sql_result"
44 if [ $sql_result != 0 ] ; then
45 echo "Failed to initialize the database!"
48 echo "The database is initialized successfully!"