From 614cc4d9dabc0e058ee149fbc2fcff866ae62a41 Mon Sep 17 00:00:00 2001 From: Kyren223 Date: Sat, 4 Jan 2025 18:35:44 +0200 Subject: Implemented joining functionality --- query/users_networks.sql | 5 +++++ 1 file changed, 5 insertions(+) (limited to 'query') diff --git a/query/users_networks.sql b/query/users_networks.sql index 76cecf4..592c9e5 100644 --- a/query/users_networks.sql +++ b/query/users_networks.sql @@ -16,6 +16,11 @@ FROM users_networks JOIN users ON users.id = users_networks.user_id WHERE users_networks.network_id = ? AND is_member = true; +-- name: GetNetworkMemberById :one +SELECT * +FROM users_networks +WHERE users_networks.network_id = ? AND users_networks.user_id = ?; + -- name: GetUserNetworks :many SELECT sqlc.embed(networks), users_networks.position FROM networks JOIN users_networks ON networks.id = users_networks.network_id -- cgit v1.3.1