Added setter queries for frequency

1 files changed, 20 insertions, 2 deletions

diff --git a/query/frequencies.sql b/query/frequencies.sql
index 959512e..6e18fe6 100644
--- a/query/frequencies.sql
+++ b/query/frequencies.sql
@@ -1,7 +1,10 @@
 -- name: GetNetworkFrequencies :many
 SELECT * FROM frequencies
-WHERE network_id = ?
-ORDER BY id;
+WHERE network_id = ?;
+
+-- name: GetFrequencyById :one
+SELECT * FROM frequencies
+WHERE id = ?;
 
 -- name: CreateFrequency :one
 INSERT INTO frequencies (
@@ -22,5 +25,20 @@ UPDATE frequencies SET
   END
 WHERE network_id = ? AND position IN (@pos1, @pos2);
 
+-- name: SetFrequencyName :one
+UPDATE frequencies SET
+  name = ?
+WHERE id = ?;
+
+-- name: SetFrequencyColor :one
+UPDATE frequencies SET
+  hex_color = ?
+WHERE id = ?;
+
+-- name: SetFrequencyPerms :one
+UPDATE frequencies SET
+  perms = ?
+WHERE id = ?;
+
 -- name: DeleteFrequency :exec
 DELETE FROM frequencies WHERE id = ?;