From 5a5c09282416d131ec4a77bc9cf854fa0f29ae12 Mon Sep 17 00:00:00 2001 From: Kyren223 Date: Mon, 20 Jan 2025 17:32:31 +0200 Subject: Implemented user settings both client side and server side --- query/users.sql | 8 +++++++- 1 file changed, 7 insertions(+), 1 deletion(-) (limited to 'query/users.sql') 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 = ?; -- cgit v1.3.1