eta_api/models/edb_monitor/edb_monitor_message.go

package edbmonitor

import (
	"time"

	"github.com/beego/beego/v2/client/orm"
)

type EdbMonitorMessage struct {
	EdbMonitorMessageId int       `orm:"column(edb_monitor_message_id);pk"`
	EdbInfoId           int       `description:"指标id"`
	EdbInfoType         int       `description:"指标类型: 0-普通指标；1-预测指标"`
	AdminId             int       `description:"用户id"`
	IsRead              int       `description:"是否已读: 0-未读；1-已读"`
	Message             string    `description:"消息内容"`
	MonitorTriggerTime  time.Time `description:"预警触发时间"`
	CreateTime          time.Time `description:"创建时间"`
}

func (m *EdbMonitorMessage) Insert() (insertId int64, err error) {
	o := orm.NewOrm()
	insertId, err = o.Insert(m)
	return
}

func GetEdbMonitorMessageByAdminId(adminId int) (items []*EdbMonitorMessage, err error) {
	o := orm.NewOrmUsingDB("data")
	sql := "SELECT * FROM edb_monitor_message WHERE admin_id =? AND is_read = 0 ORDER BY is_read ASC, create_time DESC"
	_, err = o.Raw(sql, adminId).QueryRows(&items)
	return
}