Collections:
JSON_SCHEMA_VALIDATION_REPORT() - JSON Schema Validation Report
How to generate a validation report of a JSON value against a JSON schema using the JSON_SCHEMA_VALIDATION_REPORT() function?
✍: FYIcenter.com
JSON_SCHEMA_VALIDATION_REPORT(schema, json) is a MySQL built-in function that returns a validation report of a JSON value against a given JSON schema. The report itself is a JSON object. For example:
SET @schema = '{ "id": "http://json-schema.org/geo", "$schema": "http://json-schema.org/draft-04/schema#", "description": "A geographical coordinate", "type": "object", "properties": { "latitude": { "type": "number" }, "longitude": { "type": "number" } }, "required": ["latitude", "longitude"] }'; SET @document = '{"latitude": 63.444697, "longitude": 10.445118}'; SELECT JSON_SCHEMA_VALIDATION_REPORT(@schema, @document); -- +---------------------------------------------------+ -- | JSON_SCHEMA_VALIDATION_REPORT(@schema, @document) | -- +---------------------------------------------------+ -- | {"valid": true} | -- +---------------------------------------------------+ SELECT JSON_SCHEMA_VALIDATION_REPORT(@schema, '{"latitude": 63.444697}'); -- +-----------------------------------------------------------------------+ -- | JSON_SCHEMA_VALIDATION_REPORT(@schema, '{"latitude": 63.444697}') | -- +-----------------------------------------------------------------------+ -- | {"valid": false, "reason": "The JSON document location '#' failed requirement 'required' at JSON Schema location '#'", "schema-location": "#", "document-location": "#", "schema-failed-keyword": "required"} | -- +-----------------------------------------------------------------------+
Reference information of the JSON_SCHEMA_VALIDATION_REPORT() function:
JSON_SCHEMA_VALIDATION_REPORT(schema, json): report Returns a validation report of a JSON value against a given JSON schema. Arguments, return value and availability: schema: Required. The JSON schema to validate against. json: Required. The JSON value to be validated. report: Return value. The validation report as a JSON object. Available since MySQL 8.0.
Related MySQL functions:
⇒ JSON_SEARCH() - Searching String in JSON
⇐ JSON_SCHEMA_VALID() - JSON Schema Validation
2023-12-15, 221🔥, 0💬
Popular Posts:
What Is ISAM in MySQL? ISAM (Indexed Sequential Access Method) was developed by IBM to store and ret...
What are single-byte character string data types supported in SQL Server Transact-SQL? Single-byte c...
How To Use DATEADD() Function in SQL Server Transact-SQL? DATEADD() is a very useful function for ma...
Where to find answers to frequently asked questions on PHP Connections and Query Execution for MySQL...
How To Convert Binary Strings into Hexadecimal Character Strings in SQL Server? When a query returns...