Janady13/missionmatch / internal/platform/database/dbgen/evaluations.sql.go

1// Code generated by sqlc. DO NOT EDIT. 2// versions: 3// sqlc v1.31.1 4// source: evaluations.sql 5 6package dbgen 7 8import ( 9 "context" 10 11 "github.com/google/uuid" 12 "github.com/shopspring/decimal" 13) 14 15const getCandidateEvaluation = `-- name: GetCandidateEvaluation :one 16SELECT organization_id, candidate_id, requirement_id, total_score, band, clearance_score, skills_score, certs_score, customer_score, experience_score, location_score, explanation, matched_skills, gap_summary, model_version, evaluated_by, evaluated_at, updated_at FROM candidate_evaluations 17WHERE candidate_id = $1 AND requirement_id = $2 18` 19 20type GetCandidateEvaluationParams struct { 21 CandidateID uuid.UUID `json:"candidate_id"` 22 RequirementID uuid.UUID `json:"requirement_id"` 23} 24 25func (q *Queries) GetCandidateEvaluation(ctx context.Context, arg GetCandidateEvaluationParams) (CandidateEvaluation, error) { 26 row := q.db.QueryRow(ctx, getCandidateEvaluation, arg.CandidateID, arg.RequirementID) 27 var i CandidateEvaluation 28 err := row.Scan( 29 &i.OrganizationID, 30 &i.CandidateID, 31 &i.RequirementID, 32 &i.TotalScore, 33 &i.Band, 34 &i.ClearanceScore, 35 &i.SkillsScore, 36 &i.CertsScore, 37 &i.CustomerScore, 38 &i.ExperienceScore, 39 &i.LocationScore, 40 &i.Explanation, 41 &i.MatchedSkills, 42 &i.GapSummary, 43 &i.ModelVersion, 44 &i.EvaluatedBy, 45 &i.EvaluatedAt, 46 &i.UpdatedAt, 47 ) 48 return i, err 49} 50 51const listEvaluationsForRequirement = `-- name: ListEvaluationsForRequirement :many 52SELECT organization_id, candidate_id, requirement_id, total_score, band, clearance_score, skills_score, certs_score, customer_score, experience_score, location_score, explanation, matched_skills, gap_summary, model_version, evaluated_by, evaluated_at, updated_at FROM candidate_evaluations 53WHERE requirement_id = $1 54ORDER BY total_score DESC, candidate_id 55` 56 57// The persisted screenMATCH qualifications for one requirement, best first. missionMATCH coverage and 58// the persisted ranked view read this rather than rescore the pool. 59func (q *Queries) ListEvaluationsForRequirement(ctx context.Context, requirementID uuid.UUID) ([]CandidateEvaluation, error) { 60 rows, err := q.db.Query(ctx, listEvaluationsForRequirement, requirementID) 61 if err != nil { 62 return nil, err 63 } 64 defer rows.Close() 65 items := []CandidateEvaluation{} 66 for rows.Next() { 67 var i CandidateEvaluation 68 if err := rows.Scan( 69 &i.OrganizationID, 70 &i.CandidateID, 71 &i.RequirementID, 72 &i.TotalScore, 73 &i.Band, 74 &i.ClearanceScore, 75 &i.SkillsScore, 76 &i.CertsScore, 77 &i.CustomerScore, 78 &i.ExperienceScore, 79 &i.LocationScore, 80 &i.Explanation, 81 &i.MatchedSkills, 82 &i.GapSummary, 83 &i.ModelVersion, 84 &i.EvaluatedBy, 85 &i.EvaluatedAt, 86 &i.UpdatedAt, 87 ); err != nil { 88 return nil, err 89 } 90 items = append(items, i) 91 } 92 if err := rows.Err(); err != nil { 93 return nil, err 94 } 95 return items, nil 96} 97 98const listLatestEvaluationsByCandidate = `-- name: ListLatestEvaluationsByCandidate :many 99SELECT organization_id, candidate_id, requirement_id, total_score, band, clearance_score, skills_score, certs_score, customer_score, experience_score, location_score, explanation, matched_skills, gap_summary, model_version, evaluated_by, evaluated_at, updated_at FROM candidate_evaluations 100WHERE candidate_id = $1 101ORDER BY total_score DESC, requirement_id 102` 103 104// The persisted qualifications for one candidate across requirements, best first (who can support 105// which mission today, read from the stored artifact). 106func (q *Queries) ListLatestEvaluationsByCandidate(ctx context.Context, candidateID uuid.UUID) ([]CandidateEvaluation, error) { 107 rows, err := q.db.Query(ctx, listLatestEvaluationsByCandidate, candidateID) 108 if err != nil { 109 return nil, err 110 } 111 defer rows.Close() 112 items := []CandidateEvaluation{} 113 for rows.Next() { 114 var i CandidateEvaluation 115 if err := rows.Scan( 116 &i.OrganizationID, 117 &i.CandidateID, 118 &i.RequirementID, 119 &i.TotalScore, 120 &i.Band, 121 &i.ClearanceScore, 122 &i.SkillsScore, 123 &i.CertsScore, 124 &i.CustomerScore, 125 &i.ExperienceScore, 126 &i.LocationScore, 127 &i.Explanation, 128 &i.MatchedSkills, 129 &i.GapSummary, 130 &i.ModelVersion, 131 &i.EvaluatedBy, 132 &i.EvaluatedAt, 133 &i.UpdatedAt, 134 ); err != nil { 135 return nil, err 136 } 137 items = append(items, i) 138 } 139 if err := rows.Err(); err != nil { 140 return nil, err 141 } 142 return items, nil 143} 144 145const upsertCandidateEvaluation = `-- name: UpsertCandidateEvaluation :exec 146INSERT INTO candidate_evaluations ( 147 organization_id, candidate_id, requirement_id, 148 total_score, band, 149 clearance_score, skills_score, certs_score, customer_score, experience_score, location_score, 150 explanation, matched_skills, gap_summary, model_version, evaluated_by 151) VALUES ($1,$2,$3,$4,$5,$6,$7,$8,$9,$10,$11,$12,$13,$14,$15,$16) 152ON CONFLICT (organization_id, candidate_id, requirement_id) DO UPDATE SET 153 total_score = EXCLUDED.total_score, 154 band = EXCLUDED.band, 155 clearance_score = EXCLUDED.clearance_score, 156 skills_score = EXCLUDED.skills_score, 157 certs_score = EXCLUDED.certs_score, 158 customer_score = EXCLUDED.customer_score, 159 experience_score = EXCLUDED.experience_score, 160 location_score = EXCLUDED.location_score, 161 explanation = EXCLUDED.explanation, 162 matched_skills = EXCLUDED.matched_skills, 163 gap_summary = EXCLUDED.gap_summary, 164 model_version = EXCLUDED.model_version, 165 evaluated_by = EXCLUDED.evaluated_by, 166 updated_at = now() 167` 168 169type UpsertCandidateEvaluationParams struct { 170 OrganizationID uuid.UUID `json:"organization_id"` 171 CandidateID uuid.UUID `json:"candidate_id"` 172 RequirementID uuid.UUID `json:"requirement_id"` 173 TotalScore decimal.Decimal `json:"total_score"` 174 Band string `json:"band"` 175 ClearanceScore decimal.Decimal `json:"clearance_score"` 176 SkillsScore decimal.Decimal `json:"skills_score"` 177 CertsScore decimal.Decimal `json:"certs_score"` 178 CustomerScore decimal.Decimal `json:"customer_score"` 179 ExperienceScore decimal.Decimal `json:"experience_score"` 180 LocationScore decimal.Decimal `json:"location_score"` 181 Explanation string `json:"explanation"` 182 MatchedSkills []byte `json:"matched_skills"` 183 GapSummary []byte `json:"gap_summary"` 184 ModelVersion string `json:"model_version"` 185 EvaluatedBy *uuid.UUID `json:"evaluated_by"` 186} 187 188// Upsert the latest screenMATCH qualification for one (candidate, requirement) pair. A fresh screen 189// overwrites the prior row so there is exactly one current evaluation per pair, which missionMATCH 190// reads instead of recomputing. evaluated_at is preserved as the first time the pair was screened; 191// updated_at moves to now() on every rescreen. 192func (q *Queries) UpsertCandidateEvaluation(ctx context.Context, arg UpsertCandidateEvaluationParams) error { 193 _, err := q.db.Exec(ctx, upsertCandidateEvaluation, 194 arg.OrganizationID, 195 arg.CandidateID, 196 arg.RequirementID, 197 arg.TotalScore, 198 arg.Band, 199 arg.ClearanceScore, 200 arg.SkillsScore, 201 arg.CertsScore, 202 arg.CustomerScore, 203 arg.ExperienceScore, 204 arg.LocationScore, 205 arg.Explanation, 206 arg.MatchedSkills, 207 arg.GapSummary, 208 arg.ModelVersion, 209 arg.EvaluatedBy, 210 ) 211 return err 212} 213