From dd0017446dcd605b3670784336d38c1083895abe Mon Sep 17 00:00:00 2001
From: Runxi Yu <me@runxiyu.org>
Date: Mon, 18 Aug 2025 05:10:14 +0800
Subject: Start doing the group index page...

---
 forged/sql/queries/groups.sql | 6 ++++++
 1 file changed, 6 insertions(+)

(limited to 'forged/sql/queries/groups.sql')

diff --git a/forged/sql/queries/groups.sql b/forged/sql/queries/groups.sql
index 5b48fc4..90c9a94 100644
--- a/forged/sql/queries/groups.sql
+++ b/forged/sql/queries/groups.sql
@@ -28,3 +28,9 @@ SELECT c.id, COALESCE(g.description, '')
 FROM group_path_cte c
 JOIN groups g ON g.id = c.id
 WHERE c.depth = cardinality($1::text[]);
+
+-- name: GetReposInGroup :many
+SELECT name, COALESCE(description, '') FROM repos WHERE group_id = $1;
+
+-- name: GetSubgroups :many
+SELECT name, COALESCE(description, '') FROM groups WHERE parent_group = $1;
-- 
cgit v1.2.3

