bulk-update.schema.json
{
"$schema": "https://json-schema.org/draft/2020-12/schema",
"type": "object",
"additionalProperties": false,
"required": [
"from",
"set"
],
"properties": {
"from": {
"type": "string",
"minLength": 1
},
"where": {
"$ref": "#/$defs/Filter"
},
"set": {
"type": "object",
"minProperties": 1,
"additionalProperties": {
"$ref": "#/$defs/Data"
}
}
},
"$defs": {
"Data": {
"anyOf": [
{
"type": [
"string",
"number",
"integer",
"boolean",
"null"
]
},
{
"type": "array",
"items": {
"$ref": "#/$defs/Data"
}
},
{
"type": "object",
"additionalProperties": {
"$ref": "#/$defs/Data"
}
}
]
},
"Filter": {
"type": "object",
"properties": {
"and": {
"type": "array",
"minItems": 1,
"items": {
"$ref": "#/$defs/Filter"
}
},
"or": {
"type": "array",
"minItems": 1,
"items": {
"$ref": "#/$defs/Filter"
}
}
},
"additionalProperties": {
"anyOf": [
{
"type": [
"string",
"number",
"boolean"
]
},
{
"$ref": "#/$defs/Predicate"
}
]
}
},
"Predicate": {
"type": "object",
"additionalProperties": false,
"properties": {
"op": {
"enum": [
"eq",
"neq",
"gt",
"gte",
"lt",
"lte",
"nil",
"nnil",
"in",
"nin",
"btw",
"nbtw",
"like",
"ilike",
"overlap",
"contains",
"containedBy"
]
},
"fn": {
"enum": [
"BeforeNow",
"AfterNow",
"ThisMinute",
"ThisHour",
"Today",
"ThisWeek",
"ThisMonth",
"ThisYear",
"LastNMinutes",
"LastNHours",
"LastNDays",
"LastNWeeks",
"LastNMonths",
"LastNYears",
"NamedHour",
"NamedDayOfWeek",
"NamedDay",
"NamedMonth",
"NamedYear",
"StartOfDay",
"EndOfDay",
"LastMonth",
"WeekToDate",
"MonthToDate",
"QuarterToDate",
"YearToDate"
]
},
"value": {
"$ref": "#/$defs/Data"
},
"negate": {
"type": "boolean"
}
},
"oneOf": [
{
"required": [
"op"
],
"not": {
"required": [
"fn"
]
}
},
{
"required": [
"fn"
],
"not": {
"required": [
"op"
]
}
}
],
"allOf": [
{
"if": {
"required": [
"op"
],
"properties": {
"op": {
"enum": [
"nil",
"nnil"
]
}
}
},
"then": {
"not": {
"required": [
"value"
]
}
},
"else": {
"if": {
"required": [
"op"
]
},
"then": {
"required": [
"value"
]
}
}
},
{
"if": {
"required": [
"op"
],
"properties": {
"op": {
"enum": [
"in",
"nin"
]
}
}
},
"then": {
"properties": {
"value": {
"type": "array",
"minItems": 1
}
}
}
},
{
"if": {
"required": [
"op"
],
"properties": {
"op": {
"enum": [
"btw",
"nbtw"
]
}
}
},
"then": {
"properties": {
"value": {
"type": "array",
"minItems": 2,
"maxItems": 2
}
}
}
},
{
"if": {
"required": [
"op"
],
"properties": {
"op": {
"enum": [
"like",
"ilike"
]
}
}
},
"then": {
"properties": {
"value": {
"type": "string"
}
}
}
},
{
"if": {
"required": [
"op"
],
"properties": {
"op": {
"enum": [
"overlap",
"contains",
"containedBy"
]
}
}
},
"then": {
"properties": {
"value": {
"type": "array"
}
}
}
},
{
"if": {
"required": [
"fn"
],
"properties": {
"fn": {
"pattern": "^LastN"
}
}
},
"then": {
"required": [
"value"
],
"properties": {
"value": {
"type": "integer",
"minimum": 1
}
}
}
},
{
"if": {
"required": [
"fn"
],
"properties": {
"fn": {
"const": "NamedHour"
}
}
},
"then": {
"required": [
"value"
],
"properties": {
"value": {
"type": "integer",
"minimum": 0,
"maximum": 23
}
}
}
},
{
"if": {
"required": [
"fn"
],
"properties": {
"fn": {
"const": "NamedDayOfWeek"
}
}
},
"then": {
"required": [
"value"
],
"properties": {
"value": {
"type": "integer",
"minimum": 1,
"maximum": 7
}
}
}
},
{
"if": {
"required": [
"fn"
],
"properties": {
"fn": {
"const": "NamedDay"
}
}
},
"then": {
"required": [
"value"
],
"properties": {
"value": {
"type": "integer",
"minimum": 1,
"maximum": 31
}
}
}
},
{
"if": {
"required": [
"fn"
],
"properties": {
"fn": {
"const": "NamedMonth"
}
}
},
"then": {
"required": [
"value"
],
"properties": {
"value": {
"type": "integer",
"minimum": 1,
"maximum": 12
}
}
}
},
{
"if": {
"required": [
"fn"
],
"properties": {
"fn": {
"const": "NamedYear"
}
}
},
"then": {
"required": [
"value"
],
"properties": {
"value": {
"type": "integer"
}
}
}
}
]
}
}
}