--- YodaProfiler/docs/install_DB.sh	2006/10/17 15:19:50	1.2
+++ YodaProfiler/docs/install_DB.sh	2007/09/06 07:39:13	1.6
@@ -3,7 +3,9 @@
 USERNAME=${PAM_DBUSER}
 HOST=""
 DBNAME=""
-COUNT=0;for word in `echo ${PAM_DBHOST} | 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
+FORCE="no"
+GPAMELA="no"
+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
 PASSWORD=${PAM_DBPSW}
 if [ $# -gt 0 ]; then
     for INPUT in $*; do 
@@ -19,6 +21,8 @@
 	    echo ""
 	    echo " --psw=password :  MySQL password"
 	    echo ""
+	    echo " --force :  do not wait [default: wait]"
+	    echo ""
 	    exit 0
 	fi
 	TEST=`echo $INPUT | sed 's/--user=//g'`
@@ -28,7 +32,7 @@
 	fi
 	TEST=`echo $INPUT | sed 's/--host=//g'`
 	if [ $TEST != $INPUT  ]; then
-	    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
 	    export DBNAME;
 	    export HOST;
 	fi
@@ -37,11 +41,19 @@
 	    PASSWORD=`echo $TEST`
 	    export PASSWORD;
 	fi
+	if [ "$INPUT" == "--force" ]; then
+	    FORCE="yes";
+	    export FORCE;
+	fi
+	if [ "$INPUT" == "--gpamela" ]; then
+	    GPAMELA="yes";
+	    export GPAMELA;
+	fi
     done
 else
     if [ "$USERNAME" == "" ] || [ "$HOST" == "" ] || [ "$DBNAME" == "" ]; then
 	echo ""
-	echo " Usage: ./install_GL_PARAM.sh [options] "
+	echo " Usage: ./install_DB.sh [options] "
 	echo ""
 	echo " Options: "
 	echo ""
@@ -57,16 +69,34 @@
 echo ""
 echo " Installing DB $DBNAME on $HOST with user $USERNAME and password $PASSWORD  "
 echo ""
-echo " WARNING: if already existing the DB will be RECREATED and you will LOSE all data! "
-echo ""
-echo "    =======>   You have 30 seconds to stop me using CTRL+c  <=======    "
-echo ""
-sleep 30;
+if [ "$FORCE" == "no" ]; then
+    echo " WARNING: if already existing the DB will be RECREATED and you will LOSE all data! "
+    echo ""
+    echo "    =======>   You have 30 seconds to stop me using CTRL+c  <=======    "
+    echo ""
+    sleep 30;
+fi;
 #
 rm -rf ${THISDIR}/temp.sql
 #
 cat ${THISDIR}/PAMELAProductionDB.sql | sed 's/dbname/'${DBNAME}'/g' >> ${THISDIR}/temp.sql
 mysql --user=$USERNAME --password=$PASSWORD --host=$HOST < ${THISDIR}/temp.sql 
 echo " done! "
+#
+#
+#
+if [ "$GPAMELA" == "yes" ]; then
+    echo ""
+    echo " Adapting GL_PARAM table to be used with simulated data "
+    echo ""
+#
+    rm -rf ${THISDIR}/temp.sql
+#
+    cat ${THISDIR}/GP_PARAM.sql | sed 's/dbname/'${DBNAME}'/g' >> ${THISDIR}/temp.sql
+    mysql --user=$USERNAME --password=$PASSWORD --host=$HOST < ${THISDIR}/temp.sql 
+#
+    echo " done! "
+fi;
+#
 echo ""
 rm -rf ${THISDIR}/temp.sql