diff options
Diffstat (limited to 'res/assembly/initDB.sh')
-rw-r--r-- | res/assembly/initDB.sh | 50 |
1 files changed, 50 insertions, 0 deletions
diff --git a/res/assembly/initDB.sh b/res/assembly/initDB.sh new file mode 100644 index 0000000..f756643 --- /dev/null +++ b/res/assembly/initDB.sh @@ -0,0 +1,50 @@ +#!/bin/bash +# +# Copyright 2017 ZTE Corporation. +# +# 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. +# + +DIRNAME=`dirname $0` +HOME=`cd $DIRNAME/; pwd` +user=$1 +password=$2 +port=$3 +host=$4 +echo "start create resource management db" +sql_path=$HOME/../ +mysql -u$user -p$password -P$port -h$host <$sql_path/dbscripts/mysql/openo-gvnfm-vnfres-createdb.sql +sql_result=$? +if [ $sql_result != 0 ] ; then + echo "failed to create resource management database" + exit 1 +fi +fileFlag=*createobj.sql +location=$sql_path/dbscripts/mysql +fileName="" +for i in `ls $location` +do + if [[ $i == ${fileFlag} ]];then + fileName=${i}; + echo "start create table:${fileName}" + mysql -u$user -p$password -P$port -h$host <$sql_path/dbscripts/mysql/$fileName + sql_result=$? + if [ $sql_result != 0 ] ; then + echo "failed to init resource management table:${fileName}" + exit 1 + fi + fi +done +echo "init resource management database success!" +exit 0 + |