Bash脚本传递两个参数以获取ssl的状态

#!/bin/bash 
domainName=$1 
status=$2 
echo "Verifying domain"
case status in
$status) ping -c 1 $domainName || {
           echo "Cannot ping $domainName" >&2
           exit 1
         } ;;
*) echo "Invalid argument '$status'" >&2
   exit 1 ;;
esac

sql="SELECT * FROM DomainSSL WHERE domainName='$domainName'" 
mssql -f csv -c ~/applications/mssql/mssql.json -q "$sql" # mark here
rc=$?
if (( rc )) # nonzero
then echo "FAIL: rc $rc on [$sql]" >&2
else echo "SUCCESS: $sql" 
fi 

您可能还想尝试保存stdout和stderr以供以后解析。 重写自 # mark

mssql -f csv -c ~/applications/mssql/mssql.json -q "$sql" >ok 2>oops
rc=$?
if (( rc )) # nonzero
then echo -e "FAIL: rc $rc on [$sql]:\n$(<oops)" >&2
     case "$(grep SQLSTATE oops)" in
     *ER_DUP_KEY*) : code to handle duplicate keys error ;;
     # any other errors you choose to handle . . .
     *) : code for bailing on errors you don't care to handle ;;
     esac
else echo "SUCCESS: $sql" 
fi 

c、 f.mysql文档 here