/
activation.sql.go
67 lines (58 loc) · 1.7 KB
/
activation.sql.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
// Code generated by sqlc. DO NOT EDIT.
// versions:
// sqlc v1.24.0
// source: activation.sql
package db
import (
"context"
"time"
)
const deleteActivationToken = `-- name: DeleteActivationToken :exec
DELETE from activation_tokens WHERE user_id = $1
`
func (q *Queries) DeleteActivationToken(ctx context.Context, userID int64) error {
_, err := q.db.ExecContext(ctx, deleteActivationToken, userID)
return err
}
const getActivationToken = `-- name: GetActivationToken :one
SELECT user_id, activation_token, is_blocked, expires_at, created_at FROM activation_tokens
WHERE activation_token = $1 LIMIT 1
`
func (q *Queries) GetActivationToken(ctx context.Context, activationToken string) (ActivationToken, error) {
row := q.db.QueryRowContext(ctx, getActivationToken, activationToken)
var i ActivationToken
err := row.Scan(
&i.UserID,
&i.ActivationToken,
&i.IsBlocked,
&i.ExpiresAt,
&i.CreatedAt,
)
return i, err
}
const insertActivationToken = `-- name: InsertActivationToken :one
INSERT INTO activation_tokens (
user_id,
activation_token,
expires_at
) VALUES (
$1, $2, $3
) RETURNING user_id, activation_token, is_blocked, expires_at, created_at
`
type InsertActivationTokenParams struct {
UserID int64 `json:"user_id"`
ActivationToken string `json:"activation_token"`
ExpiresAt time.Time `json:"expires_at"`
}
func (q *Queries) InsertActivationToken(ctx context.Context, arg InsertActivationTokenParams) (ActivationToken, error) {
row := q.db.QueryRowContext(ctx, insertActivationToken, arg.UserID, arg.ActivationToken, arg.ExpiresAt)
var i ActivationToken
err := row.Scan(
&i.UserID,
&i.ActivationToken,
&i.IsBlocked,
&i.ExpiresAt,
&i.CreatedAt,
)
return i, err
}