diff options
| author | Runxi Yu <me@runxiyu.org> | 2025-08-18 03:12:41 +0800 |
|---|---|---|
| committer | Runxi Yu <me@runxiyu.org> | 2025-08-18 03:12:41 +0800 |
| commit | f7dde29539536a67687cbeff9662a9617e077150 (patch) | |
| tree | d976eb1f64062a65da4e689bd650ad84be737c52 /forged/sql/queries | |
| parent | Move sql to inside forged (diff) | |
| download | forge-f7dde29539536a67687cbeff9662a9617e077150.tar.gz forge-f7dde29539536a67687cbeff9662a9617e077150.tar.zst forge-f7dde29539536a67687cbeff9662a9617e077150.zip | |
Make the index page work
Diffstat (limited to 'forged/sql/queries')
| -rw-r--r-- | forged/sql/queries/groups.sql | 3 |
1 files changed, 3 insertions, 0 deletions
diff --git a/forged/sql/queries/groups.sql b/forged/sql/queries/groups.sql index 07fe5e7..5b48fc4 100644 --- a/forged/sql/queries/groups.sql +++ b/forged/sql/queries/groups.sql @@ -1,3 +1,6 @@ +-- name: GetRootGroups :many +SELECT name, COALESCE(description, '') FROM groups WHERE parent_group IS NULL; + -- name: GetGroupIDDescByPath :one WITH RECURSIVE group_path_cte AS ( SELECT |