FloorViz/parseFloor.sh at master · shred444/FloorViz · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
#Define variables
TARFILE="" #"efcrssi.tar.gz"
EXTRACTDIR="/tmp/rssi_extracted"
GREPFILE="myRSSI.log"
ROAMFILE="myRoams.log"
PYTHONSCRIPT="/tmp/extract_rssi_logs.py"
SITE="" #"amz_bfi1"
DATASET="DATASET3"
SQLFILE="/home/jcohn/sqlInit.sql"


function printUsage
{
    echo " Usage: $0 [-t <location of tar>] [-s <site name>] [driveID] ..."
    echo "      First argument specifies the info to retrieve"
    echo "      Any arguments relevant to the info follow"
    echo "      1 or more driveID may be specified (using the drive number digits)"
    echo "      If no driveID are specified, all active drives are polled"
    echo "      This script fetches from info from all drives in parallel, but limits"
    echo "      the number of parallel sub processes to argument of -maxFork (default $maxFork)"
    echo ""
    echo " Arguments for each info:"
    echo ""
    echo " VERSION: [GOOD|BAD|ALL] "
    echo "      GOOD - Only shows the drives that have the current release "

}

if [ $# -lt 1 ]; then
	printUsage;
	exit
fi


# Options:
while (( "$#" )); do

    if [ "$1" == 'BAD' -o "$1" == 'bad' -o "$1" == 'b' -o "$1" == 'B' ]; then
        SHOW_GOOD=0;
    elif [ "$1" == 'GOOD' -o "$1" == 'good' -o "$1" == 'g' -o "$1" == 'G' ]; then
        SHOW_BAD=0;
    elif [ "$1" == '-help' -o "$1" == 'h' -o "$1" == 'help' -o "$1" == 'h' ]; then
        printUsage
        exit
    elif [ $1 == '-s' ]; then
	#get site location for db
	shift
	SITE=$1;
	#echo " site=$SITE";
    elif [ `echo $1 | grep "^[0-9]*$"` ]; then
        DRIVES="$DRIVES $1"
    elif [ "$1" == "-maxFork" -a $# -gt 1 ]; then
        shift
        maxFork=$1
    elif [ $1 == '-t' ]; then
	#get tar ball location
        shift
        TARFILE=$1
	if ! [ -f "$TARFILE" ]; then
		echo "ERROR: tar file = $TARFILE  <DOES NOT EXIST>"
		exit
	fi
    fi
    shift
done


#check all arguements before continuing
if [ "$SITE" == "" -o "$TARFILE" == "" ]; then
	echo "ERROR: Missing arguement"
	printUsage;
	exit
fi

#Display all variables
echo "--- Variables ---"
echo "	SITE = $SITE"
echo "	TARFILE = $TARFILE"


#Perform unarchiving
cd /tmp

#setup mysql
MYSQL=`echo mysql -h hwtest -u jonathan -padmin`

#remove extract folder
echo "Removing old data"
rm $EXTRACTDIR -f -r

#create extracted folder
mkdir $EXTRACTDIR
echo "$EXTRACTDIR Created"

#copy tar to extracted folder
cp $TARFILE $EXTRACTDIR

#move into folder
cd $EXTRACTDIR

#untar file
tar -xzvf $TARFILE
echo "Untar Complete"

#unarchive all drives
python $PYTHONSCRIPT -s $EXTRACTDIR -l $EXTRACTDIR
echo "Drive Unarchive Complete"

#grep 'OK'
grep -r --include "rssi.log.*" --exclude "my*" "OK" . > $GREPFILE
echo "OKs Grep Complete"

#grep 'Roam'
grep -r --include "rssi.log.*" --exclude "my*" "Roam" . > $ROAMFILE
echo "Roams Grep Complete"


#Select database and run sql script
echo "use $SITE; source $SQLFILE;" | $MYSQL

echo "script complete";