diff options
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 |