Files
imexrps/update-targets.md
2023-02-15 12:05:43 -08:00

371 lines
6.7 KiB
Markdown

mutation ($list: [targets_insert_input!]!)
{
insert_targets(objects: $list){
affected_rows
}
}
Variables:
{"list": [
{
"ins_co": "MPI",
"name": "V1",
"effective_date": "2019-01-01",
"end_date": "2023-03-31",
"ageGte": 0,
"ageLt": 3,
"group": "Group 1",
"target": 0.021
},
{
"ins_co": "MPI",
"name": "V1",
"effective_date": "2019-01-01",
"end_date": "2023-03-31",
"ageGte": 3,
"ageLt": 6,
"group": "Group 1",
"target": 0.072
},
{
"ins_co": "MPI",
"name": "V1",
"effective_date": "2019-01-01",
"end_date": "2023-03-31",
"ageGte": 6,
"ageLt": null,
"group": "Group 1",
"target": 0.105
},
{
"ins_co": "MPI",
"name": "V1",
"effective_date": "2019-01-01",
"end_date": "2023-03-31",
"ageGte": 0,
"ageLt": 3,
"group": "Group 2",
"target": 0.04
},
{
"ins_co": "MPI",
"name": "V1",
"effective_date": "2019-01-01",
"end_date": "2023-03-31",
"ageGte": 3,
"ageLt": 6,
"group": "Group 2",
"target": 0.117
},
{
"ins_co": "MPI",
"name": "V1",
"effective_date": "2019-01-01",
"end_date": "2023-03-31",
"ageGte": 6,
"ageLt": null,
"group": "Group 2",
"target": 0.187
},
{
"ins_co": "MPI",
"name": "V1",
"effective_date": "2019-01-01",
"end_date": "2023-03-31",
"ageGte": 0,
"ageLt": 3,
"group": "Group 3",
"target": 0.067
},
{
"ins_co": "MPI",
"name": "V1",
"effective_date": "2019-01-01",
"end_date": "2023-03-31",
"ageGte": 3,
"ageLt": 6,
"group": "Group 3",
"target": 0.166
},
{
"ins_co": "MPI",
"name": "V1",
"effective_date": "2019-01-01",
"end_date": "2023-03-31",
"ageGte": 6,
"ageLt": null,
"group": "Group 3",
"target": 0.232
},
{
"ins_co": "MPI",
"name": "V1",
"effective_date": "2019-01-01",
"end_date": "2023-03-31",
"ageGte": 0,
"ageLt": 3,
"group": "Group 4",
"target": 0.083
},
{
"ins_co": "MPI",
"name": "V1",
"effective_date": "2019-01-01",
"end_date": "2023-03-31",
"ageGte": 3,
"ageLt": 6,
"group": "Group 4",
"target": 0.195
},
{
"ins_co": "MPI",
"name": "V1",
"effective_date": "2019-01-01",
"end_date": "2023-03-31",
"ageGte": 6,
"ageLt": null,
"group": "Group 4",
"target": 0.274
},
{
"ins_co": "MPI",
"name": "V1",
"effective_date": "2019-01-01",
"end_date": "2023-03-31",
"ageGte": 0,
"ageLt": 3,
"group": "Group 5",
"target": 0.114
},
{
"ins_co": "MPI",
"name": "V1",
"effective_date": "2019-01-01",
"end_date": "2023-03-31",
"ageGte": 3,
"ageLt": 6,
"group": "Group 5",
"target": 0.25
},
{
"ins_co": "MPI",
"name": "V1",
"effective_date": "2019-01-01",
"end_date": "2023-03-31",
"ageGte": 6,
"ageLt": null,
"group": "Group 5",
"target": 0.307
},
{
"ins_co": "MPI",
"name": "V1",
"effective_date": "2019-01-01",
"end_date": "2023-03-31",
"ageGte": 0,
"ageLt": 3,
"group": "Group 6",
"target": 0.096
},
{
"ins_co": "MPI",
"name": "V1",
"effective_date": "2019-01-01",
"end_date": "2023-03-31",
"ageGte": 3,
"ageLt": 6,
"group": "Group 6",
"target": 0.256
},
{
"ins_co": "MPI",
"name": "V1",
"effective_date": "2019-01-01",
"end_date": "2023-03-31",
"ageGte": 6,
"ageLt": null,
"group": "Group 6",
"target": 0.318
},
{
"ins_co": "MPI",
"name": "V2",
"effective_date": "2023-04-01",
"end_date": null,
"ageGte": 0,
"ageLt": 3,
"group": "Group 1",
"target": 0.023
},
{
"ins_co": "MPI",
"name": "V2",
"effective_date": "2023-04-01",
"end_date": null,
"ageGte": 3,
"ageLt": 6,
"group": "Group 1",
"target": 0.077
},
{
"ins_co": "MPI",
"name": "V2",
"effective_date": "2023-04-01",
"end_date": null,
"ageGte": 6,
"ageLt": null,
"group": "Group 1",
"target": 0.109
},
{
"ins_co": "MPI",
"name": "V2",
"effective_date": "2023-04-01",
"end_date": null,
"ageGte": 0,
"ageLt": 3,
"group": "Group 2",
"target": 0.045
},
{
"ins_co": "MPI",
"name": "V2",
"effective_date": "2023-04-01",
"end_date": null,
"ageGte": 3,
"ageLt": 6,
"group": "Group 2",
"target": 0.125
},
{
"ins_co": "MPI",
"name": "V2",
"effective_date": "2023-04-01",
"end_date": null,
"ageGte": 6,
"ageLt": null,
"group": "Group 2",
"target": 0.193
},
{
"ins_co": "MPI",
"name": "V2",
"effective_date": "2023-04-01",
"end_date": null,
"ageGte": 0,
"ageLt": 3,
"group": "Group 3",
"target": 0.075
},
{
"ins_co": "MPI",
"name": "V2",
"effective_date": "2023-04-01",
"end_date": null,
"ageGte": 3,
"ageLt": 6,
"group": "Group 3",
"target": 0.176
},
{
"ins_co": "MPI",
"name": "V2",
"effective_date": "2023-04-01",
"end_date": null,
"ageGte": 6,
"ageLt": null,
"group": "Group 3",
"target": 0.238
},
{
"ins_co": "MPI",
"name": "V2",
"effective_date": "2023-04-01",
"end_date": null,
"ageGte": 0,
"ageLt": 3,
"group": "Group 4",
"target": 0.094
},
{
"ins_co": "MPI",
"name": "V2",
"effective_date": "2023-04-01",
"end_date": null,
"ageGte": 3,
"ageLt": 6,
"group": "Group 4",
"target": 0.205
},
{
"ins_co": "MPI",
"name": "V2",
"effective_date": "2023-04-01",
"end_date": null,
"ageGte": 6,
"ageLt": null,
"group": "Group 4",
"target": 0.281
},
{
"ins_co": "MPI",
"name": "V2",
"effective_date": "2023-04-01",
"end_date": null,
"ageGte": 0,
"ageLt": 3,
"group": "Group 5",
"target": 0.128
},
{
"ins_co": "MPI",
"name": "V2",
"effective_date": "2023-04-01",
"end_date": null,
"ageGte": 3,
"ageLt": 6,
"group": "Group 5",
"target": 0.259
},
{
"ins_co": "MPI",
"name": "V2",
"effective_date": "2023-04-01",
"end_date": null,
"ageGte": 6,
"ageLt": null,
"group": "Group 5",
"target": 0.313
},
{
"ins_co": "MPI",
"name": "V2",
"effective_date": "2023-04-01",
"end_date": null,
"ageGte": 0,
"ageLt": 3,
"group": "Group 6",
"target": 0.123
},
{
"ins_co": "MPI",
"name": "V2",
"effective_date": "2023-04-01",
"end_date": null,
"ageGte": 3,
"ageLt": 6,
"group": "Group 6",
"target": 0.262
},
{
"ins_co": "MPI",
"name": "V2",
"effective_date": "2023-04-01",
"end_date": null,
"ageGte": 6,
"ageLt": null,
"group": "Group 6",
"target": 0.32
}
]}