diff options
Diffstat (limited to 'query/networks.sql')
| -rw-r--r-- | query/networks.sql | 9 |
1 files changed, 6 insertions, 3 deletions
diff --git a/query/networks.sql b/query/networks.sql index 424bb2d..2253de4 100644 --- a/query/networks.sql +++ b/query/networks.sql @@ -6,7 +6,7 @@ WHERE is_public = true; SELECT * FROM networks WHERE id = ?; --- -- name: CreateNetwork :one +-- name: CreateNetwork :one INSERT INTO networks ( id, owner_id, name, is_public, icon, bg_hex_color, fg_hex_color @@ -16,7 +16,7 @@ INSERT INTO networks ( RETURNING *; -- name: GetBannedUsersInNetwork :many -SELECT +SELECT sqlc.embed(users), network_banned_users.banned_at, network_banned_users.reason @@ -26,10 +26,13 @@ WHERE network_banned_users.network_id = ?; -- name: GetUsersInNetwork :many SELECT - sqlc.embed(users.), + sqlc.embed(users), users_networks.joined_at, users_networks.is_admin, users_networks.is_muted FROM users_networks JOIN users ON users.id = users_networks.user_id WHERE users_networks.network_id = ?; + +-- name: DeleteNetwork :exec +DELETE FROM networks WHERE id = ?; |