123456789101112131415161718192021222324252627282930313233343536 |
- package day_new
- import (
- "github.com/beego/beego/v2/client/orm"
- "time"
- )
- // 企业微信群消息拉取日志表
- type WeworkMsgLog struct {
- Id uint64 `orm:"column(id);pk;auto" description:"自增ID"`
- Seq uint64 `orm:"column(seq)" description:"本次请求获取消息记录开始的seq值。首次访问填写0"`
- Limit int `orm:"column(limit)" description:"一次调用限制的limit值,不能超过1000"`
- Total int `orm:"column(total)" description:"实际拉取到的消息数"`
- ReqResult int8 `orm:"column(req_result)" description:"请求结果:1成功,2失败"`
- CreateTime time.Time `orm:"column(create_time)" description:"创建时间"`
- ModifyTime time.Time `orm:"column(modify_time)" description:"修改时间"`
- }
- func (w *WeworkMsgLog) TableName() string {
- return "wework_msg_log"
- }
- // AddMsgReqLog 新增调用记录
- func AddMsgReqLog(item *WeworkMsgLog) (err error) {
- o := orm.NewOrm()
- _, err = o.Insert(item)
- return
- }
- // GetLasReqLog 获取最近一次成功调用记录
- func GetLasReqLog() (item *WeworkMsgLog, err error) {
- o := orm.NewOrm()
- sql := `SELECT * FROM wework_msg_log WHERE req_result = 1 order by id desc`
- err = o.Raw(sql).QueryRow(&item)
- return
- }
|