summaryrefslogtreecommitdiff
path: root/query/frequencies.sql
diff options
context:
space:
mode:
authorKyren223 <Kyren223@proton.me>2024-11-23 22:32:02 +0200
committerKyren223 <Kyren223@proton.me>2024-11-23 22:32:02 +0200
commit7894503e7a5de54b2b6788822d248172ed1ca141 (patch)
treefb752f67af438165eed26cce867c1257d2f4cebb /query/frequencies.sql
parent25c79bfbf37a541f7115b5c9fea3656984b71d54 (diff)
Added network setters
Diffstat (limited to 'query/frequencies.sql')
-rw-r--r--query/frequencies.sql9
1 files changed, 6 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 = ?;