Closed Weakky closed 3 years ago
Adds the following functions/compares:
(fun) json_extract: extract a subset of a JSON blob given a JSON path/array of keys
json_extract
(compare) json_array_contains
json_array_contains
(compare) json_array_not_contains
json_array_not_contains
(compare) json_array_begins_with
json_array_begins_with
(compare) json_array_not_begins_with
json_array_not_begins_with
(compare) json_array_ends_into
json_array_ends_into
(compare) json_array_not_ends_into
json_array_not_ends_into
(compare) json_type_equals
json_type_equals
Works only on MySQL/PostgreSQL for now.
SQLite can be added in the future once it supports the JSON type. The migration team has work to do first, which needs to be planned
MSSQL can also be added in the future once it supports the JSON type.
Overview
Adds the following functions/compares:
(fun)
json_extract
: extract a subset of a JSON blob given a JSON path/array of keys(compare)
json_array_contains
(compare)
json_array_not_contains
(compare)
json_array_begins_with
(compare)
json_array_not_begins_with
(compare)
json_array_ends_into
(compare)
json_array_not_ends_into
(compare)
json_type_equals
Works only on MySQL/PostgreSQL for now.
SQLite can be added in the future once it supports the JSON type. The migration team has work to do first, which needs to be planned
MSSQL can also be added in the future once it supports the JSON type.