summaryrefslogtreecommitdiff
path: root/query/users.sql
diff options
context:
space:
mode:
authorKyren223 <Kyren223@proton.me>2024-11-23 18:47:26 +0200
committerKyren223 <Kyren223@proton.me>2024-11-23 18:47:26 +0200
commit77d9971982e336aa6c0b816d84f2d37780c02de6 (patch)
tree0001051202a93b5b994d3fd5470e5bfc35a67af5 /query/users.sql
parent63a1d24295122728820a61aa93b3da6cd6d401d9 (diff)
Added network queries
Diffstat (limited to 'query/users.sql')
-rw-r--r--query/users.sql11
1 files changed, 1 insertions, 10 deletions
diff --git a/query/users.sql b/query/users.sql
index 9866c8a..f3629ca 100644
--- a/query/users.sql
+++ b/query/users.sql
@@ -36,21 +36,12 @@ UPDATE users SET
WHERE id = ? AND is_deleted = false
RETURNING *;
--- name: SerUserPublicDMs :one
+-- name: SetUserPublicDMs :one
UPDATE users SET
is_public_dm = ?
WHERE id = ? AND is_deleted = false
RETURNING *;
--- name: UpdateUser :one
-UPDATE users SET
- name = COALESCE(?, name),
- public_key = COALESCE(?, public_key),
- description = COALESCE(?, description),
- is_public_dm = COALESCE(?, is_public_dm)
-WHERE id = ? AND is_deleted = false
-RETURNING *;
-
-- name: DeleteUser :one
UPDATE users SET
is_deleted = true