/
list_repo.go
65 lines (53 loc) · 1.54 KB
/
list_repo.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
// SPDX-License-Identifier: Apache-2.0
package hook
import (
"context"
"github.com/go-vela/types/constants"
"github.com/go-vela/types/database"
"github.com/go-vela/types/library"
"github.com/sirupsen/logrus"
)
// ListHooksForRepo gets a list of hooks by repo ID from the database.
func (e *engine) ListHooksForRepo(ctx context.Context, r *library.Repo, page, perPage int) ([]*library.Hook, int64, error) {
e.logger.WithFields(logrus.Fields{
"org": r.GetOrg(),
"repo": r.GetName(),
}).Tracef("listing hooks for repo %s from the database", r.GetFullName())
// variables to store query results and return value
count := int64(0)
h := new([]database.Hook)
hooks := []*library.Hook{}
// count the results
count, err := e.CountHooksForRepo(ctx, r)
if err != nil {
return nil, 0, err
}
// short-circuit if there are no results
if count == 0 {
return hooks, 0, nil
}
// calculate offset for pagination through results
offset := perPage * (page - 1)
// send query to the database and store result in variable
err = e.client.
Table(constants.TableHook).
Where("repo_id = ?", r.GetID()).
Order("id DESC").
Limit(perPage).
Offset(offset).
Find(&h).
Error
if err != nil {
return nil, count, err
}
// iterate through all query results
for _, hook := range *h {
// https://golang.org/doc/faq#closures_and_goroutines
tmp := hook
// convert query result to library type
//
// https://pkg.go.dev/github.com/go-vela/types/database#Hook.ToLibrary
hooks = append(hooks, tmp.ToLibrary())
}
return hooks, count, nil
}