sql/users.sql


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23

-- name: GetUsers :many
SELECT *
  FROM users;

-- name: GetUserByName :one
SELECT *
  FROM users
 WHERE LOWER(name) = LOWER($1);

-- name: GetUserById :one
SELECT *
  FROM users
 WHERE id = $1;

-- name: GetPwdById :one
 SELECT pwd
   FROM users
 WHERE id = $1;

-- name: UpdatePwd :exec
 UPDATE users
    SET pwd = $1
  WHERE id = $2;