summaryrefslogtreecommitdiff
path: root/query/users.sql
diff options
context:
space:
mode:
authorKyren223 <Kyren223@proton.me>2025-01-20 17:32:31 +0200
committerKyren223 <Kyren223@proton.me>2025-01-20 17:32:31 +0200
commit5a5c09282416d131ec4a77bc9cf854fa0f29ae12 (patch)
treee327591b3c7c71227edc4befcf3675367e46fa49 /query/users.sql
parentab36f88c0e3acc227292bd5201824855d8675bd5 (diff)
Implemented user settings both client side and server side
Diffstat (limited to 'query/users.sql')
-rw-r--r--query/users.sql8
1 files changed, 7 insertions, 1 deletions
diff --git a/query/users.sql b/query/users.sql
index 0d58b2d..bd91cda 100644
--- a/query/users.sql
+++ b/query/users.sql
@@ -4,7 +4,7 @@ WHERE id = ? AND is_deleted = false;
-- name: GetUserByPublicKey :one
SELECT * FROM users
-WHERE public_key = ? AND is_deleted = false;
+WHERE public_key = ?;
-- name: CreateUser :one
INSERT INTO users (
@@ -31,6 +31,12 @@ UPDATE SET
WHERE user_id = EXCLUDED.user_id
RETURNING *;
+-- name: UpdateUser :one
+UPDATE users SET
+ name = ?, description = ?, is_public_dm = ?
+WHERE id = ?
+RETURNING *;
+
-- name: GetUserData :one
SELECT data FROM user_data
WHERE user_id = ?;