diff options
| author | Runxi Yu <me@runxiyu.org> | 2025-08-12 11:01:07 +0800 |
|---|---|---|
| committer | Runxi Yu <me@runxiyu.org> | 2025-09-15 15:19:12 +0800 |
| commit | eb82fdb2dc0903e6125014abd64aceab42c8eb35 (patch) | |
| tree | c07276ba1595c415ebc28943163d88f3e3180254 /forged/sql/queries/repos.sql | |
| parent | Remove forge-specific functions from misc (diff) | |
| download | forge-master.tar.gz forge-master.tar.zst forge-master.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; |