From c3f8131caf597dc028c08c8dd9f2f65a213e580d Mon Sep 17 00:00:00 2001 From: Kyren223 Date: Wed, 27 Nov 2024 22:41:14 +0200 Subject: Added networks info on initial server-client connection --- query/users.sql | 5 +++++ 1 file changed, 5 insertions(+) (limited to 'query/users.sql') 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 = ?; -- cgit v1.3.1