diff options
| author | Kyren223 <Kyren223@proton.me> | 2025-01-20 17:32:31 +0200 |
|---|---|---|
| committer | Kyren223 <Kyren223@proton.me> | 2025-01-20 17:32:31 +0200 |
| commit | 5a5c09282416d131ec4a77bc9cf854fa0f29ae12 (patch) | |
| tree | e327591b3c7c71227edc4befcf3675367e46fa49 /query/users.sql | |
| parent | ab36f88c0e3acc227292bd5201824855d8675bd5 (diff) | |
Implemented user settings both client side and server side
Diffstat (limited to 'query/users.sql')
| -rw-r--r-- | query/users.sql | 8 |
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 = ?; |
