/
report.go
71 lines (56 loc) · 1.33 KB
/
report.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
package DataManager
import (
"errors"
"log"
"github.com/kycklingar/PBooru/DataManager/user"
)
func NewReport() Report {
return Report{Post: NewPost()}
}
type Report struct {
ID int
Post *Post
Reporter user.User
Reason int
Description string
}
func GetReports(q querier) ([]*Report, error) {
rows, err := q.Query("SELECT id, post_id, reporter, reason, description FROM reports ORDER BY id DESC LIMIT 25")
if err != nil {
log.Println(err)
return nil, err
}
defer rows.Close()
var reports []*Report
for rows.Next() {
var r = NewReport()
err = rows.Scan(&r.ID, &r.Post.ID, &r.Reporter, &r.Reason, &r.Description)
if err != nil {
log.Println(err)
return nil, err
}
reports = append(reports, &r)
}
return reports, nil
}
func (r Report) Delete(q querier) error {
if r.ID <= 0 {
return errors.New("report.ID <= 0")
}
_, err := q.Exec("DELETE FROM reports WHERE id = $1", r.ID)
return err
}
func (r Report) Submit() error {
if r.Post.ID <= 0 {
return errors.New("no Post.ID in report")
}
if r.Reporter.ID <= 0 {
return errors.New("no Reporter.ID in report")
}
_, err := DB.Exec("INSERT INTO reports(post_id, reporter, reason, description) VALUES($1, $2, $3, $4)", r.Post.ID, r.Reporter.ID, r.Reason, r.Description)
if err != nil {
log.Println(err)
return err
}
return nil
}