From 8184c8d18799feb7ef0aa0eed7e5a2e67a01c791 Mon Sep 17 00:00:00 2001 From: Kyren223 Date: Tue, 14 Jan 2025 16:31:32 +0200 Subject: Added a way to change network properties both server side and client side --- query/networks.sql | 8 ++++++++ 1 file changed, 8 insertions(+) (limited to 'query/networks.sql') diff --git a/query/networks.sql b/query/networks.sql index b1d01c7..a92bc66 100644 --- a/query/networks.sql +++ b/query/networks.sql @@ -18,5 +18,13 @@ UPDATE networks SET WHERE id = ? RETURNING *; +-- name: UpdateNetwork :one +UPDATE networks SET + name = ?, icon = ?, + bg_hex_color = ?, fg_hex_color = ?, + is_public = ? +WHERE id = ? +RETURNING *; + -- name: DeleteNetwork :exec DELETE FROM networks WHERE id = ?; -- cgit v1.3.1