From be22bb89db0b952ea0545e7c65b46e92ebb205d2 Mon Sep 17 00:00:00 2001
From: Kyren223 <Kyren223@proton.me>
Date: Wed, 27 Nov 2024 17:34:28 +0200
Subject: Added create network to server api

---
 query/networks.sql | 21 +++++++++++++++++++--
 1 file changed, 19 insertions(+), 2 deletions(-)

(limited to 'query/networks.sql')

diff --git a/query/networks.sql b/query/networks.sql
index dfa7b6b..0b0303f 100644
--- a/query/networks.sql
+++ b/query/networks.sql
@@ -16,7 +16,7 @@ INSERT INTO networks (
 )
 RETURNING *;
 
--- name: GetBannedUsersInNetwork :many
+-- name: GetNetworkBannedUsers :many
 SELECT
   sqlc.embed(users),
   users_networks.ban_reason
@@ -24,7 +24,7 @@ FROM users_networks
 JOIN users ON users.id = users_networks.user_id
 WHERE users_networks.network_id = ?;
 
--- name: GetUsersInNetwork :many
+-- name: GetNetworkMembers :many
 SELECT
   sqlc.embed(users),
   users_networks.joined_at,
@@ -62,3 +62,20 @@ RETURNING *;
 
 -- name: DeleteNetwork :exec
 DELETE FROM networks WHERE id = ?;
+
+-- name: SetNetworkUser :one
+INSERT INTO users_networks (
+  user_id, network_id,
+  is_member, is_admin, is_muted,
+  is_banned, ban_reason
+) VALUES (
+  ?, ?,
+  ?, ?, ?,
+  ?, ?
+)
+ON CONFLICT DO 
+UPDATE SET
+  is_member = ?, is_admin = ?, is_muted = ?,
+  is_banned = ?, ban_reason = ?
+WHERE user_id = ? AND network_id = ?
+RETURNING *;
-- 
cgit v1.3.1