/
list_lite.go
61 lines (49 loc) · 1.36 KB
/
list_lite.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
// SPDX-License-Identifier: Apache-2.0
package user
import (
"context"
"github.com/go-vela/types/constants"
"github.com/go-vela/types/database"
"github.com/go-vela/types/library"
)
// ListLiteUsers gets a lite (only: id, name) list of users from the database.
//
//nolint:lll // ignore long line length due to variable names
func (e *engine) ListLiteUsers(ctx context.Context, page, perPage int) ([]*library.User, int64, error) {
e.logger.Trace("listing lite users from the database")
// variables to store query results and return values
count := int64(0)
u := new([]database.User)
users := []*library.User{}
// count the results
count, err := e.CountUsers(ctx)
if err != nil {
return users, 0, err
}
// short-circuit if there are no results
if count == 0 {
return users, 0, nil
}
// calculate offset for pagination through results
offset := perPage * (page - 1)
err = e.client.
Table(constants.TableUser).
Select("id", "name").
Limit(perPage).
Offset(offset).
Find(&u).
Error
if err != nil {
return nil, count, err
}
// iterate through all query results
for _, user := range *u {
// https://golang.org/doc/faq#closures_and_goroutines
tmp := user
// convert query result to library type
//
// https://pkg.go.dev/github.com/go-vela/types/database#User.ToLibrary
users = append(users, tmp.ToLibrary())
}
return users, count, nil
}