/
input.go
92 lines (74 loc) · 2.07 KB
/
input.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
87
88
89
90
91
92
package models
import (
"x-patrol/vars"
"time"
)
type InputInfo struct {
Id int64
Type string `xorm:"varchar(255) notnull"`
Content string `xorm:"text notnull"`
Desc string `xorm:"text notnull"`
Version int `xorm:"version"`
CreatedTime time.Time `xorm:"created"`
UpdatedTime time.Time `xorm:"updated"`
}
func NewInputInfo(inputType, content, desc string) (info *InputInfo) {
return &InputInfo{Type: inputType, Content: content, Desc: desc}
}
func (i *InputInfo) Insert() (int64, error) {
return Engine.Insert(i)
}
func (i *InputInfo) Exist(repoUrl string) (bool, error) {
info := new(InputInfo)
return Engine.Table("input_info").Where("content=?", repoUrl).Get(info)
}
func GetInputInfoById(id int64) (*InputInfo, bool, error) {
input := InputInfo{Id: id}
has, err := Engine.Table("input_info").ID(id).Get(&input)
return &input, has, err
}
func EditInputInfoById(id int64, inputType, content, desc string) error {
input := new(InputInfo)
var err error
has, err := Engine.ID(id).Get(input)
if err == nil && has {
input.Type = inputType
input.Content = content
input.Desc = desc
_, err = Engine.ID(id).Update(input)
}
return err
}
func DeleteInputInfoById(id int64) error {
input := new(InputInfo)
_, err := Engine.Table("input_info").ID(id).Delete(input)
return err
}
func DeleteAllInputInfo() error {
sqlCMD := "delete from input_info;"
_, err := Engine.Exec(sqlCMD)
return err
}
func ListInputInfo() ([]InputInfo, error) {
inputs := make([]InputInfo, 0)
err := Engine.Table("input_info").Find(&inputs)
return inputs, err
}
func ListInputInfoPage(page int) ([]InputInfo, int, error) {
inputs := make([]InputInfo, 0)
totalPages, err := Engine.Table("input_info").Count()
var pages int
if int(totalPages)%vars.PAGE_SIZE == 0 {
pages = int(totalPages) / vars.PAGE_SIZE
} else {
pages = int(totalPages)/vars.PAGE_SIZE + 1
}
if page >= pages {
page = pages
}
if page < 1 {
page = 1
}
err = Engine.Table("input_info").Limit(vars.PAGE_SIZE, (page-1)*vars.PAGE_SIZE).Find(&inputs)
return inputs, pages, err
}