DarthVader/docs/install_GL_PARAM.sh

#!/bin/bash --norc 
THISDIR=`pwd`
USERNAME=${PAM_DBUSER}
HOST=""
DBNAME=""
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
    I=1
    while [ $I -le $# ]; do
        if [ $I -eq 1 ]; then 
            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
        if [ $INPUT == "--help" ] || [ $INPUT == "-h" ]; then
            echo ""
            echo " Usage: ./install_GL_PARAM.sh [options] "
            echo ""
            echo " Options: "
            echo ""
            echo " --user=username : MySQL username. "
            echo ""
            echo " --host=mysql://localhost/pamelaprod : MySQL host and DB name."
            echo ""
            echo " --psw=password :  MySQL password"
            echo ""
            exit 0
        fi
        TEST=`echo $INPUT | sed 's/--user=//g'`
        if [ $TEST != $INPUT  ]; then
            USERNAME=`echo $TEST`
            export USERNAME;
        fi
        TEST=`echo $INPUT | sed 's/--host=//g'`
        if [ $TEST != $INPUT  ]; then
            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
        TEST=`echo $INPUT | sed 's/--psw=//g'`
        if [ $TEST != $INPUT  ]; then
            PASSWORD=`echo $TEST`
            export PASSWORD;
        fi
        let I=$I+1
    done
else
    if [ "$USERNAME" == "" ] || [ "$HOST" == "" ] || [ "$DBNAME" == "" ]; then
        echo ""
        echo " Usage: ./install_GL_PARAM.sh [options] "
        echo ""
        echo " Options: "
        echo ""
        echo " --user=username : MySQL username. "
        echo ""
        echo " --host=mysql://localhost/pamelaprod : MySQL host and DB name."
        echo ""
        echo " --psw=password :  MySQL password"
        echo ""    
        exit 0
    fi
fi;
echo ""
echo " Updating GL_PARAM table on DB $DBNAME, $HOST with user $USERNAME and password $PASSWORD "
echo "               (you have 30 seconds to stop me using CTRL+c)       "
echo ""
sleep 30;
echo " Updating GL_PARAM table"
#
rm -rf ${THISDIR}/temp.sql
PAM_CALIB2=$(echo $PAM_CALIB | sed 's/\//\\\//g')
#
echo "delete from GL_PARAM;" > ${THISDIR}/temp.sql
mysql --user=$USERNAME --password=$PASSWORD --host=$HOST $DBNAME < ${THISDIR}/temp.sql 
#
cat ${THISDIR}/install_GL_PARAM.sql | sed 's/fullpathgoesere/'${PAM_CALIB2}'/g' >> ${THISDIR}/temp.sql
mysql --user=$USERNAME --password=$PASSWORD --host=$HOST $DBNAME < ${THISDIR}/temp.sql 
#
echo " done! "
echo ""
echo "GL_PARAM TABLE NOW CONTAINS:"
echo ""
echo "select * from GL_PARAM;" > ${THISDIR}/temp.sql
mysql --user=$USERNAME --password=$PASSWORD --host=$HOST $DBNAME < ${THISDIR}/temp.sql 
echo ""
echo "Please check that path and names are correct."
echo ""
#
rm -rf ${THISDIR}/temp.sql
1	mocchiut	1.1	#!/bin/bash --norc
2			THISDIR=`pwd`
3	mocchiut	1.2	USERNAME=${PAM_DBUSER}
4	mocchiut	1.1	HOST=""
5			DBNAME=""
6	mocchiut	1.3	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
7	mocchiut	1.2	PASSWORD=${PAM_DBPSW}
8			if [ $# -gt 0 ]; then
9	mocchiut	1.1	I=1
10			while [ $I -le $# ]; do
11			if [ $I -eq 1 ]; then
12			INPUT=$1
13			fi
14			if [ $I -eq 2 ]; then
15			INPUT=$2
16			fi
17			if [ $I -eq 3 ]; then
18			INPUT=$3
19			fi
20			if [ $I -eq 4 ]; then
21			INPUT=$4
22			fi
23			if [ $INPUT == "--help" ] \|\| [ $INPUT == "-h" ]; then
24			echo ""
25			echo " Usage: ./install_GL_PARAM.sh [options] "
26			echo ""
27			echo " Options: "
28			echo ""
29			echo " --user=username : MySQL username. "
30			echo ""
31			echo " --host=mysql://localhost/pamelaprod : MySQL host and DB name."
32			echo ""
33			echo " --psw=password : MySQL password"
34			echo ""
35			exit 0
36			fi
37			TEST=`echo $INPUT \| sed 's/--user=//g'`
38			if [ $TEST != $INPUT ]; then
39			USERNAME=`echo $TEST`
40			export USERNAME;
41			fi
42			TEST=`echo $INPUT \| sed 's/--host=//g'`
43			if [ $TEST != $INPUT ]; then
44	mocchiut	1.3	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
45	mocchiut	1.1	export DBNAME;
46			export HOST;
47			fi
48			TEST=`echo $INPUT \| sed 's/--psw=//g'`
49			if [ $TEST != $INPUT ]; then
50			PASSWORD=`echo $TEST`
51			export PASSWORD;
52			fi
53			let I=$I+1
54			done
55			else
56	mocchiut	1.2	if [ "$USERNAME" == "" ] \|\| [ "$HOST" == "" ] \|\| [ "$DBNAME" == "" ]; then
57			echo ""
58			echo " Usage: ./install_GL_PARAM.sh [options] "
59			echo ""
60			echo " Options: "
61			echo ""
62			echo " --user=username : MySQL username. "
63			echo ""
64			echo " --host=mysql://localhost/pamelaprod : MySQL host and DB name."
65			echo ""
66			echo " --psw=password : MySQL password"
67			echo ""
68			exit 0
69			fi
70	mocchiut	1.1	fi;
71	mocchiut	1.2	echo ""
72			echo " Updating GL_PARAM table on DB $DBNAME, $HOST with user $USERNAME and password $PASSWORD "
73			echo " (you have 30 seconds to stop me using CTRL+c) "
74			echo ""
75			sleep 30;
76			echo " Updating GL_PARAM table"
77	mocchiut	1.1	#
78			rm -rf ${THISDIR}/temp.sql
79			PAM_CALIB2=$(echo $PAM_CALIB \| sed 's/\//\\\//g')
80			#
81			echo "delete from GL_PARAM;" > ${THISDIR}/temp.sql
82			mysql --user=$USERNAME --password=$PASSWORD --host=$HOST $DBNAME < ${THISDIR}/temp.sql
83			#
84			cat ${THISDIR}/install_GL_PARAM.sql \| sed 's/fullpathgoesere/'${PAM_CALIB2}'/g' >> ${THISDIR}/temp.sql
85			mysql --user=$USERNAME --password=$PASSWORD --host=$HOST $DBNAME < ${THISDIR}/temp.sql
86			#
87	mocchiut	1.2	echo " done! "
88	mocchiut	1.1	echo ""
89			echo "GL_PARAM TABLE NOW CONTAINS:"
90			echo ""
91			echo "select * from GL_PARAM;" > ${THISDIR}/temp.sql
92			mysql --user=$USERNAME --password=$PASSWORD --host=$HOST $DBNAME < ${THISDIR}/temp.sql
93			echo ""
94			echo "Please check that path and names are correct."
95			echo ""
96			#
97			rm -rf ${THISDIR}/temp.sql