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"
              }
            }
          }
        }
      ]
    }
  }
}

Search AISDL

Search the paper, references and contracts.