From b67ab26b89e16d4492145702b0ef899d3d6b7416 Mon Sep 17 00:00:00 2001 From: Kyren223 Date: Sat, 23 Nov 2024 20:27:10 +0200 Subject: Added frequency queries --- query/frequencies.sql | 18 ++++++++++++++++-- 1 file changed, 16 insertions(+), 2 deletions(-) (limited to 'query/frequencies.sql') 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 = ?; -- cgit v1.3.1