Source identity
| Field | Recorded value |
|---|---|
| Source type | GitHub source |
| Original record | Janady13/missionmatch / db/queries/skills.sql |
| Date | Not specified in source |
| Repository | Janady13/missionmatch |
| Revision | 39df94f92b2a33f852481fe1954dabed841524bb |
| Branch | w0-aedt-compliance |
| Path or archive member | db/queries/skills.sql |
| Original SHA-256 | 663c205d3a162a2c02e1b4d77f9c6becd71e75d2cd109b664d57545dbdcce8b9 |
| Git blob SHA | 624148a5f52d8dff5840ead42f27f1b336445a02 |
| Reading-copy SHA-256 | 663c205d3a162a2c02e1b4d77f9c6becd71e75d2cd109b664d57545dbdcce8b9 |
Recovered source transcript
Download complete source text ↓20 lines · 0.6 KB
-- name: UpsertSkill :one
INSERT INTO skills (name, category, embedding)
VALUES ($1,$2,$3)
ON CONFLICT (name) DO UPDATE SET category = EXCLUDED.category
RETURNING *;
-- name: GetSkillByName :one
SELECT * FROM skills WHERE name = $1;
-- name: ListSkills :many
SELECT * FROM skills ORDER BY name LIMIT $1 OFFSET $2;
-- name: SearchSkillsSemantic :many
-- Cosine nearest-neighbor over the skills ontology (powers semantic skill adjacency).
SELECT id, name, (embedding <=> $1::vector)::float8 AS distance
FROM skills
WHERE embedding IS NOT NULL
ORDER BY embedding <=> $1::vector, name, id -- unique tiebreaker => deterministic [review SQLC-3]
LIMIT $2;