/[PAMELA software]/DarthVader/docs/install_GL_PARAM.sh
ViewVC logotype

Diff of /DarthVader/docs/install_GL_PARAM.sh

Parent Directory Parent Directory | Revision Log Revision Log | View Patch Patch

revision 1.1 by mocchiut, Wed Sep 6 15:20:21 2006 UTC revision 1.4 by mocchiut, Thu Nov 9 17:05:51 2006 UTC
# Line 1  Line 1 
1  #!/bin/bash --norc  #!/bin/bash --norc
2  THISDIR=`pwd`  THISDIR=`pwd`
3  USERNAME=""  USERNAME=${PAM_DBUSER}
4  HOST=""  HOST=""
5  DBNAME=""  DBNAME=""
6  PASSWORD=""  FORCE="no"
7  if [ $# -gt 0 ] && [ $# -le 4 ]; then  COUNT=0;for word in `echo ${PAM_DBHOST} | tr [\/] [" "] |tr [?] [" "] |sed 's/mysql://g' `; do if [ $COUNT -eq 0 ]; then HOST=`echo $word`; fi; if [ $COUNT -eq 1 ]; then DBNAME=`echo $word`; fi; let COUNT=$COUNT+1; done
8      I=1  PASSWORD=${PAM_DBPSW}
9      while [ $I -le $# ]; do  if [ $# -gt 0 ]; then
10          if [ $I -eq 1 ]; then      for INPUT in $*; do
             INPUT=$1  
         fi  
         if [ $I -eq 2 ]; then  
             INPUT=$2  
         fi  
         if [ $I -eq 3 ]; then  
             INPUT=$3  
         fi  
         if [ $I -eq 4 ]; then  
             INPUT=$4  
         fi  
11          if [ $INPUT == "--help" ] || [ $INPUT == "-h" ]; then          if [ $INPUT == "--help" ] || [ $INPUT == "-h" ]; then
12              echo ""              echo ""
13              echo " Usage: ./install_GL_PARAM.sh [options] "              echo " Usage: ./install_GL_PARAM.sh [options] "
# Line 31  if [ $# -gt 0 ] && [ $# -le 4 ]; then Line 20  if [ $# -gt 0 ] && [ $# -le 4 ]; then
20              echo ""              echo ""
21              echo " --psw=password :  MySQL password"              echo " --psw=password :  MySQL password"
22              echo ""              echo ""
23                echo " --force :  do not wait [default: wait]"
24                echo ""
25              exit 0              exit 0
26          fi          fi
27          TEST=`echo $INPUT | sed 's/--user=//g'`          TEST=`echo $INPUT | sed 's/--user=//g'`
# Line 40  if [ $# -gt 0 ] && [ $# -le 4 ]; then Line 31  if [ $# -gt 0 ] && [ $# -le 4 ]; then
31          fi          fi
32          TEST=`echo $INPUT | sed 's/--host=//g'`          TEST=`echo $INPUT | sed 's/--host=//g'`
33          if [ $TEST != $INPUT  ]; then          if [ $TEST != $INPUT  ]; then
34              COUNT=0;for word in `echo $TEST | tr [\/] [" "] |sed 's/mysql://g' `; do if [ $COUNT -eq 0 ]; then HOST=`echo $word`; fi; if [ $COUNT -eq 1 ]; then DBNAME=`echo $word`; fi; let COUNT=$COUNT+1; done              COUNT=0;for word in `echo $TEST | tr [\/] [" "] |tr [?] [" "]|sed 's/mysql://g' `; do if [ $COUNT -eq 0 ]; then HOST=`echo $word`; fi; if [ $COUNT -eq 1 ]; then DBNAME=`echo $word`; fi; let COUNT=$COUNT+1; done
35              export DBNAME;              export DBNAME;
36              export HOST;              export HOST;
37          fi          fi
# Line 49  if [ $# -gt 0 ] && [ $# -le 4 ]; then Line 40  if [ $# -gt 0 ] && [ $# -le 4 ]; then
40              PASSWORD=`echo $TEST`              PASSWORD=`echo $TEST`
41              export PASSWORD;              export PASSWORD;
42          fi          fi
43          let I=$I+1          if [ "$INPUT" == "--force" ]; then
44                FORCE="yes";
45                export FORCE;
46            fi
47      done      done
48  else  else
49        if [ "$USERNAME" == "" ] || [ "$HOST" == "" ] || [ "$DBNAME" == "" ]; then
50            echo ""
51            echo " Usage: ./install_GL_PARAM.sh [options] "
52            echo ""
53            echo " Options: "
54            echo ""
55            echo " --user=username : MySQL username. "
56            echo ""
57            echo " --host=mysql://localhost/pamelaprod : MySQL host and DB name."
58            echo ""
59            echo " --psw=password :  MySQL password"
60            echo ""    
61            exit 0
62        fi
63    fi;
64    echo ""
65    echo " Updating GL_PARAM table on DB $DBNAME, $HOST with user $USERNAME and password $PASSWORD "
66    echo ""
67    if [ "$FORCE" == "no" ]; then
68        echo " WARNING: if already existing the GL_PARAM table will be RECREATED and you will LOSE all data in that table! "
69      echo ""      echo ""
70      echo " Usage: ./install_GL_PARAM.sh [options] "      echo "    =======>   You have 30 seconds to stop me using CTRL+c  <=======    "
     echo ""  
     echo " Options: "  
     echo ""  
     echo " --user=username : MySQL username. "  
     echo ""  
     echo " --host=mysql://localhost/pamelaprod : MySQL host and DB name."  
71      echo ""      echo ""
72      echo " --psw=password :  MySQL password"      sleep 30;
     echo ""      
     exit 0  
73  fi;  fi;
74    echo " Updating GL_PARAM table"
75  #  #
76  rm -rf ${THISDIR}/temp.sql  rm -rf ${THISDIR}/temp.sql
77  PAM_CALIB2=$(echo $PAM_CALIB | sed 's/\//\\\//g')  PAM_CALIB2=$(echo $PAM_CALIB | sed 's/\//\\\//g')
# Line 75  mysql --user=$USERNAME --password=$PASSW Line 82  mysql --user=$USERNAME --password=$PASSW
82  cat ${THISDIR}/install_GL_PARAM.sql | sed 's/fullpathgoesere/'${PAM_CALIB2}'/g' >> ${THISDIR}/temp.sql  cat ${THISDIR}/install_GL_PARAM.sql | sed 's/fullpathgoesere/'${PAM_CALIB2}'/g' >> ${THISDIR}/temp.sql
83  mysql --user=$USERNAME --password=$PASSWORD --host=$HOST $DBNAME < ${THISDIR}/temp.sql  mysql --user=$USERNAME --password=$PASSWORD --host=$HOST $DBNAME < ${THISDIR}/temp.sql
84  #  #
85    echo " done! "
86  echo ""  echo ""
87  echo "GL_PARAM TABLE NOW CONTAINS:"  echo "GL_PARAM TABLE NOW CONTAINS:"
88  echo ""  echo ""
89  echo "select * from GL_PARAM;" > ${THISDIR}/temp.sql  echo "SET time_zone='+0:00';" > ${THISDIR}/temp.sql
90    echo "select * from GL_PARAM;" >> ${THISDIR}/temp.sql
91  mysql --user=$USERNAME --password=$PASSWORD --host=$HOST $DBNAME < ${THISDIR}/temp.sql  mysql --user=$USERNAME --password=$PASSWORD --host=$HOST $DBNAME < ${THISDIR}/temp.sql
92  echo ""  echo ""
93  echo "Please check that path and names are correct."  echo "Please check that path and names are correct."
Legend:
Removed from v.1.1  
changed lines
  Added in v.1.4
  ViewVC Help
Powered by ViewVC 1.1.23