diff options
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; |