-
Notifications
You must be signed in to change notification settings - Fork 0
/
users.go
114 lines (96 loc) · 2.83 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
package store
import (
"context"
sq "github.com/Masterminds/squirrel"
"github.com/google/uuid"
"github.com/l-orlov/slim-fairy/bot/internal/model"
)
// CreateUser creates model.User
func (s *Storage) CreateUser(ctx context.Context, record *model.User) error {
return s.createUser(ctx, s.pool, record)
}
// CreateUserTx creates model.User in transaction
func (s *Storage) CreateUserTx(ctx context.Context, tx Tx, record *model.User) error {
return s.createUser(ctx, tx, record)
}
// createUser creates model.User
func (s *Storage) createUser(ctx context.Context, db Querier, record *model.User) error {
query := psql().
Insert(record.DbTable()).
SetMap(userAttrs(record)).
Suffix("RETURNING " + asteriskUsers)
err := Getx(ctx, db, record, query)
if err != nil {
return dbError(err)
}
return nil
}
// UpdateUser updates model.User
func (s *Storage) UpdateUser(ctx context.Context, record *model.User) error {
query := psql().
Update(record.DbTable()).
Where(sq.Eq{"id": record.ID}).
SetMap(userAttrs(record)).
Suffix("RETURNING " + asteriskUsers)
err := Getx(ctx, s.pool, record, query)
if err != nil {
return dbError(err)
}
return nil
}
// GetUserByID gets model.User by id
func (s *Storage) GetUserByID(ctx context.Context, id uuid.UUID) (*model.User, error) {
record := &model.User{}
query := psql().
Select(asteriskUsers).
From(record.DbTable()).
Where(sq.Eq{"id": id}).
Limit(1)
err := Getx(ctx, s.pool, record, query)
if err != nil {
return nil, dbError(err)
}
return record, nil
}
// GetUserByTelegramID gets model.User by telegram_id
func (s *Storage) GetUserByTelegramID(ctx context.Context, telegramID int64) (*model.User, error) {
record := &model.User{}
query := psql().
Select(asteriskUsers).
From(record.DbTable()).
Where(sq.Eq{"telegram_id": telegramID}).
Limit(1)
err := Getx(ctx, s.pool, record, query)
if err != nil {
return nil, dbError(err)
}
return record, nil
}
// GetUserByEmail gets model.User by email
func (s *Storage) GetUserByEmail(ctx context.Context, email string) (*model.User, error) {
record := &model.User{}
query := psql().
Select(asteriskUsers).
From(record.DbTable()).
Where(sq.Eq{"email": email}).
Limit(1)
err := Getx(ctx, s.pool, record, query)
if err != nil {
return nil, dbError(err)
}
return record, nil
}
func userAttrs(record *model.User) map[string]interface{} {
return map[string]interface{}{
"name": record.Name,
"email": record.Email,
"phone": record.Phone,
"telegram_id": record.TelegramID,
"age": record.Age,
"weight": record.Weight,
"height": record.Height,
"gender": record.Gender,
"physical_activity_level": record.PhysicalActivity,
"created_by": record.CreatedBy,
}
}