Added network setters

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 = ?;