diff options
| author | Kyren223 <Kyren223@proton.me> | 2025-01-04 18:35:44 +0200 |
|---|---|---|
| committer | Kyren223 <Kyren223@proton.me> | 2025-01-04 18:35:44 +0200 |
| commit | 614cc4d9dabc0e058ee149fbc2fcff866ae62a41 (patch) | |
| tree | 4f2c674520dc3105ea3c9c549704cca7e1db294d /query/users_networks.sql | |
| parent | feb8562dd0b6a0ec35781e80756dc3761e6b1ade (diff) | |
Implemented joining functionality
Diffstat (limited to 'query/users_networks.sql')
| -rw-r--r-- | query/users_networks.sql | 5 |
1 files changed, 5 insertions, 0 deletions
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 |