From 77d9971982e336aa6c0b816d84f2d37780c02de6 Mon Sep 17 00:00:00 2001 From: Kyren223 Date: Sat, 23 Nov 2024 18:47:26 +0200 Subject: Added network queries --- query/users.sql | 11 +---------- 1 file changed, 1 insertion(+), 10 deletions(-) (limited to 'query/users.sql') 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 -- cgit v1.3.1