Shell 搭配 MySQL 與 Slack

#!/bin/bash
STARTTIME=`date +%s`
ENDTIME=`date -d "-1 hour" +%s`
declare -i RESULT
RESULT=$(echo "SELECT count(id) FROM tracking where Timestamp < $STARTTIME and Timestamp >= $ENDTIME | mysql -h127.0.0.1 -uroot -pyourpasword -N)
if [ $RESULT -gt '50' ]
    then
    slack "異常發信 $RESULT"
else
fi

curl -X POST --data-urlencode 'payload={"channel": "#plan", "username": "bot", "text": "異常發信", "icon_emoji": ":ghost:"}' web_hook_url #notify", "username": "bot", "text": "Go ??", "icon_emoji": ":ghost:"}' web_hook_url

curl -s https://gist.githubusercontent.com/andkirby/67a774513215d7ba06384186dd441d9e/raw --output /usr/bin/slack
chmod +x /usr/bin/slack

vi ~/.slackrc

APP_SLACK_WEBHOOK
APP_SLACK_CHANNEL (可選)
APP_SLACK_USERNAME (可選)
APP_SLACK_ICON_EMOJI (可選)

*/10 * * * * /root/mail_check.sh > /dev/null 2>&1