package main
import (
"bytes"
"encoding/json"
"fmt"
_ "github.com/go-sql-driver/MySQL"
"github.com/go-xorm/xorm"
"io/ioutil"
"net/http"
"time"
)
var engine *xorm.Engine
const webhook_url = "https://oapi.dingtalk.com/robot/send?access_token=xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx"
func dingtoinfo(s string) bool {
content, data := make(map[string]string), make(map[string]interface{})
content["content"] = s
data["msgtype"] = "text"
data["text"] = content
b, _ := json.Marshal(data)
resp, err := http.Post(webhook_url,
"application/json",
bytes.NewBuffer(b))
if err != nil {
fmt.Println(err)
}
defer resp.Body.Close()
body, _ := ioutil.ReadAll(resp.Body)
fmt.Println(string(body))
return true
}
func recoverName() {
if r := recover(); r != nil {
res := fmt.Sprintf("%s %s", "監(jiān)控程序 報錯:", r)
dingtoinfo(res)
}
}
func main() {
defer recoverName()
var err error
engine, err = xorm.NewEngine("mysql", "root:xxxxxxxxxxxxxxx@tcp(127.0.0.1:3306)/new?charset=utf8")
if err != nil {
panic(err.Error())
}
gsql := " select up_time from token where type = 0 ;"
gres, gerr := engine.Query(gsql)
if gerr != nil {
panic(gerr.Error())
}
var data string
for _, v := range gres {
data = string(v["up_time"])
}
loc, _ := time.LoadLocation("Asia/Shanghai")
nowTime := time.Now().In(loc)
tm, _ := time.Parse("2006-01-02 03:04:05", data)
ntm := tm.In(loc)
subM := nowTime.Sub(ntm)
fmt.Println("token更新時間 與 系統(tǒng)時間 相差",subM)
subtract := int(subM.Minutes())
if subtract > 20 {
dingtoinfo("異常, 請及時登錄查看 !!!")
}
}
分享題目:年輕人的第一個go程序:監(jiān)控數(shù)據(jù)庫字段報警
文章路徑:http://bm7419.com/article32/jdiesc.html
成都網(wǎng)站建設(shè)公司_創(chuàng)新互聯(lián),為您提供定制開發(fā)、標簽優(yōu)化、小程序開發(fā)、定制網(wǎng)站、營銷型網(wǎng)站建設(shè)、做網(wǎng)站
聲明:本網(wǎng)站發(fā)布的內(nèi)容(圖片、視頻和文字)以用戶投稿、用戶轉(zhuǎn)載內(nèi)容為主,如果涉及侵權(quán)請盡快告知,我們將會在第一時間刪除。文章觀點不代表本網(wǎng)站立場,如需處理請聯(lián)系客服。電話:028-86922220;郵箱:631063699@qq.com。內(nèi)容未經(jīng)允許不得轉(zhuǎn)載,或轉(zhuǎn)載時需注明來源: 創(chuàng)新互聯(lián)