summaryrefslogtreecommitdiff
path: root/query/networks.sql
diff options
context:
space:
mode:
Diffstat (limited to 'query/networks.sql')
-rw-r--r--query/networks.sql26
1 files changed, 26 insertions, 0 deletions
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 = ?;