keii.dev
1-- name: CreateUser :exec
2INSERT INTO
3 user (username, email, password, invited_by)
4VALUES
5 (?, ?, ?, ?);
6
7-- name: GetUserByEmailOrUsername :one
8SELECT
9 user.email,
10 user.username
11FROM
12 user
13WHERE
14 user.email = ?
15 OR user.username = ?;
16
17-- name: GetUserByEmail :one
18SELECT
19 user.id,
20 user.username,
21 user.email,
22 user.password,
23 user.invited_by
24FROM
25 user
26WHERE
27 user.email = ?;
28
29-- name: GetUserByID :one
30SELECT
31 user.id,
32 user.username,
33 user.email,
34 user.password,
35 user.invited_by
36FROM
37 user
38WHERE
39 user.id = ?;
40
41-- name: GetUserByUsername :one
42SELECT
43 user.id,
44 user.username,
45 user.email,
46 user.password,
47 user.invited_by
48FROM
49 user
50WHERE
51 user.username = ?;
52
53-- name: UpdateUserPassword :exec
54UPDATE user
55SET
56 password = ?
57WHERE
58 user.id = ?;