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