diff options
Diffstat (limited to 'query/networks.sql')
| -rw-r--r-- | query/networks.sql | 26 |
1 files changed, 26 insertions, 0 deletions
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 = ?; |
