mysql shell制定ip_Shell脚本检查IP格式及mysql操作实例

还是cronjob的一部分，就是在Rails的定时任务里，后台交互运行

CheckIPAddress()

{

echo $1 |grep "^[0-9]\{1,3\}\.[0-9]\{1,3\}\.[0-9]\{1,3\}\.[0-9]\{1,3\}$" > /dev/null

if [ $? = 1 ]; then

return 1

else

a=`echo $1 | awk -F. ‘{print $1}‘`

b=`echo $1 | awk -F. ‘{print $2}‘`

c=`echo $1 | awk -F. ‘{print $3}‘`

d=`echo $1 | awk -F. ‘{print $4}‘`

#echo $a $b $c $d

for loop in $a $b $c $d

do

if [ $loop -ge 255 ] || [ $loop -lt 0 ]; then

return 2

fi

done

fi

}

ConfigureDefaultRegion() {

echo "Please input Region ip"

ret=1

while [ $ret != 0 ]

do

read region_ip

CheckIPAddress $region_ip

ret=$?

#echo $ret

if [ $ret = 1 ]; then

echo "Wrong IP address, please reinput Region IP:"

fi

done

/usr/bin/mysql -u root realworx_production -e "update regions set ip=‘$region_ip‘ where id=1" 1>/dev/null 2>/dev/null

if [ $? = 0 ]; then

/usr/bin/mysql -u root realworx_production -e "update config_params set val=1 where ident=55" 1>/dev/null 2>/dev/null

echo "set ‘$region_ip‘ as Default and Admin Region IP"

else

val=`/usr/bin/mysql -u root realworx_production -e "select id from regions where ip=‘$region_ip‘" | awk ‘{if ($1 != "id") print $1}‘`

/usr/bin/mysql -u root realworx_production -e "update config_params set val=‘$val‘ where ident=55" 1>/dev/null 2>/dev/null

region_name=`/usr/bin/mysql -u root realworx_production -e "select name from regions where ip=‘$region_ip‘" | awk ‘{if ($1 != "name") print $1}‘`

echo "IP already exists. So set ‘$region_name‘ as Admin Region. "

fi

echo "Region Setting Successfull."

}

原文：http://www.jb51.net/article/66740.htm