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 --- internal/data/networks.sql.go | 40 ++++++++++++++++++++++++++++++++++++++++ 1 file changed, 40 insertions(+) (limited to 'internal/data') diff --git a/internal/data/networks.sql.go b/internal/data/networks.sql.go index 5091602..af3c273 100644 --- a/internal/data/networks.sql.go +++ b/internal/data/networks.sql.go @@ -110,3 +110,43 @@ func (q *Queries) TransferNetwork(ctx context.Context, arg TransferNetworkParams ) return i, err } + +const updateNetwork = `-- name: UpdateNetwork :one +UPDATE networks SET + name = ?, icon = ?, + bg_hex_color = ?, fg_hex_color = ?, + is_public = ? +WHERE id = ? +RETURNING id, owner_id, name, icon, bg_hex_color, fg_hex_color, is_public +` + +type UpdateNetworkParams struct { + Name string + Icon string + BgHexColor string + FgHexColor string + IsPublic bool + ID snowflake.ID +} + +func (q *Queries) UpdateNetwork(ctx context.Context, arg UpdateNetworkParams) (Network, error) { + row := q.db.QueryRowContext(ctx, updateNetwork, + arg.Name, + arg.Icon, + arg.BgHexColor, + arg.FgHexColor, + arg.IsPublic, + arg.ID, + ) + var i Network + err := row.Scan( + &i.ID, + &i.OwnerID, + &i.Name, + &i.Icon, + &i.BgHexColor, + &i.FgHexColor, + &i.IsPublic, + ) + return i, err +} -- cgit v1.3.1