From 77d9971982e336aa6c0b816d84f2d37780c02de6 Mon Sep 17 00:00:00 2001 From: Kyren223 Date: Sat, 23 Nov 2024 18:47:26 +0200 Subject: Added network queries --- query/networks.sql | 32 ++++++++++++++++++++++++++------ 1 file changed, 26 insertions(+), 6 deletions(-) (limited to 'query/networks.sql') diff --git a/query/networks.sql b/query/networks.sql index d709975..424bb2d 100644 --- a/query/networks.sql +++ b/query/networks.sql @@ -1,15 +1,35 @@ --- name: ListNetworks :many +-- name: GetPublicNetworks :many SELECT * FROM networks -ORDER BY id; +WHERE is_public = true; --- name: GetNetwork :one +-- name: GetNetworkById :one SELECT * FROM networks WHERE id = ?; --- name: CreateNetwork :one +-- -- name: CreateNetwork :one INSERT INTO networks ( - id, name, owner_id + id, owner_id, name, is_public, + icon, bg_hex_color, fg_hex_color ) VALUES ( - ?, ?, ? + ?, ?, ?, ?, ?, ?, ? ) RETURNING *; + +-- name: GetBannedUsersInNetwork :many +SELECT + sqlc.embed(users), + network_banned_users.banned_at, + network_banned_users.reason +FROM network_banned_users +JOIN users ON users.id = network_banned_users.banned_user_id +WHERE network_banned_users.network_id = ?; + +-- name: GetUsersInNetwork :many +SELECT + 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 = ?; -- cgit v1.3.1