Function InsertData

engine_db/sql.go:52–71

插入数据-存在true -不存在false

(db *sql.DB, data *consts.Keyinfo)

// 插入数据-存在true -不存在false
func InsertData(db *sql.DB, data *consts.Keyinfo) bool {
	var count int
	query := "SELECT COUNT(*) FROM key_info WHERE Host =? AND Req_Path =? AND RuleName =? AND Key_text=?"
	err = db.QueryRow(query, data.Host, data.Req_Path, data.RuleName, data.Key_text).Scan(&count)
	if err != nil && err != sql.ErrNoRows {
		if err != nil {
			logger.Error.Printf("查询失败:", err)
		}
	}
	if count > 0 {
		return false
	} else {
		stmt := "INSERT INTO key_info (RuleName, Host, Req_Path,Req_Body,Res_Body,Key_text,Content_Type) VALUES (?,?,?,?,?,?,?)"
		_, err = db.Exec(stmt, data.RuleName, data.Host, data.Req_Path, string(data.Req_Body), string(data.Res_Body), data.Key_text, data.Content_Type)
		if err != nil {
			logger.Error.Printf("插入失败:", err)
		}
		return true
	}
}