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
}
1 Jan 31, 2022
195 Jan 04, 2023
25 Jan 05, 2023
64 Sep 18, 2022
2 Jan 03, 2022
263 Dec 23, 2022
1 Nov 08, 2021
5.7k Jan 04, 2023
646 Jan 07, 2023
361 Nov 16, 2022
4.1k Jan 06, 2023
6 Jun 10, 2022
1 Jan 17, 2022
106 Jan 05, 2023
14 Nov 07, 2022
4 May 23, 2022
3.4k Dec 30, 2022
2 Jan 21, 2022
8 Jun 15, 2022
0 Oct 10, 2021