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

1// Code generated by sqlc. DO NOT EDIT. 2// versions: 3// sqlc v1.31.1 4// source: slates.sql 5 6package dbgen 7 8import ( 9 "context" 10 11 "github.com/google/uuid" 12 "github.com/shopspring/decimal" 13) 14 15const addSlateMember = `-- name: AddSlateMember :one 16INSERT INTO slate_members ( 17 organization_id, slate_id, candidate_id, 18 total_score, band, 19 clearance_score, skills_score, certs_score, customer_score, experience_score, location_score, 20 explanation, trace, gap_summary, rank, model_version 21) VALUES ($1,$2,$3,$4,$5,$6,$7,$8,$9,$10,$11,$12,$13,$14,$15,$16) 22RETURNING organization_id, slate_id, candidate_id, total_score, band, clearance_score, skills_score, certs_score, customer_score, experience_score, location_score, explanation, trace, gap_summary, decision, decided_by, decided_at, rank, created_at, model_version 23` 24 25type AddSlateMemberParams struct { 26 OrganizationID uuid.UUID `json:"organization_id"` 27 SlateID uuid.UUID `json:"slate_id"` 28 CandidateID uuid.UUID `json:"candidate_id"` 29 TotalScore decimal.Decimal `json:"total_score"` 30 Band string `json:"band"` 31 ClearanceScore decimal.Decimal `json:"clearance_score"` 32 SkillsScore decimal.Decimal `json:"skills_score"` 33 CertsScore decimal.Decimal `json:"certs_score"` 34 CustomerScore decimal.Decimal `json:"customer_score"` 35 ExperienceScore decimal.Decimal `json:"experience_score"` 36 LocationScore decimal.Decimal `json:"location_score"` 37 Explanation string `json:"explanation"` 38 Trace []byte `json:"trace"` 39 GapSummary []byte `json:"gap_summary"` 40 Rank *int32 `json:"rank"` 41 ModelVersion *string `json:"model_version"` 42} 43 44func (q *Queries) AddSlateMember(ctx context.Context, arg AddSlateMemberParams) (SlateMember, error) { 45 row := q.db.QueryRow(ctx, addSlateMember, 46 arg.OrganizationID, 47 arg.SlateID, 48 arg.CandidateID, 49 arg.TotalScore, 50 arg.Band, 51 arg.ClearanceScore, 52 arg.SkillsScore, 53 arg.CertsScore, 54 arg.CustomerScore, 55 arg.ExperienceScore, 56 arg.LocationScore, 57 arg.Explanation, 58 arg.Trace, 59 arg.GapSummary, 60 arg.Rank, 61 arg.ModelVersion, 62 ) 63 var i SlateMember 64 err := row.Scan( 65 &i.OrganizationID, 66 &i.SlateID, 67 &i.CandidateID, 68 &i.TotalScore, 69 &i.Band, 70 &i.ClearanceScore, 71 &i.SkillsScore, 72 &i.CertsScore, 73 &i.CustomerScore, 74 &i.ExperienceScore, 75 &i.LocationScore, 76 &i.Explanation, 77 &i.Trace, 78 &i.GapSummary, 79 &i.Decision, 80 &i.DecidedBy, 81 &i.DecidedAt, 82 &i.Rank, 83 &i.CreatedAt, 84 &i.ModelVersion, 85 ) 86 return i, err 87} 88 89const createSlate = `-- name: CreateSlate :one 90INSERT INTO slates (organization_id, requirement_id, name, status, created_by) 91VALUES ($1,$2,$3,$4,$5) 92RETURNING id, organization_id, requirement_id, name, status, created_by, created_at, updated_at 93` 94 95type CreateSlateParams struct { 96 OrganizationID uuid.UUID `json:"organization_id"` 97 RequirementID uuid.UUID `json:"requirement_id"` 98 Name string `json:"name"` 99 Status string `json:"status"` 100 CreatedBy *uuid.UUID `json:"created_by"` 101} 102 103func (q *Queries) CreateSlate(ctx context.Context, arg CreateSlateParams) (Slate, error) { 104 row := q.db.QueryRow(ctx, createSlate, 105 arg.OrganizationID, 106 arg.RequirementID, 107 arg.Name, 108 arg.Status, 109 arg.CreatedBy, 110 ) 111 var i Slate 112 err := row.Scan( 113 &i.ID, 114 &i.OrganizationID, 115 &i.RequirementID, 116 &i.Name, 117 &i.Status, 118 &i.CreatedBy, 119 &i.CreatedAt, 120 &i.UpdatedAt, 121 ) 122 return i, err 123} 124 125const getSlate = `-- name: GetSlate :one 126SELECT id, organization_id, requirement_id, name, status, created_by, created_at, updated_at FROM slates WHERE id = $1 127` 128 129func (q *Queries) GetSlate(ctx context.Context, id uuid.UUID) (Slate, error) { 130 row := q.db.QueryRow(ctx, getSlate, id) 131 var i Slate 132 err := row.Scan( 133 &i.ID, 134 &i.OrganizationID, 135 &i.RequirementID, 136 &i.Name, 137 &i.Status, 138 &i.CreatedBy, 139 &i.CreatedAt, 140 &i.UpdatedAt, 141 ) 142 return i, err 143} 144 145const getSlateMember = `-- name: GetSlateMember :one 146 147SELECT organization_id, slate_id, candidate_id, total_score, band, clearance_score, skills_score, certs_score, customer_score, experience_score, location_score, explanation, trace, gap_summary, decision, decided_by, decided_at, rank, created_at, model_version FROM slate_members WHERE slate_id = $1 AND candidate_id = $2 148` 149 150type GetSlateMemberParams struct { 151 SlateID uuid.UUID `json:"slate_id"` 152 CandidateID uuid.UUID `json:"candidate_id"` 153} 154 155// PK tiebreaker => total order [review SQLC-5] 156// The frozen decision record for one member: the full per component trace, rationale, and gap summary 157// for the audit and candidate facing explanation. 158func (q *Queries) GetSlateMember(ctx context.Context, arg GetSlateMemberParams) (SlateMember, error) { 159 row := q.db.QueryRow(ctx, getSlateMember, arg.SlateID, arg.CandidateID) 160 var i SlateMember 161 err := row.Scan( 162 &i.OrganizationID, 163 &i.SlateID, 164 &i.CandidateID, 165 &i.TotalScore, 166 &i.Band, 167 &i.ClearanceScore, 168 &i.SkillsScore, 169 &i.CertsScore, 170 &i.CustomerScore, 171 &i.ExperienceScore, 172 &i.LocationScore, 173 &i.Explanation, 174 &i.Trace, 175 &i.GapSummary, 176 &i.Decision, 177 &i.DecidedBy, 178 &i.DecidedAt, 179 &i.Rank, 180 &i.CreatedAt, 181 &i.ModelVersion, 182 ) 183 return i, err 184} 185 186const listSlateMembers = `-- name: ListSlateMembers :many 187SELECT organization_id, slate_id, candidate_id, total_score, band, clearance_score, skills_score, certs_score, customer_score, experience_score, location_score, explanation, trace, gap_summary, decision, decided_by, decided_at, rank, created_at, model_version FROM slate_members 188WHERE slate_id = $1 189ORDER BY rank NULLS LAST, total_score DESC, candidate_id 190` 191 192func (q *Queries) ListSlateMembers(ctx context.Context, slateID uuid.UUID) ([]SlateMember, error) { 193 rows, err := q.db.Query(ctx, listSlateMembers, slateID) 194 if err != nil { 195 return nil, err 196 } 197 defer rows.Close() 198 items := []SlateMember{} 199 for rows.Next() { 200 var i SlateMember 201 if err := rows.Scan( 202 &i.OrganizationID, 203 &i.SlateID, 204 &i.CandidateID, 205 &i.TotalScore, 206 &i.Band, 207 &i.ClearanceScore, 208 &i.SkillsScore, 209 &i.CertsScore, 210 &i.CustomerScore, 211 &i.ExperienceScore, 212 &i.LocationScore, 213 &i.Explanation, 214 &i.Trace, 215 &i.GapSummary, 216 &i.Decision, 217 &i.DecidedBy, 218 &i.DecidedAt, 219 &i.Rank, 220 &i.CreatedAt, 221 &i.ModelVersion, 222 ); err != nil { 223 return nil, err 224 } 225 items = append(items, i) 226 } 227 if err := rows.Err(); err != nil { 228 return nil, err 229 } 230 return items, nil 231} 232 233const listSlatesForRequirement = `-- name: ListSlatesForRequirement :many 234SELECT id, organization_id, requirement_id, name, status, created_by, created_at, updated_at FROM slates WHERE requirement_id = $1 ORDER BY created_at DESC 235` 236 237func (q *Queries) ListSlatesForRequirement(ctx context.Context, requirementID uuid.UUID) ([]Slate, error) { 238 rows, err := q.db.Query(ctx, listSlatesForRequirement, requirementID) 239 if err != nil { 240 return nil, err 241 } 242 defer rows.Close() 243 items := []Slate{} 244 for rows.Next() { 245 var i Slate 246 if err := rows.Scan( 247 &i.ID, 248 &i.OrganizationID, 249 &i.RequirementID, 250 &i.Name, 251 &i.Status, 252 &i.CreatedBy, 253 &i.CreatedAt, 254 &i.UpdatedAt, 255 ); err != nil { 256 return nil, err 257 } 258 items = append(items, i) 259 } 260 if err := rows.Err(); err != nil { 261 return nil, err 262 } 263 return items, nil 264} 265 266const setSlateMemberDecision = `-- name: SetSlateMemberDecision :one 267UPDATE slate_members 268SET decision = $3, decided_by = $4, decided_at = now() 269WHERE slate_id = $1 AND candidate_id = $2 270RETURNING organization_id, slate_id, candidate_id, total_score, band, clearance_score, skills_score, certs_score, customer_score, experience_score, location_score, explanation, trace, gap_summary, decision, decided_by, decided_at, rank, created_at, model_version 271` 272 273type SetSlateMemberDecisionParams struct { 274 SlateID uuid.UUID `json:"slate_id"` 275 CandidateID uuid.UUID `json:"candidate_id"` 276 Decision string `json:"decision"` 277 DecidedBy *uuid.UUID `json:"decided_by"` 278} 279 280// Human-in-the-loop: a person approves/rejects each member. Never auto-decided. 281func (q *Queries) SetSlateMemberDecision(ctx context.Context, arg SetSlateMemberDecisionParams) (SlateMember, error) { 282 row := q.db.QueryRow(ctx, setSlateMemberDecision, 283 arg.SlateID, 284 arg.CandidateID, 285 arg.Decision, 286 arg.DecidedBy, 287 ) 288 var i SlateMember 289 err := row.Scan( 290 &i.OrganizationID, 291 &i.SlateID, 292 &i.CandidateID, 293 &i.TotalScore, 294 &i.Band, 295 &i.ClearanceScore, 296 &i.SkillsScore, 297 &i.CertsScore, 298 &i.CustomerScore, 299 &i.ExperienceScore, 300 &i.LocationScore, 301 &i.Explanation, 302 &i.Trace, 303 &i.GapSummary, 304 &i.Decision, 305 &i.DecidedBy, 306 &i.DecidedAt, 307 &i.Rank, 308 &i.CreatedAt, 309 &i.ModelVersion, 310 ) 311 return i, err 312} 313 314const updateSlateStatus = `-- name: UpdateSlateStatus :one 315UPDATE slates SET status = $2, updated_at = now() WHERE id = $1 RETURNING id, organization_id, requirement_id, name, status, created_by, created_at, updated_at 316` 317 318type UpdateSlateStatusParams struct { 319 ID uuid.UUID `json:"id"` 320 Status string `json:"status"` 321} 322 323func (q *Queries) UpdateSlateStatus(ctx context.Context, arg UpdateSlateStatusParams) (Slate, error) { 324 row := q.db.QueryRow(ctx, updateSlateStatus, arg.ID, arg.Status) 325 var i Slate 326 err := row.Scan( 327 &i.ID, 328 &i.OrganizationID, 329 &i.RequirementID, 330 &i.Name, 331 &i.Status, 332 &i.CreatedBy, 333 &i.CreatedAt, 334 &i.UpdatedAt, 335 ) 336 return i, err 337} 338