diff options
| author | Kyren223 <Kyren223@proton.me> | 2025-01-14 16:31:32 +0200 |
|---|---|---|
| committer | Kyren223 <Kyren223@proton.me> | 2025-01-14 16:31:32 +0200 |
| commit | 8184c8d18799feb7ef0aa0eed7e5a2e67a01c791 (patch) | |
| tree | 45a0174ed90b11c6ce89db06ee7237e6ae4dad20 /query/networks.sql | |
| parent | fa2ba2fe8bf24cc9ddc28ec30ea64647d17af1d6 (diff) | |
Added a way to change network properties both server side and client
side
Diffstat (limited to 'query/networks.sql')
| -rw-r--r-- | query/networks.sql | 8 |
1 files changed, 8 insertions, 0 deletions
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 = ?; |