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
}
2 Aug 06, 2022
1 Nov 08, 2021
1.7k Dec 31, 2022
1 Jan 22, 2022
266 Jan 02, 2023
17.7k Jan 07, 2023
3 Jan 06, 2022
0 Jul 15, 2021
7 Mar 19, 2022
2 Jan 03, 2022
41 Dec 31, 2022
357 Dec 26, 2022
1 Jun 18, 2022
1 Jan 10, 2022
155 Sep 20, 2022
198 Jan 03, 2023
12.3k Jan 04, 2023
24.5k Jan 09, 2023
188 Dec 30, 2022
60 Nov 16, 2022