monitor db
package main
import (
"database/sql"
"fmt"
"io/ioutil"
"net/http"
"strconv"
"strings"
"time"
)
func Get_data() {
db, err := sql.Open("mysql", "") //connect db
if err != nil {
fmt.Println("connect error", err)
}
defer db.Close()
var me = ""
var tm = time.Now().Unix()
var sum =0
for i := 0; i <= 31; i++ {
x := i
sqlex := fmt.Sprintf("sql 语句")
fmt.Println(sqlex)
stmt, err := db.Query(sqlex)
if err != nil {
fmt.Println("Query get sql error")
}
for stmt.Next() {
var xxx int
err := stmt.Scan(&xxx);
if err != nil {
fmt.Println("no msg", err)
}
if xxx > 0 {
sum++;
}
if(xxx>0&&sum<10){
me = me+":"+strconv.Itoa(xxx);
}
}
}
if me != "" {
t := time.Unix(tm, 0)
time := t.Format("2006年1月2日 15:04:05")
message := fmt.Sprintf("通知语句")
Sendmassagefun(message)
}
}
func Sendmassagefun(){
sendemail()
}
func main() {
for {
Get_data()
time.Sleep(86400 * time.Second) //间隔执行
}
}