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

1// Code generated by sqlc. DO NOT EDIT. 2// versions: 3// sqlc v1.31.1 4// source: requirements.sql 5 6package dbgen 7 8import ( 9 "context" 10 11 "github.com/google/uuid" 12) 13 14const addRequiredCertification = `-- name: AddRequiredCertification :exec 15INSERT INTO required_certifications (organization_id, requirement_id, name) 16VALUES ($1,$2,$3) 17ON CONFLICT (requirement_id, name) DO NOTHING 18` 19 20type AddRequiredCertificationParams struct { 21 OrganizationID uuid.UUID `json:"organization_id"` 22 RequirementID uuid.UUID `json:"requirement_id"` 23 Name string `json:"name"` 24} 25 26func (q *Queries) AddRequiredCertification(ctx context.Context, arg AddRequiredCertificationParams) error { 27 _, err := q.db.Exec(ctx, addRequiredCertification, arg.OrganizationID, arg.RequirementID, arg.Name) 28 return err 29} 30 31const addRequiredSkill = `-- name: AddRequiredSkill :exec 32INSERT INTO required_skills (organization_id, requirement_id, skill_id, mandatory) 33VALUES ($1,$2,$3,$4) 34ON CONFLICT (requirement_id, skill_id) DO UPDATE SET mandatory = EXCLUDED.mandatory 35` 36 37type AddRequiredSkillParams struct { 38 OrganizationID uuid.UUID `json:"organization_id"` 39 RequirementID uuid.UUID `json:"requirement_id"` 40 SkillID uuid.UUID `json:"skill_id"` 41 Mandatory bool `json:"mandatory"` 42} 43 44func (q *Queries) AddRequiredSkill(ctx context.Context, arg AddRequiredSkillParams) error { 45 _, err := q.db.Exec(ctx, addRequiredSkill, 46 arg.OrganizationID, 47 arg.RequirementID, 48 arg.SkillID, 49 arg.Mandatory, 50 ) 51 return err 52} 53 54const createRequirement = `-- name: CreateRequirement :one 55INSERT INTO requirements ( 56 organization_id, opportunity_id, title, customer_agency, 57 required_level, required_poly, required_years, 58 work_location, remote_allowed, key_personnel 59) VALUES ($1,$2,$3,$4,$5,$6,$7,$8,$9,$10) 60RETURNING id, organization_id, opportunity_id, title, customer_agency, required_level, required_poly, required_years, work_location, remote_allowed, key_personnel, created_at, updated_at, deleted_at, labor_category, quantity 61` 62 63type CreateRequirementParams struct { 64 OrganizationID uuid.UUID `json:"organization_id"` 65 OpportunityID *uuid.UUID `json:"opportunity_id"` 66 Title string `json:"title"` 67 CustomerAgency *string `json:"customer_agency"` 68 RequiredLevel string `json:"required_level"` 69 RequiredPoly string `json:"required_poly"` 70 RequiredYears int32 `json:"required_years"` 71 WorkLocation *string `json:"work_location"` 72 RemoteAllowed bool `json:"remote_allowed"` 73 KeyPersonnel bool `json:"key_personnel"` 74} 75 76func (q *Queries) CreateRequirement(ctx context.Context, arg CreateRequirementParams) (Requirement, error) { 77 row := q.db.QueryRow(ctx, createRequirement, 78 arg.OrganizationID, 79 arg.OpportunityID, 80 arg.Title, 81 arg.CustomerAgency, 82 arg.RequiredLevel, 83 arg.RequiredPoly, 84 arg.RequiredYears, 85 arg.WorkLocation, 86 arg.RemoteAllowed, 87 arg.KeyPersonnel, 88 ) 89 var i Requirement 90 err := row.Scan( 91 &i.ID, 92 &i.OrganizationID, 93 &i.OpportunityID, 94 &i.Title, 95 &i.CustomerAgency, 96 &i.RequiredLevel, 97 &i.RequiredPoly, 98 &i.RequiredYears, 99 &i.WorkLocation, 100 &i.RemoteAllowed, 101 &i.KeyPersonnel, 102 &i.CreatedAt, 103 &i.UpdatedAt, 104 &i.DeletedAt, 105 &i.LaborCategory, 106 &i.Quantity, 107 ) 108 return i, err 109} 110 111const getRequirement = `-- name: GetRequirement :one 112SELECT id, organization_id, opportunity_id, title, customer_agency, required_level, required_poly, required_years, work_location, remote_allowed, key_personnel, created_at, updated_at, deleted_at, labor_category, quantity FROM requirements WHERE id = $1 AND deleted_at IS NULL 113` 114 115func (q *Queries) GetRequirement(ctx context.Context, id uuid.UUID) (Requirement, error) { 116 row := q.db.QueryRow(ctx, getRequirement, id) 117 var i Requirement 118 err := row.Scan( 119 &i.ID, 120 &i.OrganizationID, 121 &i.OpportunityID, 122 &i.Title, 123 &i.CustomerAgency, 124 &i.RequiredLevel, 125 &i.RequiredPoly, 126 &i.RequiredYears, 127 &i.WorkLocation, 128 &i.RemoteAllowed, 129 &i.KeyPersonnel, 130 &i.CreatedAt, 131 &i.UpdatedAt, 132 &i.DeletedAt, 133 &i.LaborCategory, 134 &i.Quantity, 135 ) 136 return i, err 137} 138 139const listRequiredCertifications = `-- name: ListRequiredCertifications :many 140SELECT name FROM required_certifications WHERE requirement_id = $1 ORDER BY name 141` 142 143func (q *Queries) ListRequiredCertifications(ctx context.Context, requirementID uuid.UUID) ([]string, error) { 144 rows, err := q.db.Query(ctx, listRequiredCertifications, requirementID) 145 if err != nil { 146 return nil, err 147 } 148 defer rows.Close() 149 items := []string{} 150 for rows.Next() { 151 var name string 152 if err := rows.Scan(&name); err != nil { 153 return nil, err 154 } 155 items = append(items, name) 156 } 157 if err := rows.Err(); err != nil { 158 return nil, err 159 } 160 return items, nil 161} 162 163const listRequiredSkills = `-- name: ListRequiredSkills :many 164SELECT s.id, s.name, rs.mandatory 165FROM required_skills rs 166JOIN skills s ON s.id = rs.skill_id 167WHERE rs.requirement_id = $1 168ORDER BY s.name 169` 170 171type ListRequiredSkillsRow struct { 172 ID uuid.UUID `json:"id"` 173 Name string `json:"name"` 174 Mandatory bool `json:"mandatory"` 175} 176 177func (q *Queries) ListRequiredSkills(ctx context.Context, requirementID uuid.UUID) ([]ListRequiredSkillsRow, error) { 178 rows, err := q.db.Query(ctx, listRequiredSkills, requirementID) 179 if err != nil { 180 return nil, err 181 } 182 defer rows.Close() 183 items := []ListRequiredSkillsRow{} 184 for rows.Next() { 185 var i ListRequiredSkillsRow 186 if err := rows.Scan(&i.ID, &i.Name, &i.Mandatory); err != nil { 187 return nil, err 188 } 189 items = append(items, i) 190 } 191 if err := rows.Err(); err != nil { 192 return nil, err 193 } 194 return items, nil 195} 196 197const listRequirements = `-- name: ListRequirements :many 198SELECT id, organization_id, opportunity_id, title, customer_agency, required_level, required_poly, required_years, work_location, remote_allowed, key_personnel, created_at, updated_at, deleted_at, labor_category, quantity FROM requirements 199WHERE deleted_at IS NULL 200ORDER BY created_at DESC 201LIMIT $1 OFFSET $2 202` 203 204type ListRequirementsParams struct { 205 Limit int32 `json:"limit"` 206 Offset int32 `json:"offset"` 207} 208 209func (q *Queries) ListRequirements(ctx context.Context, arg ListRequirementsParams) ([]Requirement, error) { 210 rows, err := q.db.Query(ctx, listRequirements, arg.Limit, arg.Offset) 211 if err != nil { 212 return nil, err 213 } 214 defer rows.Close() 215 items := []Requirement{} 216 for rows.Next() { 217 var i Requirement 218 if err := rows.Scan( 219 &i.ID, 220 &i.OrganizationID, 221 &i.OpportunityID, 222 &i.Title, 223 &i.CustomerAgency, 224 &i.RequiredLevel, 225 &i.RequiredPoly, 226 &i.RequiredYears, 227 &i.WorkLocation, 228 &i.RemoteAllowed, 229 &i.KeyPersonnel, 230 &i.CreatedAt, 231 &i.UpdatedAt, 232 &i.DeletedAt, 233 &i.LaborCategory, 234 &i.Quantity, 235 ); err != nil { 236 return nil, err 237 } 238 items = append(items, i) 239 } 240 if err := rows.Err(); err != nil { 241 return nil, err 242 } 243 return items, nil 244} 245