/
user_query.go
69 lines (56 loc) · 1.52 KB
/
user_query.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
package queries
import (
"github.com/0xsp4c3/core/app/models"
"github.com/google/uuid"
"github.com/jmoiron/sqlx"
)
// UserQueries struct for queries from User model.
type UserQueries struct {
*sqlx.DB
}
// GetUserByID query for getting one User by given ID.
func (q *UserQueries) GetUserByID(id uuid.UUID) (models.User, error) {
// Define User variable.
user := models.User{}
// Define query string.
query := `SELECT * FROM users WHERE id = $1`
// Send query to database.
err := q.Get(&user, query, id)
if err != nil {
// Return empty object and error.
return user, err
}
// Return query result.
return user, nil
}
// GetUserByEmail query for getting one User by given Email.
func (q *UserQueries) GetUserByEmail(email string) (models.User, error) {
// Define User variable.
user := models.User{}
// Define query string.
query := `SELECT * FROM users WHERE email = $1`
// Send query to database.
err := q.Get(&user, query, email)
if err != nil {
// Return empty object and error.
return user, err
}
// Return query result.
return user, nil
}
// CreateUser query for creating a new user by given email and password hash.
func (q *UserQueries) CreateUser(u *models.User) error {
// Define query string.
query := `INSERT INTO users VALUES ($1, $2, $3, $4, $5, $6, $7)`
// Send query to database.
_, err := q.Exec(
query,
u.ID, u.CreatedAt, u.UpdatedAt, u.Email, u.PasswordHash, u.UserStatus, u.UserRole,
)
if err != nil {
// Return only error.
return err
}
// This query returns nothing.
return nil
}