forked from fwtpe/owl-backend
-
Notifications
You must be signed in to change notification settings - Fork 0
/
query_object.go
86 lines (69 loc) · 2.04 KB
/
query_object.go
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
package owl
import (
"net/http"
"time"
"github.com/gin-gonic/gin"
"github.com/satori/go.uuid"
"github.com/fwtpe/owl-backend/common/db"
ogin "github.com/fwtpe/owl-backend/common/gin"
"github.com/fwtpe/owl-backend/common/gin/mvc"
"github.com/fwtpe/owl-backend/common/json"
"github.com/fwtpe/owl-backend/common/model/owl"
owlDb "github.com/fwtpe/owl-backend/modules/mysqlapi/rdb/owl"
owlSrv "github.com/fwtpe/owl-backend/modules/mysqlapi/service/owl"
)
func SaveQueryObject(jsonQuery *QueryObject) mvc.OutputBody {
queryModel := jsonQuery.toQueryModel()
owlSrv.QueryObjectService.CreateOrLoadQuery(queryModel)
return mvc.JsonOutputBody(queryModel.ToJson())
}
func GetQueryObjectByUuid(
d *struct {
Uuid uuid.UUID `mvc:"param[uuid]"`
Uri string `mvc:"req[RequestURI]"`
},
) mvc.OutputBody {
queryObject := owlSrv.QueryObjectService.LoadQueryByUuid(d.Uuid)
if queryObject == nil {
uuidString := d.Uuid.String()
return mvc.JsonOutputBody2(
http.StatusNotFound,
map[string]interface{}{
"uuid": uuidString,
"http_status": http.StatusNotFound,
"error_code": 1,
"uri": d.Uri,
},
)
}
return mvc.JsonOutputBody(queryObject.ToJson())
}
func VacuumOldQueryObjects(
d *struct {
ForDays int `mvc:"query[for_days] default[180]" validate:"min=14"`
},
) mvc.OutputBody {
beforeTime := time.Now().Add(time.Duration(-d.ForDays) * time.Duration(24) * time.Hour)
affectedRows := owlDb.RemoveOldQueryObject(beforeTime)
return mvc.JsonOutputBody(
map[string]interface{}{
"before_time": beforeTime.Unix(),
"affected_rows": affectedRows,
},
)
}
type QueryObject struct {
NamedId string `json:"feature_name" validate:"min=1"`
Content json.VarBytes `json:"content" validate:"min=1"`
Md5Content json.Bytes16 `json:"md5_content" validate:"non_zero_slice"`
}
func (qb *QueryObject) Bind(c *gin.Context) {
ogin.BindJson(c, qb)
}
func (qb *QueryObject) toQueryModel() *owl.Query {
return &owl.Query{
NamedId: qb.NamedId,
Content: []byte(qb.Content),
Md5Content: db.Bytes16(qb.Md5Content),
}
}