This repository has been archived by the owner on Sep 16, 2021. It is now read-only.
-
Notifications
You must be signed in to change notification settings - Fork 4
/
users.go
116 lines (96 loc) · 2.25 KB
/
users.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
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
package models
import (
"context"
"database/sql"
"errors"
"time"
"github.com/google/uuid"
)
// User type is a struct for users table.
type User struct {
ID int64 `json:"id"`
Name string `json:"name" validate:"required"`
Email string `json:"email" validate:"required,email"`
Password string `json:"password" validate:"required,min=8"`
APIToken uuid.UUID `db:"api_token" json:"api_token"`
CreatedAt time.Time `db:"created_at" json:"created_at"`
UpdatedAt time.Time `db:"updated_at" json:"updated_at"`
}
// UserResult type is a slice of users.
type UserResult struct {
Data *[]User `json:"data"`
}
// GetUsers retrieves the first twenty users.
func (c *Conn) GetUsers(ctx context.Context) (*UserResult, error) {
var users []User
err := c.db.SelectContext(ctx, &users, queryUsersSelect, 10)
if err != nil && err != sql.ErrNoRows {
return nil, err
}
return &UserResult{&users}, nil
}
// GetUser retrieves a user by a given ID.
func (c *Conn) GetUser(ctx context.Context, id int64) (*User, error) {
var user User
err := c.db.GetContext(ctx, &user, queryUserSelectByID, id)
if err != nil && err != sql.ErrNoRows {
return nil, err
}
return &user, nil
}
// CreateUser creates a new user.
func (c *Conn) CreateUser(ctx context.Context, u *User) error {
_, err := c.db.ExecContext(
ctx,
queryUserInsert,
u.Name,
u.Email,
u.Password,
u.APIToken,
u.CreatedAt,
u.UpdatedAt,
)
if err != nil {
return err
}
return nil
}
// UpdateUser updates a user by a given ID.
func (c *Conn) UpdateUser(ctx context.Context, id int64, u *User) error {
result, err := c.db.ExecContext(
ctx,
queryUserUpdate,
u.Name,
u.Email,
u.Password,
u.APIToken,
u.UpdatedAt,
id,
)
if err != nil {
return err
}
rowsAffected, err := result.RowsAffected()
if err != nil {
return err
}
if rowsAffected == 0 {
return errors.New(errResourceNotFound)
}
return nil
}
// DeleteUser deletes a user by a given ID.
func (c *Conn) DeleteUser(ctx context.Context, id int64) error {
result, err := c.db.ExecContext(ctx, queryUserDelete, id)
if err != nil {
return err
}
rowsAffected, err := result.RowsAffected()
if err != nil {
return err
}
if rowsAffected == 0 {
return errors.New(errResourceNotFound)
}
return nil
}