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 Nov 23, 2021
2 Jun 01, 2022
2 Apr 27, 2022
1 Jan 06, 2022
1 Jan 14, 2022
9 Dec 12, 2022
2.6k Jan 08, 2023
48 Nov 15, 2022
3 Jul 18, 2022
14 Dec 30, 2022
282 Dec 28, 2022
15 May 19, 2022
187 Dec 29, 2022
2 Aug 06, 2022
2.6k Jan 03, 2023
544 Dec 25, 2022
1 Nov 19, 2021
71 Oct 28, 2022
26 Nov 15, 2022
11 Mar 22, 2022