Source identity
| Field | Recorded value |
|---|---|
| Source type | GitHub source |
| Original record | Janady13/missionmatch / db/queries/requirements.sql |
| Date | Not specified in source |
| Repository | Janady13/missionmatch |
| Revision | 39df94f92b2a33f852481fe1954dabed841524bb |
| Branch | w0-aedt-compliance |
| Path or archive member | db/queries/requirements.sql |
| Original SHA-256 | c57c679578f698010da083b98f4457230cf880fb80082d33276a0377f67b5d22 |
| Git blob SHA | 0fade7533b688f1b35b677121d531ca5b3d73cb6 |
| Reading-copy SHA-256 | c57c679578f698010da083b98f4457230cf880fb80082d33276a0377f67b5d22 |
Recovered source transcript
Download complete source text ↓37 lines · 1.2 KB
-- name: CreateRequirement :one
INSERT INTO requirements (
organization_id, opportunity_id, title, customer_agency,
required_level, required_poly, required_years,
work_location, remote_allowed, key_personnel
) VALUES ($1,$2,$3,$4,$5,$6,$7,$8,$9,$10)
RETURNING *;
-- name: GetRequirement :one
SELECT * FROM requirements WHERE id = $1 AND deleted_at IS NULL;
-- name: ListRequirements :many
SELECT * FROM requirements
WHERE deleted_at IS NULL
ORDER BY created_at DESC
LIMIT $1 OFFSET $2;
-- name: AddRequiredSkill :exec
INSERT INTO required_skills (organization_id, requirement_id, skill_id, mandatory)
VALUES ($1,$2,$3,$4)
ON CONFLICT (requirement_id, skill_id) DO UPDATE SET mandatory = EXCLUDED.mandatory;
-- name: ListRequiredSkills :many
SELECT s.id, s.name, rs.mandatory
FROM required_skills rs
JOIN skills s ON s.id = rs.skill_id
WHERE rs.requirement_id = $1
ORDER BY s.name;
-- name: AddRequiredCertification :exec
INSERT INTO required_certifications (organization_id, requirement_id, name)
VALUES ($1,$2,$3)
ON CONFLICT (requirement_id, name) DO NOTHING;
-- name: ListRequiredCertifications :many
SELECT name FROM required_certifications WHERE requirement_id = $1 ORDER BY name;