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