forged/sql/queries/repos.sql


1
2
3
4
5
6
7
8
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;