diff options
| author | Runxi Yu <me@runxiyu.org> | 2025-08-18 05:10:14 +0800 |
|---|---|---|
| committer | Runxi Yu <me@runxiyu.org> | 2025-08-18 05:10:14 +0800 |
| commit | dd0017446dcd605b3670784336d38c1083895abe (patch) | |
| tree | d9882611f6c38560c2490ef918ccfa46f09380c4 /forged/sql | |
| parent | Make logging in work (diff) | |
| download | forge-dd0017446dcd605b3670784336d38c1083895abe.tar.gz forge-dd0017446dcd605b3670784336d38c1083895abe.tar.zst forge-dd0017446dcd605b3670784336d38c1083895abe.zip | |
Diffstat (limited to 'forged/sql')
| -rw-r--r-- | forged/sql/queries/groups.sql | 6 |
1 files changed, 6 insertions, 0 deletions
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; |