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 pip install PyMySQL==0.9.3
   9 mkdir -p /service/vfc/nfvo/lcm/resources/bin/logs
  10 mkdir -p /var/log/onap/vfc/nslcm/
  11
  12 if [ ! -f /service/vfc/nfvo/lcm/resources/bin/logs/django.log ]; then
  13     touch /service/vfc/nfvo/lcm/resources/bin/logs/django.log
  14 else
  15     echo >/service/vfc/nfvo/lcm/resources/bin/logs/django.log
  16 fi
  17 if [ ! -f /var/log/onap/vfc/nslcm/runtime_nslcm.log ]; then
  18     touch /var/log/onap/vfc/nslcm/runtime_nslcm.log
  19 else
  20     echo >/var/log/onap/vfc/nslcm/runtime_nslcm.log
  21 fi
  22 ######
  23 MYSQL_IP=`echo $MYSQL_ADDR | cut -d: -f 1`
  24 MYSQL_PORT=`echo $MYSQL_ADDR | cut -d: -f 2`
  25 MYSQL_USER=`echo $MYSQL_AUTH | cut -d: -f 1`
  26 MYSQL_ROOT_PASSWORD=`echo $MYSQL_AUTH | cut -d: -f 2`
  27
  28 function create_database {
  29     #cd /service/vfc/nfvo/db/resources/nslcm/bin
  30     cd /service/vfc/nfvo/lcm/resources/bin
  31     bash initDB.sh $MYSQL_USER $MYSQL_ROOT_PASSWORD $MYSQL_PORT $MYSQL_IP
  32     man_path=/service/vfc/nfvo/lcm
  33     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='vfcnfvolcm';"`
  34     tab1=`echo $tab |awk '{print $2}'`
  35         echo "=========="
  36         echo $tab1
  37         echo "=========="
  38     if [ $tab1 -eq 0 ] ; then
  39         echo "============"
  40         echo $tab1
  41         echo "============"
  42         echo "TABLE NOT EXISTS, START MIGRATE"
  43         python $man_path/manage.py makemigrations && python $man_path/manage.py migrate &
  44         wait
  45         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='vfcnfvolcm';"`
  46         tab3=`echo $tab2|awk '{print $2}'`
  47         if [ $tab3 -gt 0  ] ; then
  48         echo "TABLE CREATE uUCCESSFUL"
  49     fi
  50 else
  51     echo "table already existed"
  52     exit 1
  53 fi
  54  }
  55
  56 if [ ! -f /service/vfc/nfvo/lcm/docker/db.txt ]; then
  57     echo 1 > /service/vfc/nfvo/lcm/docker/db.txt
  58     echo `pwd` >> db.txt
  59     create_database
  60 else
  61     echo "database already existed"
  62 fi