From 7894503e7a5de54b2b6788822d248172ed1ca141 Mon Sep 17 00:00:00 2001 From: Kyren223 Date: Sat, 23 Nov 2024 22:32:02 +0200 Subject: Added network setters --- query/networks.sql | 26 ++++++++++++++++++++++++++ 1 file changed, 26 insertions(+) (limited to 'query/networks.sql') diff --git a/query/networks.sql b/query/networks.sql index 2253de4..751bf11 100644 --- a/query/networks.sql +++ b/query/networks.sql @@ -34,5 +34,31 @@ FROM users_networks JOIN users ON users.id = users_networks.user_id WHERE users_networks.network_id = ?; +-- name: SetNetworkName :one +UPDATE networks SET + name = ? +WHERE id = ? +RETURNING *; + +-- name: SetNetworkIcon :one +UPDATE networks SET + icon - ? + bg_hex_color = ? + fg_hex_color = ? +WHERE id = ? +RETURNING *; + +-- name: SetNetworkIsPublic :one +UPDATE networks SET + is_public = ? +WHERE id = ? +RETURNING *; + +-- name: TransferNetwork :one +UPDATE networks SET + owner_id = ? +WHERE id = ? +RETURNING *; + -- name: DeleteNetwork :exec DELETE FROM networks WHERE id = ?; -- cgit v1.3.1