diff options
| author | Runxi Yu <me@runxiyu.org> | 2025-08-12 11:01:07 +0800 |
|---|---|---|
| committer | Runxi Yu <me@runxiyu.org> | 2025-09-16 08:58:16 +0800 |
| commit | c12fe030fe5935882047e75ac8a3792faea27574 (patch) | |
| tree | e2b6f795410348596a7965694bed7e85511d0874 /forged/sql/queries/repos.sql | |
| parent | Remove forge-specific functions from misc (diff) | |
| download | forge-c12fe030fe5935882047e75ac8a3792faea27574.tar.gz forge-c12fe030fe5935882047e75ac8a3792faea27574.tar.zst forge-c12fe030fe5935882047e75ac8a3792faea27574.zip | |
Diffstat (limited to 'forged/sql/queries/repos.sql')
| -rw-r--r-- | forged/sql/queries/repos.sql | 9 |
1 files changed, 9 insertions, 0 deletions
diff --git a/forged/sql/queries/repos.sql b/forged/sql/queries/repos.sql new file mode 100644 index 0000000..cacc5b8 --- /dev/null +++ b/forged/sql/queries/repos.sql @@ -0,0 +1,9 @@ +-- name: InsertRepo :one +INSERT INTO repos (group_id, name, description, contrib_requirements) +VALUES ($1, $2, $3, $4) +RETURNING id; + +-- name: GetRepoByGroupAndName :one +SELECT id, name, COALESCE(description, '') AS description +FROM repos +WHERE group_id = $1 AND name = $2; |