< Summary

Information
Class: RoleRadar.Application.Tracking.Import.SourceFieldCatalog
Assembly: RoleRadar.Application
File(s): /home/runner/work/roleradar/roleradar/src/RoleRadar.Application/Tracking/Import/SourceFieldCatalog.cs
Line coverage
100%
Covered lines: 78
Uncovered lines: 0
Coverable lines: 78
Total lines: 91
Line coverage: 100%
Branch coverage
100%
Covered branches: 6
Total branches: 6
Branch coverage: 100%
Method coverage

Feature is only available for sponsors

Upgrade to PRO version

Metrics

MethodBranch coverage Crap Score Cyclomatic complexity Line coverage
.cctor()100%11100%
GetHandling(...)100%66100%

File(s)

/home/runner/work/roleradar/roleradar/src/RoleRadar.Application/Tracking/Import/SourceFieldCatalog.cs

#LineLine coverage
 1namespace RoleRadar.Application.Tracking.Import;
 2
 3public sealed record SourceFieldDefinition(string File, string Field, string Handling);
 4
 5public static class SourceFieldCatalog
 6{
 87    public static readonly IReadOnlyList<SourceFieldDefinition> AllFields = new SourceFieldDefinition[]
 88    {
 89        // appendix-rows.csv
 810        new("appendix-rows.csv", "source", "stored in Posting.SourceKind"),
 811        new("appendix-rows.csv", "proposed_disposition", "stored in Posting.Disposition"),
 812        new("appendix-rows.csv", "company", "stored in Company.Name"),
 813        new("appendix-rows.csv", "title", "stored in Posting.Title"),
 814        new("appendix-rows.csv", "req", "stored in Posting.RequisitionId"),
 815        new("appendix-rows.csv", "comp_detected", "stored in Posting.Compensation"),
 816        new("appendix-rows.csv", "comp_is_estimate", "merged into Posting.Compensation"),
 817        new("appendix-rows.csv", "remote_mentioned", "dropped by design"),
 818        new("appendix-rows.csv", "details_raw", "merged into Posting.DispositionReason"),
 819        new("appendix-rows.csv", "added_md", "stored in Posting.CreatedAtUtc"),
 820        new("appendix-rows.csv", "reason_primary", "stored in Posting.DispositionCriterionId"),
 821        new("appendix-rows.csv", "reason_all", "merged into Posting.DispositionReason"),
 822        new("appendix-rows.csv", "proposed_resurface", "stored in Posting.ResurfacePolicy"),
 823        new("appendix-rows.csv", "company_also_in_db", "dropped by design"),
 824        new("appendix-rows.csv", "review_flags", "dropped by design"),
 825        new("appendix-rows.csv", "reason_text", "stored in Posting.DispositionReason"),
 826        new("appendix-rows.csv", "decision", "dropped by design"),
 827        new("appendix-rows.csv", "corrected_notes", "dropped by design"),
 828
 829        // applications.csv
 830        new("applications.csv", "kind", "stored in application routing"),
 831        new("applications.csv", "company", "stored in Company.Name / Posting.CompanyId"),
 832        new("applications.csv", "title", "stored in Posting.Title / Note.Title"),
 833        new("applications.csv", "req", "stored in Posting.RequisitionId"),
 834        new("applications.csv", "applied_on", "stored in Application.SubmittedDate"),
 835        new("applications.csv", "rejected", "stored in Application.Outcome / Posting.Disposition"),
 836        new("applications.csv", "rejected_date_md", "stored in ApplicationEvent.EventDate"),
 837        new("applications.csv", "desired_salary", "stored in Application.DesiredSalary"),
 838        new("applications.csv", "referral", "merged into ApplicationEvent.Notes"),
 839        new("applications.csv", "fit", "merged into ApplicationEvent.Notes / Posting.Score"),
 840        new("applications.csv", "resume_variant", "stored in Application.ResumeVariant"),
 841        new("applications.csv", "people_detected", "dropped by design"),
 842        new("applications.csv", "review_flags", "dropped by design"),
 843        new("applications.csv", "raw", "merged into ApplicationEvent.Notes / Note.Body"),
 844        new("applications.csv", "decision", "dropped by design"),
 845        new("applications.csv", "corrected_notes", "dropped by design"),
 846
 847        // watchlist-companies.csv
 848        new("watchlist-companies.csv", "company", "stored in Company.Name"),
 849        new("watchlist-companies.csv", "proposed_status", "stored in Company.Status"),
 850        new("watchlist-companies.csv", "text", "stored in Company.Description"),
 851        new("watchlist-companies.csv", "decision", "dropped by design"),
 852        new("watchlist-companies.csv", "corrected_notes", "dropped by design"),
 853
 854        // company-aliases.csv
 855        new("company-aliases.csv", "alias", "stored in CompanyAlias.Alias"),
 856        new("company-aliases.csv", "canonical", "stored in CompanyAlias.Canonical"),
 857
 858        // postings.json
 859        new("postings.json", "added", "stored in Posting.CreatedAtUtc"),
 860        new("postings.json", "appliedLabel", "dropped by design"),
 861        new("postings.json", "comp", "stored in Posting.Compensation"),
 862        new("postings.json", "compHigh", "stored in Posting.CompHighPriority"),
 863        new("postings.json", "company", "stored in Company.Name / Posting.CompanyId"),
 864        new("postings.json", "culture", "stored in Posting.CultureSummary"),
 865        new("postings.json", "cultureLevel", "stored in Posting.CultureLevel"),
 866        new("postings.json", "first", "stored in Posting.CreatedAtUtc"),
 867        new("postings.json", "ghost", "stored in PostingSignals"),
 868        new("postings.json", "href", "stored in Posting.OriginalUrl"),
 869        new("postings.json", "loc", "stored in Posting.Location"),
 870        new("postings.json", "note", "stored in Note.Body / Posting.ScreeningNoteId"),
 871        new("postings.json", "order", "dropped by design"),
 872        new("postings.json", "parent", "stored in Company.Description"),
 873        new("postings.json", "posted", "stored in Posting.PostedAt"),
 874        new("postings.json", "score", "stored in Posting.Score"),
 875        new("postings.json", "status", "stored in Posting.Disposition"),
 876        new("postings.json", "tier", "dropped by design"),
 877        new("postings.json", "title", "stored in Posting.Title"),
 878    };
 79
 880    public static readonly ILookup<string, SourceFieldDefinition> ByFile =
 48881        AllFields.ToLookup(f => f.File, StringComparer.OrdinalIgnoreCase);
 82
 83    public static string GetHandling(string file, string field)
 84    {
 15085        var found = AllFields.FirstOrDefault(f =>
 489086            string.Equals(f.File, file, StringComparison.OrdinalIgnoreCase) &&
 489087            string.Equals(f.Field, field, StringComparison.OrdinalIgnoreCase));
 88
 15089        return found?.Handling ?? throw new KeyNotFoundException($"No source field mapping found for {file}:{field}");
 90    }
 91}