diff options
| author |   Guangrong Fu <fu.guangrong@zte.com.cn> | 2017-09-05 16:46:26 +0800 |
|---|---|---|
| committer | Guangrong Fu <fu.guangrong@zte.com.cn> | 2017-09-05 17:20:51 +0800 |
| commit | 6481057c46c57f389e0fb17b7065941ed28299b8 (patch) | |
| tree | 0ce960a5283f9da0df74edb971f6ce4ac371a633 /rulemgt-standalone/src/main/assembly/bin/initDB.sh | |
| parent | 2def6b625452293a345ae73c4b91abaf9e728d72 (diff) | |
Change the DB from MySQL to PostgreSQL
Change-Id: If3e82cca0b27c5e486762b22305c1575d76789fe
Issue-ID: HOLMES-49
Signed-off-by: Guangrong Fu <fu.guangrong@zte.com.cn>
Diffstat (limited to 'rulemgt-standalone/src/main/assembly/bin/initDB.sh')
| -rw-r--r-- | rulemgt-standalone/src/main/assembly/bin/initDB.sh | 9 |
1 files changed, 6 insertions, 3 deletions
diff --git a/rulemgt-standalone/src/main/assembly/bin/initDB.sh b/rulemgt-standalone/src/main/assembly/bin/initDB.sh index 6ec9947..c9b5705 100644 --- a/rulemgt-standalone/src/main/assembly/bin/initDB.sh +++ b/rulemgt-standalone/src/main/assembly/bin/initDB.sh @@ -23,13 +23,16 @@ port=$3 host=$4 echo "start init holmes rulemgt db" main_path=$HOME/.. -cat $main_path/dbscripts/mysql/onap-holmes_rulemgt-createobj.sql +cat $main_path/dbscripts/postgresql/onap-holmes_rulemgt-createobj.sql echo "user="$user -echo "password"$password +echo "password="$password echo "port="$port echo "host="$host -mysql -u$user -p$password -P$port -h$host <$main_path/dbscripts/mysql/onap-holmes_rulemgt-createobj.sql +export PGPASSWORD=$password +psql -U $user -p $port -h $host -f $main_path/dbscripts/postgresql/onap-holmes_rulemgt-createobj.sql +psql -U $user -p $port -h $host -d holmes --command 'select * from aplus_rule;' sql_result=$? +unset PGPASSWORD cat "sql_result="$sql_result if [ $sql_result != 0 ] ; then echo "failed to init rulemgt database!" |