diff options
| author | Kyren223 <Kyren223@proton.me> | 2024-11-27 22:41:14 +0200 |
|---|---|---|
| committer | Kyren223 <Kyren223@proton.me> | 2024-11-27 22:41:14 +0200 |
| commit | c3f8131caf597dc028c08c8dd9f2f65a213e580d (patch) | |
| tree | 0907927ab413cba3c431699ed2d220be1ffefb66 /query | |
| parent | 4a0d94e4893cd77a0bb498b355d3e1b3cbeed2df (diff) | |
Added networks info on initial server-client connection
Diffstat (limited to 'query')
| -rw-r--r-- | query/users.sql | 5 |
1 files changed, 5 insertions, 0 deletions
diff --git a/query/users.sql b/query/users.sql index d136f15..2528513 100644 --- a/query/users.sql +++ b/query/users.sql @@ -46,3 +46,8 @@ RETURNING *; UPDATE users SET is_deleted = true WHERE id = ? AND is_deleted = false; + +-- name: GetUserNetworks :many +SELECT networks.* FROM networks +JOIN users_networks ON networks.id = users_networks.network_id +WHERE users_networks.user_id = ?; |