JSON Schema Generator
Author : Eru Michael
About
A Json Schema Generator.
This is a generic program that:
- Reads a JSON file similar to what's present in this location (./data/)
- Sniffs the schema of the JSON file
- Dumps the output in (./schema/)
The schema output captures ONLY the attributes within the "message" key of the input JSON source data. All attributes within the key "attributes" were excluded.
For the json data types:
The program identifies what a string is and maps accordingly to a JSON schema output, it also identifies what an INTEGER is and maps accordingly to a JSON schema output, when the value in an array is a STRING, the program maps the data type as an ENUM and when the value in an array is another JSON object, the program maps the data type as an ARRAY.
Dependencies
json, collections, unittest, sys, os
Example
From the json data in data_2.json, the data structure is shown below.
{
"attributes": {
"appName": "ABCDEFGHIJKLMNOPQRSTUVW",
"eventType": "ABCDEFGHIJKLMNOPQRSTUVWXYZ",
"subEventType": "ABCDEFGHIJKLMNO",
"sensitive": false
},
"message": {
"user": {
"id": "ABCDEFGHIJKLMNOP",
"nickname": "ABCD",
"title": "ABCDEFGHIJKLMNOPQRSTUVWXYZABC",
"accountType": "ABCDEFGHIJKLMNOPQRSTUVWX",
"countryCode": "ABCDEFGHIJKLMNOPQRSTUVWX",
"orientation": "ABCDEFGHIJKLMNOPQRSTU"
},
"time": 890,
"acl": [],
"publicFeed": false,
"internationalCountries":
[
"ABCDEFGHIJKLMNOPQRSTUVWXYZA",
"ABCDEFGHIJKLMNOPQ",
"ABCDEFGHIJKLMNOPQRSTUVW",
"ABCDEFGHIJKLMNOPQRSTUVWXY",
"ABCDEFGHIJK",
"ABCDEFGHIJKLMNOPQRSTUVWXYZ",
"ABCDEFGHIJKLMNOPQR",
"ABCDEFG",
"ABCDEFGHIJKLM"
],
"topTraderFeed": true
}
}
it should generate a json schema as :
},
"user": {
"id": {
"type": "string",
"tag": "",
"description": "",
"required": false
},
"nickname": {
"type": "string",
"tag": "",
"description": "",
"required": false
},
"title": {
"type": "string",
"tag": "",
"description": "",
"required": false
},
"accountType": {
"type": "string",
"tag": "",
"description": "",
"required": false
},
"countryCode": {
"type": "string",
"tag": "",
"description": "",
"required": false
},
"orientation": {
"type": "string",
"tag": "",
"description": "",
"required": false
}
},
"time": {
"type": "integer",
"tag": "",
"description": "",
"required": false
},
"acl": null,
"publicFeed": null,
"internationalCountries": {
"type": "enum",
"tag": "",
"description": "",
"required": false
},
"topTraderFeed": null
}
4 Nov 22, 2022
584 Nov 16, 2022
21 Dec 24, 2022
4 Nov 24, 2022
2 Feb 14, 2022
2 Jan 31, 2022
3 Oct 12, 2021
2 Dec 02, 2021
1 Dec 17, 2021
38 Feb 26, 2022
1 Jan 06, 2022
10 Oct 06, 2022
10 May 20, 2022
470 Dec 28, 2022
7.8k Jan 05, 2023
15 Dec 21, 2022
4 Feb 14, 2022
1 Jan 04, 2022
6 Jun 10, 2022
2.6k Jan 08, 2023