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 "time" 11 12 "github.com/google/uuid" 13 "github.com/shopspring/decimal" 14) 15 16const addSlateMember = `-- name: AddSlateMember :one 17INSERT INTO slate_members ( 18 organization_id, slate_id, candidate_id, 19 total_score, band, 20 clearance_score, skills_score, certs_score, customer_score, experience_score, location_score, 21 explanation, trace, gap_summary, rank, model_version 22) VALUES ($1,$2,$3,$4,$5,$6,$7,$8,$9,$10,$11,$12,$13,$14,$15,$16) 23RETURNING 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, decision_note, status, approved_by_user_id, approved_at, withdrawn_by_user_id, withdrawn_at, withdrawal_reason 24` 25 26type AddSlateMemberParams struct { 27 OrganizationID uuid.UUID `json:"organization_id"` 28 SlateID uuid.UUID `json:"slate_id"` 29 CandidateID uuid.UUID `json:"candidate_id"` 30 TotalScore decimal.Decimal `json:"total_score"` 31 Band string `json:"band"` 32 ClearanceScore decimal.Decimal `json:"clearance_score"` 33 SkillsScore decimal.Decimal `json:"skills_score"` 34 CertsScore decimal.Decimal `json:"certs_score"` 35 CustomerScore decimal.Decimal `json:"customer_score"` 36 ExperienceScore decimal.Decimal `json:"experience_score"` 37 LocationScore decimal.Decimal `json:"location_score"` 38 Explanation string `json:"explanation"` 39 Trace []byte `json:"trace"` 40 GapSummary []byte `json:"gap_summary"` 41 Rank *int32 `json:"rank"` 42 ModelVersion *string `json:"model_version"` 43} 44 45func (q *Queries) AddSlateMember(ctx context.Context, arg AddSlateMemberParams) (SlateMember, error) { 46 row := q.db.QueryRow(ctx, addSlateMember, 47 arg.OrganizationID, 48 arg.SlateID, 49 arg.CandidateID, 50 arg.TotalScore, 51 arg.Band, 52 arg.ClearanceScore, 53 arg.SkillsScore, 54 arg.CertsScore, 55 arg.CustomerScore, 56 arg.ExperienceScore, 57 arg.LocationScore, 58 arg.Explanation, 59 arg.Trace, 60 arg.GapSummary, 61 arg.Rank, 62 arg.ModelVersion, 63 ) 64 var i SlateMember 65 err := row.Scan( 66 &i.OrganizationID, 67 &i.SlateID, 68 &i.CandidateID, 69 &i.TotalScore, 70 &i.Band, 71 &i.ClearanceScore, 72 &i.SkillsScore, 73 &i.CertsScore, 74 &i.CustomerScore, 75 &i.ExperienceScore, 76 &i.LocationScore, 77 &i.Explanation, 78 &i.Trace, 79 &i.GapSummary, 80 &i.Decision, 81 &i.DecidedBy, 82 &i.DecidedAt, 83 &i.Rank, 84 &i.CreatedAt, 85 &i.ModelVersion, 86 &i.DecisionNote, 87 &i.Status, 88 &i.ApprovedByUserID, 89 &i.ApprovedAt, 90 &i.WithdrawnByUserID, 91 &i.WithdrawnAt, 92 &i.WithdrawalReason, 93 ) 94 return i, err 95} 96 97const createSlate = `-- name: CreateSlate :one 98INSERT INTO slates (organization_id, requirement_id, name, status, created_by) 99VALUES ($1,$2,$3,$4,$5) 100RETURNING id, organization_id, requirement_id, name, status, created_by, created_at, updated_at 101` 102 103type CreateSlateParams struct { 104 OrganizationID uuid.UUID `json:"organization_id"` 105 RequirementID uuid.UUID `json:"requirement_id"` 106 Name string `json:"name"` 107 Status string `json:"status"` 108 CreatedBy *uuid.UUID `json:"created_by"` 109} 110 111func (q *Queries) CreateSlate(ctx context.Context, arg CreateSlateParams) (Slate, error) { 112 row := q.db.QueryRow(ctx, createSlate, 113 arg.OrganizationID, 114 arg.RequirementID, 115 arg.Name, 116 arg.Status, 117 arg.CreatedBy, 118 ) 119 var i Slate 120 err := row.Scan( 121 &i.ID, 122 &i.OrganizationID, 123 &i.RequirementID, 124 &i.Name, 125 &i.Status, 126 &i.CreatedBy, 127 &i.CreatedAt, 128 &i.UpdatedAt, 129 ) 130 return i, err 131} 132 133const getSlate = `-- name: GetSlate :one 134SELECT id, organization_id, requirement_id, name, status, created_by, created_at, updated_at FROM slates WHERE id = $1 135` 136 137func (q *Queries) GetSlate(ctx context.Context, id uuid.UUID) (Slate, error) { 138 row := q.db.QueryRow(ctx, getSlate, id) 139 var i Slate 140 err := row.Scan( 141 &i.ID, 142 &i.OrganizationID, 143 &i.RequirementID, 144 &i.Name, 145 &i.Status, 146 &i.CreatedBy, 147 &i.CreatedAt, 148 &i.UpdatedAt, 149 ) 150 return i, err 151} 152 153const getSlateMember = `-- name: GetSlateMember :one 154 155SELECT 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, decision_note, status, approved_by_user_id, approved_at, withdrawn_by_user_id, withdrawn_at, withdrawal_reason FROM slate_members WHERE slate_id = $1 AND candidate_id = $2 156` 157 158type GetSlateMemberParams struct { 159 SlateID uuid.UUID `json:"slate_id"` 160 CandidateID uuid.UUID `json:"candidate_id"` 161} 162 163// PK tiebreaker => total order [review SQLC-5] 164// The frozen decision record for one member: the full per component trace, rationale, and gap summary 165// for the audit and candidate facing explanation. 166func (q *Queries) GetSlateMember(ctx context.Context, arg GetSlateMemberParams) (SlateMember, error) { 167 row := q.db.QueryRow(ctx, getSlateMember, arg.SlateID, arg.CandidateID) 168 var i SlateMember 169 err := row.Scan( 170 &i.OrganizationID, 171 &i.SlateID, 172 &i.CandidateID, 173 &i.TotalScore, 174 &i.Band, 175 &i.ClearanceScore, 176 &i.SkillsScore, 177 &i.CertsScore, 178 &i.CustomerScore, 179 &i.ExperienceScore, 180 &i.LocationScore, 181 &i.Explanation, 182 &i.Trace, 183 &i.GapSummary, 184 &i.Decision, 185 &i.DecidedBy, 186 &i.DecidedAt, 187 &i.Rank, 188 &i.CreatedAt, 189 &i.ModelVersion, 190 &i.DecisionNote, 191 &i.Status, 192 &i.ApprovedByUserID, 193 &i.ApprovedAt, 194 &i.WithdrawnByUserID, 195 &i.WithdrawnAt, 196 &i.WithdrawalReason, 197 ) 198 return i, err 199} 200 201const listSlateMembers = `-- name: ListSlateMembers :many 202SELECT 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, decision_note, status, approved_by_user_id, approved_at, withdrawn_by_user_id, withdrawn_at, withdrawal_reason FROM slate_members 203WHERE slate_id = $1 204ORDER BY rank NULLS LAST, total_score DESC, candidate_id 205` 206 207func (q *Queries) ListSlateMembers(ctx context.Context, slateID uuid.UUID) ([]SlateMember, error) { 208 rows, err := q.db.Query(ctx, listSlateMembers, slateID) 209 if err != nil { 210 return nil, err 211 } 212 defer rows.Close() 213 items := []SlateMember{} 214 for rows.Next() { 215 var i SlateMember 216 if err := rows.Scan( 217 &i.OrganizationID, 218 &i.SlateID, 219 &i.CandidateID, 220 &i.TotalScore, 221 &i.Band, 222 &i.ClearanceScore, 223 &i.SkillsScore, 224 &i.CertsScore, 225 &i.CustomerScore, 226 &i.ExperienceScore, 227 &i.LocationScore, 228 &i.Explanation, 229 &i.Trace, 230 &i.GapSummary, 231 &i.Decision, 232 &i.DecidedBy, 233 &i.DecidedAt, 234 &i.Rank, 235 &i.CreatedAt, 236 &i.ModelVersion, 237 &i.DecisionNote, 238 &i.Status, 239 &i.ApprovedByUserID, 240 &i.ApprovedAt, 241 &i.WithdrawnByUserID, 242 &i.WithdrawnAt, 243 &i.WithdrawalReason, 244 ); err != nil { 245 return nil, err 246 } 247 items = append(items, i) 248 } 249 if err := rows.Err(); err != nil { 250 return nil, err 251 } 252 return items, nil 253} 254 255const listSlateMembersWithNames = `-- name: ListSlateMembersWithNames :many 256SELECT sm.organization_id, sm.slate_id, sm.candidate_id, sm.total_score, sm.band, sm.clearance_score, sm.skills_score, sm.certs_score, sm.customer_score, sm.experience_score, sm.location_score, sm.explanation, sm.trace, sm.gap_summary, sm.decision, sm.decided_by, sm.decided_at, sm.rank, sm.created_at, sm.model_version, sm.decision_note, sm.status, sm.approved_by_user_id, sm.approved_at, sm.withdrawn_by_user_id, sm.withdrawn_at, sm.withdrawal_reason, c.full_name 257FROM slate_members sm 258JOIN candidates c ON c.organization_id = sm.organization_id AND c.id = sm.candidate_id 259WHERE sm.slate_id = $1 260ORDER BY sm.rank NULLS LAST, sm.total_score DESC, sm.candidate_id 261` 262 263type ListSlateMembersWithNamesRow struct { 264 OrganizationID uuid.UUID `json:"organization_id"` 265 SlateID uuid.UUID `json:"slate_id"` 266 CandidateID uuid.UUID `json:"candidate_id"` 267 TotalScore decimal.Decimal `json:"total_score"` 268 Band string `json:"band"` 269 ClearanceScore decimal.Decimal `json:"clearance_score"` 270 SkillsScore decimal.Decimal `json:"skills_score"` 271 CertsScore decimal.Decimal `json:"certs_score"` 272 CustomerScore decimal.Decimal `json:"customer_score"` 273 ExperienceScore decimal.Decimal `json:"experience_score"` 274 LocationScore decimal.Decimal `json:"location_score"` 275 Explanation string `json:"explanation"` 276 Trace []byte `json:"trace"` 277 GapSummary []byte `json:"gap_summary"` 278 Decision string `json:"decision"` 279 DecidedBy *uuid.UUID `json:"decided_by"` 280 DecidedAt *time.Time `json:"decided_at"` 281 Rank *int32 `json:"rank"` 282 CreatedAt time.Time `json:"created_at"` 283 ModelVersion *string `json:"model_version"` 284 DecisionNote *string `json:"decision_note"` 285 Status string `json:"status"` 286 ApprovedByUserID *uuid.UUID `json:"approved_by_user_id"` 287 ApprovedAt *time.Time `json:"approved_at"` 288 WithdrawnByUserID *uuid.UUID `json:"withdrawn_by_user_id"` 289 WithdrawnAt *time.Time `json:"withdrawn_at"` 290 WithdrawalReason string `json:"withdrawal_reason"` 291 FullName string `json:"full_name"` 292} 293 294// The slate roster joined to the candidate name for the slateMATCH detail and the branded export. Both 295// tables are RLS scoped to the caller's org, so the join cannot cross tenants. 296func (q *Queries) ListSlateMembersWithNames(ctx context.Context, slateID uuid.UUID) ([]ListSlateMembersWithNamesRow, error) { 297 rows, err := q.db.Query(ctx, listSlateMembersWithNames, slateID) 298 if err != nil { 299 return nil, err 300 } 301 defer rows.Close() 302 items := []ListSlateMembersWithNamesRow{} 303 for rows.Next() { 304 var i ListSlateMembersWithNamesRow 305 if err := rows.Scan( 306 &i.OrganizationID, 307 &i.SlateID, 308 &i.CandidateID, 309 &i.TotalScore, 310 &i.Band, 311 &i.ClearanceScore, 312 &i.SkillsScore, 313 &i.CertsScore, 314 &i.CustomerScore, 315 &i.ExperienceScore, 316 &i.LocationScore, 317 &i.Explanation, 318 &i.Trace, 319 &i.GapSummary, 320 &i.Decision, 321 &i.DecidedBy, 322 &i.DecidedAt, 323 &i.Rank, 324 &i.CreatedAt, 325 &i.ModelVersion, 326 &i.DecisionNote, 327 &i.Status, 328 &i.ApprovedByUserID, 329 &i.ApprovedAt, 330 &i.WithdrawnByUserID, 331 &i.WithdrawnAt, 332 &i.WithdrawalReason, 333 &i.FullName, 334 ); err != nil { 335 return nil, err 336 } 337 items = append(items, i) 338 } 339 if err := rows.Err(); err != nil { 340 return nil, err 341 } 342 return items, nil 343} 344 345const listSlatesForRequirement = `-- name: ListSlatesForRequirement :many 346SELECT id, organization_id, requirement_id, name, status, created_by, created_at, updated_at FROM slates WHERE requirement_id = $1 ORDER BY created_at DESC, id 347` 348 349func (q *Queries) ListSlatesForRequirement(ctx context.Context, requirementID uuid.UUID) ([]Slate, error) { 350 rows, err := q.db.Query(ctx, listSlatesForRequirement, requirementID) 351 if err != nil { 352 return nil, err 353 } 354 defer rows.Close() 355 items := []Slate{} 356 for rows.Next() { 357 var i Slate 358 if err := rows.Scan( 359 &i.ID, 360 &i.OrganizationID, 361 &i.RequirementID, 362 &i.Name, 363 &i.Status, 364 &i.CreatedBy, 365 &i.CreatedAt, 366 &i.UpdatedAt, 367 ); err != nil { 368 return nil, err 369 } 370 items = append(items, i) 371 } 372 if err := rows.Err(); err != nil { 373 return nil, err 374 } 375 return items, nil 376} 377 378const setSlateMemberDecision = `-- name: SetSlateMemberDecision :one 379UPDATE slate_members 380SET decision = $3, decided_by = $4, decision_note = $5, decided_at = now() 381WHERE slate_id = $1 AND candidate_id = $2 382RETURNING 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, decision_note, status, approved_by_user_id, approved_at, withdrawn_by_user_id, withdrawn_at, withdrawal_reason 383` 384 385type SetSlateMemberDecisionParams struct { 386 SlateID uuid.UUID `json:"slate_id"` 387 CandidateID uuid.UUID `json:"candidate_id"` 388 Decision string `json:"decision"` 389 DecidedBy *uuid.UUID `json:"decided_by"` 390 DecisionNote *string `json:"decision_note"` 391} 392 393// Human-in-the-loop: a person approves/rejects each member, optionally with a note. Never auto-decided. 394func (q *Queries) SetSlateMemberDecision(ctx context.Context, arg SetSlateMemberDecisionParams) (SlateMember, error) { 395 row := q.db.QueryRow(ctx, setSlateMemberDecision, 396 arg.SlateID, 397 arg.CandidateID, 398 arg.Decision, 399 arg.DecidedBy, 400 arg.DecisionNote, 401 ) 402 var i SlateMember 403 err := row.Scan( 404 &i.OrganizationID, 405 &i.SlateID, 406 &i.CandidateID, 407 &i.TotalScore, 408 &i.Band, 409 &i.ClearanceScore, 410 &i.SkillsScore, 411 &i.CertsScore, 412 &i.CustomerScore, 413 &i.ExperienceScore, 414 &i.LocationScore, 415 &i.Explanation, 416 &i.Trace, 417 &i.GapSummary, 418 &i.Decision, 419 &i.DecidedBy, 420 &i.DecidedAt, 421 &i.Rank, 422 &i.CreatedAt, 423 &i.ModelVersion, 424 &i.DecisionNote, 425 &i.Status, 426 &i.ApprovedByUserID, 427 &i.ApprovedAt, 428 &i.WithdrawnByUserID, 429 &i.WithdrawnAt, 430 &i.WithdrawalReason, 431 ) 432 return i, err 433} 434 435const updateSlateStatus = `-- name: UpdateSlateStatus :one 436UPDATE slates SET status = $2, updated_at = now() WHERE id = $1 RETURNING id, organization_id, requirement_id, name, status, created_by, created_at, updated_at 437` 438 439type UpdateSlateStatusParams struct { 440 ID uuid.UUID `json:"id"` 441 Status string `json:"status"` 442} 443 444func (q *Queries) UpdateSlateStatus(ctx context.Context, arg UpdateSlateStatusParams) (Slate, error) { 445 row := q.db.QueryRow(ctx, updateSlateStatus, arg.ID, arg.Status) 446 var i Slate 447 err := row.Scan( 448 &i.ID, 449 &i.OrganizationID, 450 &i.RequirementID, 451 &i.Name, 452 &i.Status, 453 &i.CreatedBy, 454 &i.CreatedAt, 455 &i.UpdatedAt, 456 ) 457 return i, err 458} 459