picsure-dictionary-etl/FacetLoader.http at main · hms-dbmi/picsure-dictionary-etl · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
### Facet Loader HTTP requests (IntelliJ HTTP Client)
# Adjust the host if your app runs on a different port (e.g., 8086 for Docker)
@host = http://localhost:8090

### Clear all Consortium_Curated_Facets
POST {{host}}/api/facet/loader/clear
Content-Type: application/json

{
  "Facet_Categories": ["Consortium_Curated_Facets"]
}

### Load Recover facets
POST {{host}}/api/facet/loader/load
Content-Type: application/json
Timeout: 99999999

[
  {
    "Facet_Category": {
      "Name": "Consortium_Curated_Facets",
      "Display": "Consortium Curated Facets",
      "Description": "Consortium Curated Facets Description",
      "Facets": [
        {
          "Name": "RECOVER Adult Curated",
          "Display": "RECOVER Adult Curated",
          "Description": "Recover adult parent facet.",
          "Study_ID": "phs003463",
          "Expression_Groups": [
            [
              { "exactly": "phs003463", "node": 0 },
              { "regex": "(?i)RECOVER_Adult$", "node": 1 }
            ]
          ],
          "Facets": [
            {
              "Name": "Infected",
              "Display": "Infected",
              "Description": "Infected Facet Description",
              "Expression_Groups": [
                [
                  { "regex": "(?i)^(?!.*non[\\W_]*(?:infected|inf)).*(?:infected|(?<![A-Za-z0-9])inf(?![A-Za-z0-9]))" }
                ]
              ]
            },
            {
              "Name": "Non-infected",
              "Display": "Non-infected",
              "Description": "Non-infected Facet Description",
              "Expression_Groups": [
                [
                  { "regex": "(?i)(?:^|[\\W_])non[\\W_]*(?:infected|inf)(?:[\\W_]|$)" }
                ]
              ]
            },
            {
              "Name": "PASC Status",
              "Display": "PASC Status",
              "Description": "PASC Status Facet Description",
              "Expression_Groups": [
                [
                  { "regex": "(?i)(pasc_pg2023|pasc_pg2024|pasc_jama2023|pasc_jama2024|pasc_cc_2024|visit_month_curr|infect_yn_curr)" }
                ]
              ]
            },
            {
              "Name": "Tests performed",
              "Display": "Tests performed",
              "Description": "Facet indicating whether specific tests were performed (yes/no flags).",
              "Expression_Groups": [
                [
                  { "regex": "(?i)(bmri_yn|chestct_yn|cmri_yn|cpet_yn|colon_yn|ekg_yn|compaudio_yn|rttestrain_yn|emg_yn|endopat_yn|facsleep_yn|fibro_yn|ent_yn|eye_yn|neuropsych_yn|ges_yn|noxisiess_yn|lumbar_yn|mini_yn|muscbx_yn|nervecond_yn|neuropath_yn|nihtool_yn|glucose_yn|plascatech_yn|pft_yn|comprehab_yn|renalultra_yn|rhcath_yn|sixmin_yn|skinbx_yn|tilt_yn|upsit_yn|vision_yn)" }
                ]
              ]
            }
          ]
        },
        {
          "Name": "RECOVER Pediatric Curated",
          "Display": "RECOVER Pediatric Curated",
          "Description": "Recover pediatrics parent facet.",
          "Study_ID": "phs003461",
          "Expression_Groups": [
            [
              { "exactly": "phs003461" }
            ]
          ],
          "Facets": [
            {
              "Name": "Caregiver",
              "Display": "Caregiver",
              "Description": "Facet for all Recover Pediatric Caregiver variables.",
              "Expression_Groups": [
                [
                  { "regex": "(?i)RECOVER_Caregiver$", "node": 1 }
                ]
              ]
            },
            {
              "Name": "Pediatric",
              "Display": "Pediatric",
              "Description": "Facet for all Recover Pediatric variables.",
              "Expression_Groups": [
                [
                  { "regex": "(?i)RECOVER_Pediatrics$", "node": 1 }
                ]
              ]
            },
            {
              "Name": "Congenital",
              "Display": "Congential",
              "Description": "Facet for all Recover Pediatric Congenital variables.",
              "Expression_Groups": [
                [
                  { "regex": "(?i)RECOVER_Congenital$", "node": 1 }
                ]
              ]
            }
          ]
        }
      ]
    }
  }
]

### Generate RECOVER Adult months facets (on-demand, nested under parent)
// @connection-timeout 5 m
POST {{host}}/api/facet/loader/recover/months/generate
Content-Type: application/json

{
  "dryRun": false
}

### Dry-run: discover months only, no DB changes

POST {{host}}/api/facet/loader/recover/months/generate
Content-Type: application/json

{
  "dryRun": true
}