summaryrefslogtreecommitdiff
path: root/query/networks.sql
diff options
context:
space:
mode:
authorKyren223 <Kyren223@proton.me>2025-01-09 17:28:46 +0200
committerKyren223 <Kyren223@proton.me>2025-01-09 17:28:46 +0200
commit936d3cf690ace9adfdfe0fb44193c11a0cb26d95 (patch)
tree3d0699aa5c50efb7ecac3dddd25fe959366b7562 /query/networks.sql
parentd0cb135161b18f37c25501cb863fa783cd723758 (diff)
Added goose for migrations, refactored SQL schema, server and client
are broken
Diffstat (limited to 'query/networks.sql')
-rw-r--r--query/networks.sql24
1 files changed, 0 insertions, 24 deletions
diff --git a/query/networks.sql b/query/networks.sql
index 64f56dc..b1d01c7 100644
--- a/query/networks.sql
+++ b/query/networks.sql
@@ -1,7 +1,3 @@
--- name: GetPublicNetworks :many
-SELECT * FROM networks
-WHERE is_public = true;
-
-- name: GetNetworkById :one
SELECT * FROM networks
WHERE id = ?;
@@ -16,26 +12,6 @@ INSERT INTO networks (
)
RETURNING *;
--- name: SetNetworkName :one
-UPDATE networks SET
- name = ?
-WHERE id = ?
-RETURNING *;
-
--- name: SetNetworkIcon :one
-UPDATE networks SET
- icon = ?,
- bg_hex_color = ?,
- fg_hex_color = ?
-WHERE id = ?
-RETURNING *;
-
--- name: SetNetworkIsPublic :one
-UPDATE networks SET
- is_public = ?
-WHERE id = ?
-RETURNING *;
-
-- name: TransferNetwork :one
UPDATE networks SET
owner_id = ?