Added frequency queries

1 files changed, 6 insertions, 3 deletions

diff --git a/query/networks.sql b/query/networks.sql
index 424bb2d..2253de4 100644
--- a/query/networks.sql
+++ b/query/networks.sql
@@ -6,7 +6,7 @@ WHERE is_public = true;
 SELECT * FROM networks
 WHERE id = ?;
 
--- -- name: CreateNetwork :one
+-- name: CreateNetwork :one
 INSERT INTO networks (
   id, owner_id, name, is_public,
   icon, bg_hex_color, fg_hex_color
@@ -16,7 +16,7 @@ INSERT INTO networks (
 RETURNING *;
 
 -- name: GetBannedUsersInNetwork :many
-SELECT 
+SELECT
   sqlc.embed(users),
   network_banned_users.banned_at,
   network_banned_users.reason
@@ -26,10 +26,13 @@ WHERE network_banned_users.network_id = ?;
 
 -- name: GetUsersInNetwork :many
 SELECT
-  sqlc.embed(users.),
+  sqlc.embed(users),
   users_networks.joined_at,
   users_networks.is_admin,
   users_networks.is_muted
 FROM users_networks
 JOIN users ON users.id = users_networks.user_id
 WHERE users_networks.network_id = ?;
+
+-- name: DeleteNetwork :exec
+DELETE FROM networks WHERE id = ?;