Added frequency queries

1 files changed, 16 insertions, 2 deletions

diff --git a/query/frequencies.sql b/query/frequencies.sql
index ed68c78..959512e 100644
--- a/query/frequencies.sql
+++ b/query/frequencies.sql
@@ -5,8 +5,22 @@ ORDER BY id;
 
 -- name: CreateFrequency :one
 INSERT INTO frequencies (
-  id, network_id, name
+  id, network_id,
+  name, hex_color,
+  perms, position
 ) VALUES (
-  ?, ?, ?
+  ?, @network_id, ?, ?, ?,
+  (SELECT COUNT(*) FROM frequencies WHERE network_id = @network_id)
 )
 RETURNING *;
+
+-- name: SwapFrequencies :exec
+UPDATE frequencies SET
+  position = CASE
+    WHEN position = @pos1 THEN @pos2
+    WHEN position = @pos2 THEN @pos1
+  END
+WHERE network_id = ? AND position IN (@pos1, @pos2);
+
+-- name: DeleteFrequency :exec
+DELETE FROM frequencies WHERE id = ?;