From 7894503e7a5de54b2b6788822d248172ed1ca141 Mon Sep 17 00:00:00 2001 From: Kyren223 Date: Sat, 23 Nov 2024 22:32:02 +0200 Subject: Added network setters --- query/frequencies.sql | 9 ++++++--- query/messages.sql | 7 +++++++ query/networks.sql | 26 ++++++++++++++++++++++++++ 3 files changed, 39 insertions(+), 3 deletions(-) (limited to 'query') 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 = ?; diff --git a/query/messages.sql b/query/messages.sql index a598754..c345068 100644 --- a/query/messages.sql +++ b/query/messages.sql @@ -9,3 +9,10 @@ INSERT INTO messages ( ?, ?, ?, ?, ? ) RETURNING *; + +-- name: EditMessage :one +UPDATE messages SET + edited = true, + content = ? +WHERE id = ? +RETURNING *; diff --git a/query/networks.sql b/query/networks.sql index 2253de4..751bf11 100644 --- a/query/networks.sql +++ b/query/networks.sql @@ -34,5 +34,31 @@ FROM users_networks JOIN users ON users.id = users_networks.user_id WHERE users_networks.network_id = ?; +-- name: SetNetworkName :one +UPDATE networks SET + name = ? +WHERE id = ? +RETURNING *; + +-- name: SetNetworkIcon :one +UPDATE networks SET + icon - ? + bg_hex_color = ? + fg_hex_color = ? +WHERE id = ? +RETURNING *; + +-- name: SetNetworkIsPublic :one +UPDATE networks SET + is_public = ? +WHERE id = ? +RETURNING *; + +-- name: TransferNetwork :one +UPDATE networks SET + owner_id = ? +WHERE id = ? +RETURNING *; + -- name: DeleteNetwork :exec DELETE FROM networks WHERE id = ?; -- cgit v1.3.1