+ cd /service/vfc/gvnfm/vnflcm/lcm/resources/bin
+ bash initDB.sh $MYSQL_USER $MYSQL_ROOT_PASSWORD $MYSQL_PORT $MYSQL_IP
+ #DIRNAME=`dirname $0`
+ #HOME=`cd $DIRNAME/; pwd`
+ #man_path=$HOME/../
+ man_path=/service/vfc/gvnfm/vnflcm/lcm
+ #tab=`mysql -u${MYSQL_USER} -p${MYSQL_PASSWORD} -P${MYSQL_PORT} -h${MYSQL_IP} -e "use vfcnfvolcm; select count(*) from vfcnfvolcm;"`
+ tab=`mysql -u${MYSQL_USER} -p${MYSQL_ROOT_PASSWORD} -P${MYSQL_PORT} -h${MYSQL_IP} -e "SELECT count(TABLE_NAME) FROM information_schema.TABLES WHERE TABLE_SCHEMA='gvnfm';"`
+ tab1=`echo $tab |awk '{print $2}'`
+ echo "=========="
+ echo $tab1
+ echo "=========="
+ if [ $tab1 -eq 0 ] ; then
+ echo "============"
+ echo $tab1
+ echo "============"
+ echo "TABLE NOT EXISTS, START MIGRATE"
+ python $man_path/manage.py makemigrations database && python $man_path/manage.py migrate &
+ wait
+ tab2=`mysql -u${MYSQL_USER} -p${MYSQL_ROOT_PASSWORD} -P${MYSQL_PORT} -h${MYSQL_IP} -e "SELECT count(TABLE_NAME) FROM information_schema.TABLES WHERE TABLE_SCHEMA='gvnfm';"`
+ tab3=`echo $tab2|awk '{print $2}'`
+ if [ $tab3 -gt 0 ] ; then
+ echo "TABLE CREATE SUCCESSFUL"
+ fi
+else
+ echo "table already existed"
+ exit 1
+fi
+ }