lcm/docker/instance_init.sh

   1 #!/bin/bash
   2 ######
   3 # by vfc-db test
   4 #####
   5 # echo "No service needs init."
   6 #MYSQL_USER=$1
   7 ######
   8 #by duan
   9 pip install PyMySQL==0.9.3
  10 if [ ! -f /service/vfc/gvnfm/vnflcm/lcm/resources/bin/logs/django.log ]; then
  11     mkdir -p /service/vfc/gvnfm/vnflcm/lcm/resources/bin/logs/
  12     touch /service/vfc/gvnfm/vnflcm/lcm/resources/bin/logs/django.log
  13 else
  14     echo >/service/vfc/gvnfm/vnflcm/lcm/resources/bin/logs/django.log
  15 fi
  16
  17 if [ ! -f /var/log/onap/vfc/gvnfm-vnflcm/runtime_lcm.log ]; then
  18     mkdir -p /var/log/onap/vfc/gvnfm-vnflcm/
  19     touch /var/log/onap/vfc/gvnfm-vnflcm/runtime_lcm.log
  20 else
  21     echo >/var/log/onap/vfc/gvnfm-vnflcm/runtime_lcm.log
  22 fi
  23
  24 MYSQL_IP=`echo $MYSQL_ADDR | cut -d: -f 1`
  25 MYSQL_PORT=`echo $MYSQL_ADDR | cut -d: -f 2`
  26 MYSQL_USER=`echo $MYSQL_AUTH | cut -d: -f 1`
  27 MYSQL_ROOT_PASSWORD=`echo $MYSQL_AUTH | cut -d: -f 2`
  28
  29 function create_database {
  30     cd /service/vfc/gvnfm/vnflcm/lcm/resources/bin
  31     bash initDB.sh $MYSQL_USER $MYSQL_ROOT_PASSWORD $MYSQL_PORT $MYSQL_IP
  32     #DIRNAME=`dirname $0`
  33     #HOME=`cd $DIRNAME/; pwd`
  34     #man_path=$HOME/../
  35     man_path=/service/vfc/gvnfm/vnflcm/lcm
  36     #tab=`mysql -u${MYSQL_USER} -p${MYSQL_PASSWORD} -P${MYSQL_PORT} -h${MYSQL_IP} -e "use vfcnfvolcm; select count(*) from vfcnfvolcm;"`
  37     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';"`
  38     tab1=`echo $tab |awk '{print $2}'`
  39         echo "=========="
  40         echo $tab1
  41         echo "=========="
  42     if [ $tab1 -eq 0 ] ; then
  43         echo "============"
  44         echo $tab1
  45         echo "============"
  46         echo "TABLE NOT EXISTS, START MIGRATE"
  47         python $man_path/manage.py makemigrations database && python $man_path/manage.py migrate &
  48         wait
  49         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';"`
  50         tab3=`echo $tab2|awk '{print $2}'`
  51         if [ $tab3 -gt 0  ] ; then
  52         echo "TABLE CREATE SUCCESSFUL"
  53     fi
  54 else
  55     echo "table already existed"
  56     exit 1
  57 fi
  58  }
  59
  60 if [ ! -f /service/vfc/gvnfm/vnflcm/lcm/docker/db.txt ]; then
  61     echo 1 > /service/vfc/gvnfm/vnflcm/lcm/docker/db.txt
  62     echo `pwd` >> /service/vfc/gvnfm/vnflcm/lcm/docker/db.txt
  63     create_database
  64 else
  65     echo "database already existed"
  66 fi