blob: 95be0ab3c7558bddde61828364a0e2fbc39bed92 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
|
-- name: GetNetworkFrequencies :many
SELECT * FROM frequencies
WHERE network_id = ?
ORDER BY position;
-- name: GetFrequencyById :one
SELECT * FROM frequencies
WHERE id = ?;
-- name: CreateFrequency :one
INSERT INTO frequencies (
id, network_id,
name, hex_color,
perms, position
) VALUES (
@id, @network_id, @name, @hex_color, @perms,
(SELECT COUNT(*) FROM frequencies WHERE network_id = @network_id)
)
RETURNING *;
-- name: UpdateFrequency :one
UPDATE frequencies SET
name = ?, hex_color = ?, perms = ?
WHERE id = ?
RETURNING *;
-- name: SwapFrequencies :exec
UPDATE frequencies SET
position = CASE
WHEN position = @pos1 THEN @pos2
WHEN position = @pos2 THEN @pos1
END
WHERE network_id = @network_id AND position IN (@pos1, @pos2);
-- name: DeleteFrequency :exec
DELETE FROM frequencies WHERE id = ?;
|
