pytanght
11/27/2018 - 6:36 AM

Base code for select func in shell

Base code for select func in shell

ran_db_host="*";
ran_db_port=63751;
ran_db_user="*";
ran_db_pass="*";
ran_db_data="*";

  
cmd="use *;select rs.model from RMP_Server rs left join RMP_Ip rsIP on rs.id=rsIP.serverId WHERE ipAddress=\"$1\""  
cnt=$(mysql -uranreader -h$ran_db_host -P$ran_db_port -p$ran_db_pass -s -e "${cmd}" 2>/dev/null)
if `echo $cnt | grep -oP "KVM|OpenStack|FOXCONN|CNC_|6100|EC2C109|PACUARE|SC1425|SKYKOMISH|SLIMFAST09|SLIMLINE09|XENCOMPA09|XS23|dell$|Dell$|DELL$" > /dev/null`;then
	echo "False"

else
	echo "True"

fi