I need someone to please create 3 ANTLR grammars to interchangeably convert between a TXT file, SQL file or a JSON file. Formats are attached.
On passing the text file to script it should output SQL and JSON files.
The SQL format should be able to execute on a MySQL db to successfully create a DB and the generated JSON should be validated on W3C validator.
2. Passing SQL output from step 1 to the script, it should be able to recreate the TXT file exactly similar to the original and a JSON file exactly same as the one from Step1
3. On Passing JSON output from step 1 to the script, it should be able to recreate the TXT file as the original was and a SQL file exactly same as the one from Step1
If the above 3 criteria are met for a set of 3 test files, this work will be accepted.
Note: The SQL and JSON files attached are only indicative to share structure and have not been tested. This will not affect the acceptance criteria.