-
Notifications
You must be signed in to change notification settings - Fork 581
/
convert_and_update_mysql.sh
42 lines (33 loc) · 1.77 KB
/
convert_and_update_mysql.sh
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
#!/bin/bash
n=1
until [ $n -gt 11196 ]
do
EXIRECORDS=$(mysql -u root -pPASSWORD -h 192.168.2.100 -e "SELECT sn,tarsize from DATABASE.Table1 where sn='"$n"'" |tail -n1 |grep $n)
RECORDNUMBER=$(echo $EXIRECORDS |awk '{print $1}')
FOLDERSIZE=$(echo $EXIRECORDS |awk '{print $2}')
KB=$(echo $EXIRECORDS |awk '{print $2}' |grep K |wc -l)
if [ $KB -ge 1 ]; then
K=$(echo $EXIRECORDS |awk '{print $2}' |sed 's/K//g')
BYTES=$($K * 1024 |bc |awk -F. '{print $1}')
mysql -u root -pPASSWORD -h 192.168.2.100 -e "UPDATE DATABASE.Table1 SET tarsize='"$BYTES"' where sn='"$RECORDNUMBER"'"
fi
MB=$(echo $EXIRECORDS |awk '{print $2}' |grep M |wc -l)
if [ $MB -ge 1 ]; then
M=$(echo $EXIRECORDS |awk '{print $2}' |sed 's/M//g')
BYTES=$(echo $M*1024*1024 |bc |awk -F. '{print $1}')
mysql -u root -pPASSWORD -h 192.168.2.100 -e "UPDATE DATABASE.Table1 SET tarsize='"$BYTES"' where sn='"$RECORDNUMBER"'"
fi
GB=$(echo $EXIRECORDS |awk '{print $2}' |grep G |wc -l)
if [ $GB -ge 1 ]; then
G=$(echo $EXIRECORDS |awk '{print $2}' |sed 's/G//g')
BYTES=$(echo $G*1024*1024*1024 |bc |awk -F. '{print $1}')
mysql -u root -pPASSWORD -h 192.168.2.100 -e "UPDATE DATABASE.Table1 SET tarsize='"$BYTES"' where sn='"$RECORDNUMBER"'"
fi
TB=$(echo $EXIRECORDS |awk '{print $2}' |grep T |wc -l)
if [ $TB -ge 1 ]; then
T=$(echo $EXIRECORDS |awk '{print $2}' |sed 's/T//g')
BYTES=$(echo $T*1024*1024*1024*1024 |bc |awk -F. '{print $1}')
mysql -u root -pPASSWORD -h 192.168.2.100 -e "UPDATE DATABASE.Table1 SET tarsize='"$BYTES"' where sn='"$RECORDNUMBER"'"
fi
n=`expr "$n" + 1`
done