Added network setters

3 files changed, 39 insertions, 3 deletions

diff --git a/query/frequencies.sql b/query/frequencies.sql
index 6e18fe6..6e67c24 100644
--- a/query/frequencies.sql
+++ b/query/frequencies.sql
@@ -28,17 +28,20 @@ WHERE network_id = ? AND position IN (@pos1, @pos2);
 -- name: SetFrequencyName :one
 UPDATE frequencies SET
   name = ?
-WHERE id = ?;
+WHERE id = ?
+RETURNING *;
 
 -- name: SetFrequencyColor :one
 UPDATE frequencies SET
   hex_color = ?
-WHERE id = ?;
+WHERE id = ?
+RETURNING *;
 
 -- name: SetFrequencyPerms :one
 UPDATE frequencies SET
   perms = ?
-WHERE id = ?;
+WHERE id = ?
+RETURNING *;
 
 -- name: DeleteFrequency :exec
 DELETE FROM frequencies WHERE id = ?;
diff --git a/query/messages.sql b/query/messages.sql
index a598754..c345068 100644
--- a/query/messages.sql
+++ b/query/messages.sql
@@ -9,3 +9,10 @@ INSERT INTO messages (
   ?, ?, ?, ?, ?
 )
 RETURNING *;
+
+-- name: EditMessage :one
+UPDATE messages SET
+  edited = true,
+  content = ?
+WHERE id = ?
+RETURNING *;
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 = ?;